GreenPlum upgrade to 4.2.5.0(二)
-----------------------------------------------------
[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 l