Installing Greenplum Database

Note:

Installing Greenplum Community edition (CE). Here are the step by step  instructions on how to install the Greenplum Database CE software and get your single-node Greenplum Database system up and running. 

Before installing we have to change following OS configuration parameters:

----------------

LINUX

---------------

In /etc/sysctl.conf: 

sysctl.kernel.shmmax = 500000000

sysctl.kernel.shmmni = 4096

sysctl.kernel.shmall = 4000000000

sysctl.kernel.sem = 250 512000 100 2048

sysctl.kernel.sysrq = 1

sysctl.kernel.core_uses_pid = 1

sysctl.kernel.msgmnb = 65536

sysctl.kernel.msgmax = 65536

sysctl.kernel.msgmni = 2048

sysctl.net.ipv4.tcp_syncookies = 1

sysctl.net.ipv4.ip_forward = 0

sysctl.net.ipv4.conf.default.accept_source_route = 0

sysctl.net.ipv4.tcp_tw_recycle = 1

sysctl.net.ipv4.tcp_max_syn_backlog = 4096

sysctl.net.ipv4.conf.all.arp_filter = 1

sysctl.net.ipv4.ip_local_port_range = 1025 65535

sysctl.net.core.netdev_max_backlog = 10000

sysctl.vm.overcommit_memory = 2

For RHEL version 6.x platforms, do not include the sysctl. prefix in the above parameters, as follows:

xfs_mount_options = rw,noatime,inode64,allocsize=16m

kernel.shmmax = 500000000

kernel.shmmni = 4096

kernel.shmall = 4000000000

kernel.sem = 250 512000 100 2048

kernel.sysrq = 1

kernel.core_uses_pid = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.msgmni = 2048

net.ipv4.tcp_syncookies = 1

net.ipv4.ip_forward = 0

net.ipv4.conf.default.accept_source_route = 0

net.ipv4.tcp_tw_recycle = 1

net.ipv4.tcp_max_syn_backlog = 4096

net.ipv4.conf.all.arp_filter = 1

net.ipv4.ip_local_port_range = 1025 65535

net.core.netdev_max_backlog = 10000

vm.overcommit_memory = 2

In /etc/security/limits.conf: 

* soft nofile 65536  

* hard nofile 65536  

* soft nproc 131072 

* hard nproc 131072 

OPTIONAL

==================================================================================================================

In /etc/hosts:

Include the host names and all interface address names for every machine participating in your Greenplum Database system.

File system recommendations: XFS is the preferred file system on Linux platforms for data storage. Greenplum recommends the following xfs mount options:

rw,noatime,inode64,allocsize=16m

Also, each disk device file should have a read-ahead value of 16384.  For example, to verify the read-ahead value of a disk device:

# /sbin/blockdev --getra /dev/sdb

=================================================================================================================

Add the Greenplum database Admin account:

# useradd gpadmin

# passwd gpadmin

# New password: password

# Retype new password: password

You cannot run the Greenplum Database SNE server as root. While dealing with Greenplum use this newly created user account

Installing the Greenplum Database Community edition (CE):

1. Download or copy the Greenplum Database CE from www.greenplum.com/

2. Unzip the installer file:

# unzip greenplum-db-4.2.2.4-build-1-CE-RHEL5-x86_64.bin

3. Launch the installer using bash:

# /bin/bash greenplum-db-4.0.0.0-build-#-SingleNodeEdition-PLATFORM.bin

4. The installer prompts you to provide an installation path. Press ENTER to accept the default install path (/usr/local/greenplum-db-4.0.0.0), or enter new path

5. The installer installs the Greenplum Database CE software and creates a greenplum-db symbolic link one directory level above your version-specific Greenplum Database 

6. Change the ownership of your Greenplum Database SNE installation so that it is owned by the gpadmin

# chown -R gpadmin /usr/local/greenplum-db-4.0.0.0

# chgrp -R gpadmin /usr/local/greenplum-db-4.0.0.0

