Data Warehouse Solution

We will start 2010 post in this blog by step by step guide to install green plum client in your computer.  Here we use windows platform for the client.

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 open source data warehouse 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.

The object-relational database management system known as PostgreSQL is derived from the POSTGRES package written at the University of California at Berkeley. With almost three decades of development behind it, PostgreSQL is now the most advanced open-source database available.
Greenplum Database is built upon the PostgreSQL 8.2.5 code base and has many similarities to PostgreSQL. For example, many of the client and server applications, configuration files, supported SQL commands, and syntax will be the same or very similar to PostgreSQL.
Greenplum Database is essentially several PostgreSQL instances acting as one cohesive database management system. The internals of PostgreSQL have been modified or supplemented to support the parallel structure of Greenplum Database. For example the system catalog has been supplemented to track all of the segment instances that comprise a Greenplum database. The query parser, query planner, query optimizer, and query executor processes have been modified and enhanced to be able to execute queries in parallel across all of the segments.
Data Query and Manipulation Language (DQL/DML) is essentially supported as it is in PostgreSQL. SELECT, INSERT, UPDATE, and DELETE are DQL/DML commands. All other SQL commands are considered Data Definition Language (DDL) or utility commands. Most DDL and utility SQL statements are supported in Greenplum Database as they are in PostgreSQL, with a few minor exceptions. See “SQL Support” on page 24 for more information.