Data Warehouse Solution

What makes many companies failed on their data warehouse project? What is the important aspect to implement Data Warehouse Solution? This humble Data Warehouse Solution Review site will try to provide those simple answers


Archive for the ‘Open source Data warehouse’ tag

How to Install Greenplum Database 3.3

without comments

We got the how to install Greenplum 3.3 from the Greenplum Documentation.  Here are the steps to install and initialize Greenplum Database system.

  1. Run the installer on the Greenplum Database master host.
  2. As root, set the OS tuning parameters for your platform on all Greenplum hosts.
  3. Allocate a gpadmin user to own and run your installation. This user must exist on all Greenplum hosts.
  4. Source the greenplum_path.sh file in your gpadmin user profile (.bashrc). This sets the environment variables needed by Greenplum Database.
  5. Create your data directory locations on all Greenplum hosts.
  6. Use the gpssh-exkeys utility to exchange SSH keys between all hosts in your Greenplum array. Note that for a single host demo configuration you still must exchange ssh keys between the current host and itself.
  7. (multi-host configuration only) Use the gpscp and gpssh utilities to copy and install the Greenplum Database software on all segment hosts.
  8. Use the gpinitsystem utility to initialize and start your Greenplum Database system. This utility requires a configuration file.

For example:  gpinitsystem -c gp_init_config

A sample gp_init_config configuration file can be found in $GPHOME/docs/cli_help/gp_init_config_example

Edit this file to reflect your desired Greenplum Database array configuration.

Greenplum Network Registration

Similar Posts:

    None Found

Written by Admin

June 25th, 2009 at 3:01 am