7. Preparing the Data Directory Locations

Every Greenplum Database SNE instance has a designated storage area on disk that is called the data directory location.

8. Create or choose a directory that will serve as your master data storage area

On this location user data is not stored, instead metadata (data about the data) is stored. Here global system catalog resides

# mkdir /gpmaster

# chown gpadmin /gpmaster

# chgrp gpadmin /gpmaster

9. Create or choose the directories that will serve as your segment storage areas:

This is the file system location where the database data is stored.

# mkdir /gpdata1

# chown gpadmin /gpdata1

# chgrp gpadmin /gpdata1

# mkdir /gpdata2

# chown gpadmin /gpdata2

# chgrp gpadmin /gpdata2

10. Configuring Greenplum Database SNE / CE Environment Variables:

$ vi .bashrc

Then add following entry

source /usr/local/greenplum-db/greenplum_path.sh

now source it

$ source ~/.bashrc

11. Now let’s initialize Greenplum database:

Greenplum provides a utility called gpinitsystem which initializes a Greenplum Database system. After the Greenplum Database SNE system is initialized and started, you can then create and manage databases by connecting to the Greenplum master database process.

12. Log in to the system as the gpadmin user:

# su - gpadmin

13. Copy the single_hostlist example file from your Greenplum Database installation to the current directory:

$ cp /usr/local/greenplum-db/docs/cli_help/gpconfigs/hostlist_singlenode .

14. Copy the gp_init_singlenode example file from your Greenplum Database SNE installation to the current directory:

$ cp /usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_singlenode .

15. Edit the gp_init_singlenode file and enter your configuration settings, you can remain them default. Some default parameters in this file are:

ARRAY_NAME="GPDB SNE"

MACHINE_LIST_FILE=./hostlist_singlenode

SEG_PREFIX=gpsne

PORT_BASE=50000

declare -a DATA_DIRECTORY=(/disk1/gpdata1 /disk2//gpdata2)

MASTER_HOSTNAME=sachi

MASTER_DIRECTORY=/home/gpmaster

MASTER_PORT=5432

16. Run the gpssh-exkeys utility to exchange ssh keys for the local host:

$ gpssh-exkeys -h sachi

[gpadmin@dbaref ~]$  gpssh-exkeys -h dbaref

[STEP 1 of 5] create local ID and authorize on local host

[ERROR dbaref] authentication check failed:

     ssh: connect to host dbaref port 22: Connection refused

[ERROR] cannot establish ssh access into the local host

to overcome this issue

1. Disable firewall

2. start sshd service if not started

[root@dbaref Downloads]# /sbin/service sshd status

Redirecting to /bin/systemctl  status sshd.service

sshd.service - OpenSSH server daemon.

      Loaded: loaded (/lib/systemd/system/sshd.service; disabled)

      Active: inactive (dead)

      CGroup: name=systemd:/system/sshd.service

[root@dbaref Downloads]# /sbin/service sshd start

Redirecting to /bin/systemctl  start sshd.service

[root@dbaref Downloads]# /sbin/service sshd status

Redirecting to /bin/systemctl  status sshd.service

sshd.service - OpenSSH server daemon.

      Loaded: loaded (/lib/systemd/system/sshd.service; disabled)

      Active: active (running) since Mon, 20 May 2013 08:45:07 -0400; 5s ago

    Main PID: 2764 (sshd)

      CGroup: name=systemd:/system/sshd.service

          └ 2764 /usr/sbin/sshd -D

[root@dbaref Downloads]# 

Now su to gpadmin and run it again

[gpadmin@dbaref ~]$  gpssh-exkeys -h dbaref

[STEP 1 of 5] create local ID and authorize on local host

  ... /home/gpadmin/.ssh/id_rsa file exists ... key generation skipped

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] authorize current user on remote hosts

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts

[INFO] completed successfully

[gpadmin@dbaref ~]$ 

======================================================================

Note: I have struggled with this many times. Here is one more option.

