We have migrated to new Google sites!
Post date: Apr 23, 2013 7:15:13 PM
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)
Update: Installing Greenplum 4.3.5.1
[gpadmin@localhost gpconfigs]$ pwd
/usr/local/greenplum-db/docs/cli_help/gpconfigs
[gpadmin@localhost gpconfigs]$ cp hostlist_singlenode /usr/local/greenplum-db
[gpadmin@localhost gpconfigs]$
[gpadmin@localhost greenplum-db]$ ls
bin demo docs etc ext GPDB-LICENSE.txt gpinitsystem_singlenode greenplum_path.sh hostlist_singlenode hosts.seg include lib LICENSE.thirdparty sbin share
[gpadmin@localhost greenplum-db]$ cat hostlist_singlenode
localhost
[gpadmin@localhost greenplum-db]$ cat gpinitsystem_singlenode
# FILE NAME: gpinitsystem_singlenode
# A configuration file is needed by the gpinitsystem utility.
# This sample file initializes a Greenplum Database Single Node
# Edition (SNE) system with one master and two segment instances
# on the local host. This file is referenced when you run gpinitsystem.
################################################
# REQUIRED PARAMETERS
################################################
# A name for the array you are configuring. You can use any name you
# like. Enclose the name in quotes if the name contains spaces.
ARRAY_NAME="GPDB SINGLENODE"
# This specifies the file that contains the list of segment host names
# that comprise the Greenplum system. For a single-node system, this
# file contains the local OS-configured hostname (as output by the
# hostname command). If the file does not reside in the same
# directory where the gpinitsystem utility is executed, specify
# the absolute path to the file.
MACHINE_LIST_FILE=./hostlist_singlenode
# This specifies a prefix that will be used to name the data directories
# of the master and segment instances. The naming convention for data
# directories in a Greenplum Database system is SEG_PREFIX<number>
# where <number> starts with 0 for segment instances and the master
# is always -1. So for example, if you choose the prefix gpsne, your
# master instance data directory would be named gpsne-1, and the segment
# instances would be named gpsne0, gpsne1, gpsne2, gpsne3, and so on.
SEG_PREFIX=gpsne
# Base port number on which primary segment instances will be
# started on a segment host. The base port number will be
# incremented by one for each segment instance started on a host.
PORT_BASE=40000
# This specifies the data storage location(s) where the script will
# create the primary segment data directories. The script creates a
# unique data directory for each segment instance. If you want multiple
# segment instances per host, list a data storage area for each primary
# segment you want created. The recommended number is one primary segment
# per CPU. It is OK to list the same data storage area multiple times
# if you want your data directories created in the same location. The
# number of data directory locations specified will determine the number
# of primary segment instances created per host.
# You must make sure that the user who runs gpinitsystem (for example,
# the gpadmin user) has permissions to write to these directories. You
# may want to create these directories on the segment hosts before running
# gpinitsystem and chown them to the appropriate user.
declare -a DATA_DIRECTORY=(/gpdata1 /gpdata2)
# The OS-configured hostname of the Greenplum Database master instance.
MASTER_HOSTNAME=localhost
# The location where the data directory will be created on the
# Greenplum master host.
# You must make sure that the user who runs gpinitsystem
# has permissions to write to this directory. You may want to
# create this directory on the master host before running
# gpinitsystem and chown it to the appropriate user.
MASTER_DIRECTORY=/gpmaster
# The port number for the master instance. This is the port number
# that users and client connections will use when accessing the
# Greenplum Database system.
MASTER_PORT=5432
# The shell the gpinitsystem script uses to execute
# commands on remote hosts. Allowed value is ssh. You must set up
# your trusted host environment before running the gpinitsystem
# script. You can use gpssh-exkeys to do this.
TRUSTED_SHELL=ssh
# Maximum distance between automatic write ahead log (WAL)
# checkpoints, in log file segments (each segment is normally 16
# megabytes). This will set the checkpoint_segments parameter
# in the postgresql.conf file for each segment instance in the
# Greenplum Database system.
CHECK_POINT_SEGMENTS=8
# The character set encoding to use. Greenplum supports the
# same character sets as PostgreSQL. See 'Character Set Support'
# in the PostgreSQL documentation for allowed character sets.
# Should correspond to the OS locale specified with the
# gpinitsystem -n option.
ENCODING=UNICODE
################################################
# OPTIONAL PARAMETERS
################################################
# Optional. Uncomment to create a database of this name after the
# system is initialized. You can always create a database later using
# the CREATE DATABASE command or the createdb script.
#DATABASE_NAME=warehouse
[gpadmin@localhost greenplum-db]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#192.168.1.253 sachi sachi.localdomain
[gpadmin@localhost greenplum-db]$
[gpadmin@localhost greenplum-db]$ gpinitsystem -c hostlist_singlenode
20150523:19:53:01:006471 gpinitsystem:localhost:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20150523:19:53:01:006471 gpinitsystem:localhost:gpadmin-[INFO]:-Reading Greenplum configuration file hostlist_singlenode
hostlist_singlenode: line 1: localhost: command not found
20150523:19:53:01:gpinitsystem:localhost:gpadmin-[FATAL]:-PORT_BASE not specified in hostlist_singlenode file, is this the correct instance configuration file. Script Exiting!
[gpadmin@localhost greenplum-db]$ gpinitsystem -c gpinitsystem_singlenode
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_singlenode
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_singlenode, will set to default value
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Locale set to en_US.utf8
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Master hostname localhost does not match hostname output
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking to see if localhost can be resolved on this host
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Can resolve localhost to this host
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking configuration parameters, Completed
20150523:19:53:35:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
.
20150523:19:53:36:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Configuring build for standard array
20150523:19:53:36:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20150523:19:53:36:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Building primary segment instance array, please wait...
..
20150523:19:53:37:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking Master host
20150523:19:53:37:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking new segment hosts, please wait...
.20150523:19:53:39:007016 gpinitsystem:localhost:gpadmin-[WARN]:-----------------------------------------------------------
20150523:19:53:39:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Host localhost is assigned as localhost in /etc/hosts
20150523:19:53:39:007016 gpinitsystem:localhost:gpadmin-[WARN]:-This will cause segment->master communication failures
20150523:19:53:39:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Remove localhost from local host line in /etc/hosts
20150523:19:53:39:007016 gpinitsystem:localhost:gpadmin-[WARN]:-----------------------------------------------------------
.20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[WARN]:-----------------------------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Host localhost is assigned as localhost in /etc/hosts
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[WARN]:-This will cause segment->master communication failures
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Remove localhost from local host line in /etc/hosts
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[WARN]:-----------------------------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checking new segment hosts, Completed
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:---------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master Configuration
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:---------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master instance name = GPDB SINGLENODE
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master hostname = localhost
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master port = 5432
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master instance dir = /gpmaster/gpsne-1
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Greenplum segment prefix = gpsne
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master Database =
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master connections = 250
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master buffers = 128000kB
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Segment connections = 750
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Segment buffers = 128000kB
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Checkpoint segments = 8
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Encoding = UNICODE
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Postgres param file = Off
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Ulimit check = Passed
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master IP address [1] = ::1
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master IP address [2] = 192.168.1.253
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Master IP address [3] = fe80::8e89:a5ff:fe80:f8e6
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Standby Master = Not Configured
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Primary segment # = 2
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Total Database segments = 2
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Trusted shell = ssh
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Number segment hosts = 1
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Mirroring config = OFF
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:----------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:----------------------------------------
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-localhost /gpdata1/gpsne0 40000 2 0
20150523:19:53:40:007016 gpinitsystem:localhost:gpadmin-[INFO]:-localhost /gpdata2/gpsne1 40001 3 1
Continue with Greenplum creation Yy/Nn>
y
20150523:19:53:48:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Building the Master instance database, please wait...
20150523:19:54:57:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Starting the Master in admin mode
The authenticity of host 'localhost.localdomain (127.0.0.1)' can't be established.
ECDSA key fingerprint is 6e:b1:81:19:b5:e0:6c:6d:3b:b8:60:3d:e3:32:ab:15.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'localhost.localdomain' (ECDSA) to the list of known hosts.
20150523:19:55:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20150523:19:55:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
..
20150523:19:55:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
...........................................................................................................
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:------------------------------------------------
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Parallel process exit status
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:------------------------------------------------
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Total processes marked as completed = 2
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Total processes marked as killed = 0
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Total processes marked as failed = 0
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:------------------------------------------------
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Deleting distributed backout files
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Removing back out file
20150523:19:57:14:007016 gpinitsystem:localhost:gpadmin-[INFO]:-No errors generated from parallel processes
20150523:19:57:15:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /gpmaster/gpsne-1
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Gathering information and validating the environment...
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Obtaining Segment details from master...
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.5.1 build 1'
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-There are 0 connections to the database
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Master host=localhost.localdomain
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20150523:19:57:16:024713 gpstop:localhost:gpadmin-[INFO]:-Master segment instance directory=/gpmaster/gpsne-1
20150523:19:57:17:024713 gpstop:localhost:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20150523:19:57:17:024713 gpstop:localhost:gpadmin-[INFO]:-Terminating processes for segment /gpmaster/gpsne-1
20150523:19:57:18:024800 gpstart:localhost:gpadmin-[INFO]:-Starting gpstart with args: -a -d /gpmaster/gpsne-1
20150523:19:57:18:024800 gpstart:localhost:gpadmin-[INFO]:-Gathering information and validating the environment...
20150523:19:57:18:024800 gpstart:localhost:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.5.1 build 1'
20150523:19:57:18:024800 gpstart:localhost:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20150523:19:57:18:024800 gpstart:localhost:gpadmin-[INFO]:-Starting Master instance in admin mode
20150523:19:57:20:024800 gpstart:localhost:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20150523:19:57:20:024800 gpstart:localhost:gpadmin-[INFO]:-Obtaining Segment details from master...
20150523:19:57:20:024800 gpstart:localhost:gpadmin-[INFO]:-Setting new master era
20150523:19:57:20:024800 gpstart:localhost:gpadmin-[INFO]:-Master Started...
20150523:19:57:20:024800 gpstart:localhost:gpadmin-[INFO]:-Shutting down master
20150523:19:57:21:024800 gpstart:localhost:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-Process results...
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-----------------------------------------------------
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:- Successful segment starts = 2
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:- Failed segment starts = 0
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-----------------------------------------------------
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-----------------------------------------------------
20150523:19:57:23:024800 gpstart:localhost:gpadmin-[INFO]:-Starting Master instance localhost.localdomain directory /gpmaster/gpsne-1
20150523:19:57:24:024800 gpstart:localhost:gpadmin-[INFO]:-Command pg_ctl reports Master localhost.localdomain instance active
20150523:19:57:25:024800 gpstart:localhost:gpadmin-[INFO]:-No standby master configured. skipping...
20150523:19:57:25:024800 gpstart:localhost:gpadmin-[INFO]:-Database successfully started
20150523:19:57:25:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20150523:19:57:25:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Loading gp_toolkit...
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[WARN]:-*******************************************************
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[WARN]:-were generated during the array creation
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Please review contents of log file
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20150523.log
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-To determine level of criticality
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-that was called today!
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[WARN]:-*******************************************************
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Greenplum Database instance successfully created
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-------------------------------------------------------
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-To complete the environment configuration, please
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/gpmaster/gpsne-1"
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:- or, use -d /gpmaster/gpsne-1 option for the Greenplum scripts
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:- Example gpstate -d /gpmaster/gpsne-1
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20150523.log
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Review options for gpinitstandby
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-------------------------------------------------------
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-The Master /gpmaster/gpsne-1/pg_hba.conf post gpinitsystem
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-new array must be explicitly added to this file
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20150523:19:57:27:007016 gpinitsystem:localhost:gpadmin-[INFO]:-------------------------------------------------------
[gpadmin@localhost greenplum-db]$