GreenPlum upgrade to 4.2.5.0
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 hav