[root@sachi ~]# mkdir /etc/ssh/gpadmin

[root@sachi ~]# cp /home/gpadmin/.ssh/authorized_keys /etc/ssh/gpadmin/

[root@sachi ~]# chown -R gpadmin:gpadmin /etc/ssh/gpadmin

[root@sachi ~]# chmod 755 /etc/ssh/gpadmin

[root@sachi ~]# chmod 644 /etc/ssh/gpadmin/authorized_keys

[root@sachi ~]# vi /etc/ssh/sshd_config 

#RSAAuthentication yes

#PubkeyAuthentication yes

# changed .ssh/authorized_keys to /etc/ssh/gpadmin/authorized_keys <<<<<<<

AuthorizedKeysFile      /etc/ssh/gpadmin/authorized_keys

#AuthorizedKeysCommand none

#AuthorizedKeysCommandRunAs nobody

Reboot the server

======================================================================

17. initialize Greenplum Database SNE:

$ gpinitsystem -c gpinitsystem_singlenode

[gpadmin@sachi ~]$ gpinitsystem -c gpinitsystem_singlenode 

20130423:19:53:54:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20130423:19:53:54:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_singlenode

20130423:19:53:54:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_singlenode, will set to default value

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Locale set to en_US.utf8

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checking configuration parameters, Completed

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

.

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Configuring build for standard array

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20130423:19:53:55:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Building primary segment instance array, please wait...

..

20130423:19:53:56:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checking Master host

20130423:19:53:56:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checking new segment hosts, please wait...

..

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checking new segment hosts, Completed

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Greenplum Database Creation Parameters

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:---------------------------------------

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master Configuration

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:---------------------------------------

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master instance name       = GPDB SINGLENODE

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master hostname            = sachi

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master port                = 5432

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master instance dir        = /home/gpmaster/gpsne-1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Greenplum segment prefix   = gpsne

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master Database            = 

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master connections         = 250

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master buffers             = 128000kB

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Segment connections        = 750

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Segment buffers            = 128000kB

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Checkpoint segments        = 8

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Encoding                   = UNICODE

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Postgres param file        = Off

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db/./bin/initdb

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db/./lib

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Ulimit check               = Passed

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Array host connect type    = Single hostname per node

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [1]      = ::1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [2]      = 172.16.72.1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [3]      = 192.168.122.1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [4]      = 192.168.133.1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [5]      = 192.168.1.6

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [6]      = fe80::250:56ff:fec0:1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [7]      = fe80::250:56ff:fec0:8

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Master IP address [8]      = fe80::8e89:a5ff:fe80:f8e6

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Standby Master             = Not Configured

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Primary segment #          = 2

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Total Database segments    = 2

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Trusted shell              = ssh

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Number segment hosts       = 1

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Mirroring config           = OFF

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:----------------------------------------

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:----------------------------------------

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-sachi     /disk1/gpdata1/gpsne0     40000     2     0

20130423:19:53:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-sachi     /disk2/gpdata2/gpsne1     40001     3     1

Continue with Greenplum creation Yy/Nn>

Y

20130423:19:54:13:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Building the Master instance database, please wait...

20130423:19:55:19:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Starting the Master in admin mode

20130423:19:55:39:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Commencing parallel build of primary segment instances

20130423:19:55:39:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

..

20130423:19:55:39:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

...........................................................................................................................................

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:------------------------------------------------

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Parallel process exit status

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:------------------------------------------------

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Total processes marked as completed           = 2

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Total processes marked as killed              = 0

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Total processes marked as failed              = 0

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:------------------------------------------------

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Deleting distributed backout files

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Removing back out file

20130423:19:57:59:004006 gpinitsystem:sachi:gpadmin-[INFO]:-No errors generated from parallel processes

20130423:19:58:00:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /home/gpmaster/gpsne-1

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Gathering information and validating the environment...

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-There are 0 connections to the database

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Master host=sachi

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate

