gpinitstandby

[gpadmin@mdw ~]$ gpstop -M fast
[gpadmin@mdw ~]$ gpstart 
[gpadmin@mdw ~]$ gpstate -e
20140317:17:11:47:014893 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -e
20140317:17:11:47:014893 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.5.0 build 1'
20140317:17:11:47:014893 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.5.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Apr  5 2013 13:45:40'
20140317:17:11:47:014893 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20140317:17:11:47:014893 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
... 
20140317:17:11:50:014893 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20140317:17:11:50:014893 gpstate:mdw:gpadmin-[INFO]:-Segment Mirroring Status Report
20140317:17:11:50:014893 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20140317:17:11:50:014893 gpstate:mdw:gpadmin-[INFO]:-All segments are running normally


[gpadmin@mdw ~]$ gpstate -f
20140317:17:11:53:015059 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f
20140317:17:11:53:015059 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.5.0 build 1'
20140317:17:11:53:015059 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.5.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Apr  5 2013 13:45:40'
20140317:17:11:53:015059 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-Standby master details
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-----------------------
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-   Standby address          = mdw2
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-   Standby data directory   = /data/master/gpseg-1
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-   Standby port             = 5432
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-   Standby PID              = 23106
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:-   Standby status           = Standby host passive
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--gp_master_mirroring table
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--Summary state: Not Synchronized
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--Detail state: Standby master too far behind
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--Log time: 2014-03-18 07:11:30+08
20140317:17:11:54:015059 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@mdw ~]$ 
[gpadmin@mdw ~]$ gpinitstandby -n
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for filespace directory /data/master/gpseg-1 on mdw2
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname               = mdw
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory         = /data/master/gpseg-1
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port                   = 5432
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname       = mdw2
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /data/master/gpseg-1
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog         = Off
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum stop database mode            = smart
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:- Filespace locations
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20140317:17:13:44:015303 gpinitstandby:mdw:gpadmin-[INFO]:-pg_system -> /data/master/gpseg-1
Do you want to continue with standby master initialization? Yy|Nn (default=N):
> y
20140317:17:13:49:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20140317:17:13:49:015303 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on mdw2 are consistent.
20140317:17:13:49:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Stopping database...
20140317:17:14:18:015303 gpinitstandby:mdw:gpadmin-[INFO]:--n option given, skipping catalog update
20140317:17:14:18:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Forcing changed blocks to disk for filespace /data/master/gpseg-1...
20140317:17:14:18:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Copying filespace directory to mdw2
20140317:17:19:42:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Updating filespace flat files
20140317:17:19:42:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Updating filespace flat files
20140317:17:19:42:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Removing pg_hba.conf backup...
20140317:17:19:42:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Starting database in production mode...
20140317:17:20:14:015303 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully syncronized standby master.
[gpadmin@mdw ~]$ 
[gpadmin@mdw ~]$ gpstate -f
20140317:17:21:03:016138 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f
20140317:17:21:03:016138 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.5.0 build 1'
20140317:17:21:03:016138 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.5.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Apr  5 2013 13:45:40'
20140317:17:21:03:016138 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-Standby master details
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-----------------------
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-   Standby address          = mdw2
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-   Standby data directory   = /data/master/gpseg-1
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-   Standby port             = 5432
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-   Standby PID              = 23637
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:-   Standby status           = Standby host passive
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--gp_master_mirroring table
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--Summary state: Synchronized
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--Detail state: 
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--Log time: 2014-03-18 07:20:13+08
20140317:17:21:04:016138 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@mdw ~]$