Check the state of the master mirroring.

Post date: Oct 09, 2014 9:50:34 PM

Run SQL

select summary_state from gp_master_mirroring;

Above query test the state of the master mirroring. if the value is "Not Synchronized" Check the pg_log from the master and standby master for errors. If there are no unexpected errors and the machines are up, run gpinitstandby to bring the standby online. This will require a database restart on GPDB 4.2 and earlier.

SELECT procpid, state FROM pg_stat_replication; -- GPDB 4.3 and later

Above SQL test the state of the master mirroring. if the value is "STREAMING", Check the pg_log from the master and standby master for errors. If there are no unexpected errors and

the machines are up, run gpinitstandby to bring the standby online.