20130423:19:58:00:016987 gpstop:sachi:gpadmin-[INFO]:-Master segment instance directory=/home/gpmaster/gpsne-1

20130423:19:58:01:017070 gpstart:sachi:gpadmin-[INFO]:-Starting gpstart with args: -a -d /home/gpmaster/gpsne-1

20130423:19:58:01:017070 gpstart:sachi:gpadmin-[INFO]:-Gathering information and validating the environment...

20130423:19:58:01:017070 gpstart:sachi:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20130423:19:58:01:017070 gpstart:sachi:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'

20130423:19:58:01:017070 gpstart:sachi:gpadmin-[INFO]:-Starting Master instance in admin mode

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Setting new master era

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Master Started...

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Checking for filespace consistency

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-Obtaining current filespace entries used by TRANSACTION_FILES

20130423:19:58:02:017070 gpstart:sachi:gpadmin-[INFO]:-TRANSACTION_FILES OIDs are consistent for pg_system filespace

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-TRANSACTION_FILES entries are consistent for pg_system filespace

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-Checking for filespace consistency

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-TEMPORARY_FILES OIDs are consistent for pg_system filespace

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-TEMPORARY_FILES entries are consistent for pg_system filespace

20130423:19:58:03:017070 gpstart:sachi:gpadmin-[INFO]:-Shutting down master

20130423:19:58:04:017070 gpstart:sachi:gpadmin-[INFO]:-No standby master configured.  skipping...

20130423:19:58:04:017070 gpstart:sachi:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-Process results...

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-   Successful segment starts                                            = 2

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-   Failed segment starts                                                = 0

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances 

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-----------------------------------------------------

20130423:19:58:06:017070 gpstart:sachi:gpadmin-[INFO]:-Starting Master instance sachi directory /home/gpmaster/gpsne-1 

20130423:19:58:08:017070 gpstart:sachi:gpadmin-[INFO]:-Command pg_ctl reports Master sachi instance active

20130423:19:58:08:017070 gpstart:sachi:gpadmin-[INFO]:-Database successfully started

20130423:19:58:08:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode

20130423:19:58:08:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Loading gp_toolkit...

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Scanning utility log file for any warning messages

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[WARN]:-*******************************************************

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[WARN]:-were generated during the array creation

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Please review contents of log file

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20130423.log

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-To determine level of criticality

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[WARN]:-*******************************************************

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Greenplum Database instance successfully created

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-------------------------------------------------------

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-To complete the environment configuration, please 

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-update gpadmin .bashrc file with the following

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/home/gpmaster/gpsne-1"

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-   or, use -d /home/gpmaster/gpsne-1 option for the Greenplum scripts

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-   Example gpstate -d /home/gpmaster/gpsne-1

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20130423.log

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Review options for gpinitstandby

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-------------------------------------------------------

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-The Master /home/gpmaster/gpsne-1/pg_hba.conf post gpinitsystem

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-has been configured to allow all hosts within this new

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-new array must be explicitly added to this file

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory

20130423:19:58:10:004006 gpinitsystem:sachi:gpadmin-[INFO]:-------------------------------------------------------

[gpadmin@sachi ~]$ pwd

/home/gpadmin

[gpadmin@sachi ~]$ 

18. After the Greenplum Database SNE system is initialized and started, you can connect to the Greenplum master database process using the psql client program:

$ createdb mydb

$ psql mydb

19. Now export master data directory:

$ vi .bashrc

Then add following entry

export MASTER_DATA_DIRECTORY=/gpmaster/gpsne-1

now source it

$ source ~/.bashrc

20. Now you can perform any database operations using psql program (DDL, DML)

Uninstall Greenplum:

To uninstall run the following commands:

$ gpdeletesystem -d /gpmaster/gpsne-1

$ rm -rf /usr/local/greenplum-db-4.0.0.0

$ rm /usr/local/greenplum-db

You can remove the environment variable and restore the default setting of OS parameters(Optional)