Check the state of the master mirroring.

posted Oct 9, 2014, 2:50 PM by Sachchida Ojha   [ updated Oct 9, 2014, 2:53 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. 
Comments