We have migrated to new Google sites!
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.