GreenPlum upgrade to 4.2.5.0

[gpadmin@o564gtser1 ~]$ gpstate
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Starting gpstate with args:
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.4.0 build 1'
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.4.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 29 2013 14:27:25'
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:22:59:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Gathering data from segments...
..
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-Greenplum instance status summary
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Master instance                                = Active
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Master standby                                 = No master standby configured
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total segment instance count from metadata     = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Primary Segment Status
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segments                         = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment valid (at master)        = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment failures (at master)     = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing   = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files found     = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing    = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found      = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files missing        = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files found          = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes missing      = 0
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes found        = 2
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirror Segment Status
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirrors not configured on this array
20131020:13:23:01:004254 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@o564gtser1 ~]$ psql -l
                  List of databases
   Name    |  Owner  | Encoding |  Access privileges  
-----------+---------+----------+---------------------
 gtlions   | gtlions | UTF8     |
 postgres  | gpadmin | UTF8     |
 template0 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
 template1 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
(4 rows)

[gpadmin@o564gtser1 ~]$ psql gtlions -c "select version();"           
                                                                       version                                                                        
------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.15 (Greenplum Database 4.2.4.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 29 2013 14:27:25
(1 row)

[gpadmin@o564gtser1 ~]$ gpstop -ay
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Starting gpstop with args: -ay
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Gathering information and validating the environment...
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.2.4.0 build 1'
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-There are 0 connections to the database
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Master host=o564gtser1
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=smart
20131020:13:24:44:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Master segment instance directory=/data/master/gtgpseg-1
20131020:13:24:45:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
...
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-   Segments stopped successfully      = 2
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Successfully shutdown 2 of 2 segment instances
20131020:13:24:48:004425 gpstop:o564gtser1:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
[gpadmin@o564gtser1 ~]$ su -
口令：
IP=192.168.56.171
HOSTNAME=o564gtser1
ORACLE_SID=GT10G
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
Greenplum Home=/usr/local/greenplum-db-4.2.4.0
Greenplum Home=/usr/local/greenplum
MASTER_DATA_DIRECTORY=/data/master/gtgpseg-1
[root@o564gtser1 ~]# sh /home/gpadmin/greenplum-db-4.2.5.2-build-1-RHEL5-x86_64.bin

********************************************************************************
You must read and accept the EMC Database license agreement before installing
********************************************************************************

                 SOFTWARE LICENSE AND MAINTENANCE AGREEMENT

           ***  IMPORTANT INFORMATION - PLEASE READ CAREFULLY  ***

This Software contains computer programs and other proprietary material and
information, the use of which is subject to and expressly conditioned upon
acceptance of this Software License and Maintenance Agreement (the "Agreement").

This Agreement is a legally binding document between you (meaning the individual
person or the entity that the individual represents that has obtained the
Software for its internal productive use and not for outright resale) (the
"Customer") and EMC (which means (i) EMC Corporation, if Customer is located in
the United States; (ii) the local EMC sales subsidiary, if Customer is located
in a country in which EMC Corporation has a local sales subsidiary; and (iii)
EMC Information Systems International ("EISI"), if Customer is located outside
the United States and in a country in which EMC Corporation does not have a
local sales subsidiary). Unless EMC agrees otherwise in writing, this Agreement
governs Customer's use of the Software except to the extent all or any portion
of the Software is: (a) the subject of a separate written agreement; or (b)
governed by a third party licensor's terms and conditions. Capitalized terms
have meaning stated in the Agreement.

If Customer does not have a currently enforceable, written and separately signed
software license agreement directly with EMC or the Distributor from whom
Customer obtained this Software, then by clicking on the "Agree" or "Accept" or
similar button at the end of this Agreement, or proceeding with the
installation, downloading, use or reproduction of this Software, or authorizing
any other person to do so, you are representing to EMC that you are (i)
authorized to bind the Customer; and (ii) agreeing on behalf of the Customer

********************************************************************************
Do you accept the EMC Database license agreement? [yes|no]
********************************************************************************

yes

********************************************************************************
Provide the installation path for Greenplum Database or press ENTER to
accept the default installation path: /usr/local/greenplum-db-4.2.5.2
********************************************************************************

    

********************************************************************************
Install Greenplum Database into </usr/local/greenplum-db-4.2.5.2>? [yes|no]
********************************************************************************

yes

********************************************************************************
[Optional] Provide the path to a previous installation of Greenplum Database,
or press ENTER to skip this step. e.g. /usr/local/greenplum-db-4.1.1.3

This installation step will migrate any Greenplum Database extensions from the
provided path to the version currently being installed. This step is optional
and can be run later with:
gppkg --migrate <path_to_old_gphome> /usr/local/greenplum-db-4.2.5.2
********************************************************************************



Extracting product to /usr/local/greenplum-db-4.2.5.2


Skipping migration of Greenplum Database extensions...

********************************************************************************
Installation complete.
Greenplum Database is installed in /usr/local/greenplum-db-4.2.5.2

Greenplum Database documentation is available for download
at http://powerlink.emc.com.
********************************************************************************
[root@o564gtser1 ~]# ll -d /usr/local/greenplum-db*
lrwxrwxrwx  1 gpadmin gpadmin   22 2013-04-09 /usr/local/greenplum-db -> ./greenplum-db-4.2.4.0
drwxr-xr-x 11 gpadmin gpadmin 4096 2013-04-09 /usr/local/greenplum-db-4.2.4.0
drwxr-xr-x 11 root    root    4096 10-20 13:25 /usr/local/greenplum-db-4.2.5.2
[root@o564gtser1 ~]# rm -rf /usr/local/greenplum-db
[root@o564gtser1 ~]# ln -s /usr/local/greenplum-db-4.2.5.2 /usr/local/greenplum-db
[root@o564gtser1 ~]# ll -d /usr/local/greenplum-db*                               
lrwxrwxrwx  1 root    root      31 10-20 13:26 /usr/local/greenplum-db -> /usr/local/greenplum-db-4.2.5.2
drwxr-xr-x 11 gpadmin gpadmin 4096 2013-04-09 /usr/local/greenplum-db-4.2.4.0
drwxr-xr-x 11 root    root    4096 10-20 13:25 /usr/local/greenplum-db-4.2.5.2
[root@o564gtser1 ~]# chown -R gpadmin:gpadmin /usr/local/greenplum-db          
[root@o564gtser1 ~]# source /usr/local/greenplum-db/greenplum_path.sh
[root@o564gtser1 ~]# gpseginstall -f seghost
20131020:13:28:40:004686 gpseginstall:o564gtser1:root-[INFO]:-Installation Info:
link_name greenplum-db
binary_path /usr/local/greenplum-db-4.2.5.2
binary_dir_location /usr/local
binary_dir_name greenplum-db-4.2.5.2
20131020:13:28:40:004686 gpseginstall:o564gtser1:root-[INFO]:-check cluster password access
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-de-duplicate hostnames
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-master hostname: o564gtser1
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-check for user gpadmin on cluster
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-add user gpadmin on master
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-add user gpadmin on cluster
20131020:13:28:41:004686 gpseginstall:o564gtser1:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.5.2
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.5.2.tar; rm -f /usr/local/greenplum-db-4.2.5.2.tar.gz
20131020:13:28:42:004686 gpseginstall:o564gtser1:root-[INFO]:-cd /usr/local; tar cf greenplum-db-4.2.5.2.tar greenplum-db-4.2.5.2
20131020:13:28:44:004686 gpseginstall:o564gtser1:root-[INFO]:-gzip /usr/local/greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: mkdir -p /usr/local
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: rm -rf /usr/local/greenplum-db-4.2.5.2
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-scp software to remote location
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: gzip -f -d /usr/local/greenplum-db-4.2.5.2.tar.gz
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-md5 check on remote location
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: cd /usr/local; tar xf greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: rm -f /usr/local/greenplum-db-4.2.5.2.tar
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: cd /usr/local; rm -f greenplum-db; ln -fs greenplum-db-4.2.5.2 greenplum-db
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.5.2
20131020:13:29:03:004686 gpseginstall:o564gtser1:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.5.2.tar.gz
Please enter a password:
Confirm password:
20131020:13:29:11:004686 gpseginstall:o564gtser1:root-[INFO]:-Changing system passwords ...
20131020:13:29:11:004686 gpseginstall:o564gtser1:root-[INFO]:-exchange ssh keys for user root
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[INFO]:-exchange ssh keys for user gpadmin
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[ERROR]:-failed doing a test read of file: su gpadmin -c "cat seghost &> /dev/null"
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[ERROR]:-seghost is not accessible as user gpadmin
20131020:13:29:14:004686 gpseginstall:o564gtser1:root-[CRITICAL]:-early exit from gpseginstall
[root@o564gtser1 ~]# exit
[gpadmin@o564gtser1 ~]$ gpstart -ay
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting gpstart with args: -ay
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Gathering information and validating the environment...
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.5.2 build 1'
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20131020:13:30:30:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting Master instance in admin mode
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Setting new master era
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Master Started...
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20131020:13:30:31:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TRANSACTION_FILES
20131020:13:30:32:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES OIDs are consistent for gtlionsfilespace filespace
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TRANSACTION_FILES entries are consistent for gtlionsfilespace filespace
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Checking for filespace consistency
20131020:13:30:33:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Obtaining current filespace entries used by TEMPORARY_FILES
20131020:13:30:34:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES OIDs are consistent for gtlionsfilespace filespace
20131020:13:30:35:005040 gpstart:o564gtser1:gpadmin-[INFO]:-TEMPORARY_FILES entries are consistent for gtlionsfilespace filespace
20131020:13:30:35:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Shutting down master
20131020:13:30:36:005040 gpstart:o564gtser1:gpadmin-[INFO]:-No standby master configured.  skipping...
20131020:13:30:36:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Process results...
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Successful segment starts                                            = 2
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:38:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Starting Master instance o564gtser1 directory /data/master/gtgpseg-1
20131020:13:30:39:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Command pg_ctl reports Master o564gtser1 instance active
20131020:13:30:39:005040 gpstart:o564gtser1:gpadmin-[INFO]:-Database successfully started
[gpadmin@o564gtser1 ~]$ gpstate
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Starting gpstate with args:
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.5.2 build 1'
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.5.2 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on May 16 2013 23:35:01'
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Obtaining Segment details from master...
20131020:13:30:45:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Gathering data from segments...
...
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-Greenplum instance status summary
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Master instance                                = Active
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Master standby                                 = No master standby configured
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total segment instance count from metadata     = 2
20131020:13:30:48:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Primary Segment Status
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segments                         = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment valid (at master)        = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total primary segment failures (at master)     = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing   = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid files found     = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing    = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found      = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files missing        = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number of /tmp lock files found          = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes missing      = 0
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Total number postmaster processes found        = 2
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirror Segment Status
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-   Mirrors not configured on this array
20131020:13:30:49:005663 gpstate:o564gtser1:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@o564gtser1 ~]$ psql gtlions -c "select version();"
                                                                       version                                                                        
------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.15 (Greenplum Database 4.2.5.2 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on May 16 2013 23:35:01
(1 row)
-EOF-