Basic check to see if the master is up and functioning

posted Oct 9, 2014, 2:55 PM by Sachchida Ojha

select count(*) from gp_segment_configuration;

If this fails the active master may be down. Try again several times and then inspect the active master manually. If the active master is down, reboot or power cycle the active master to ensure no processes remain on the active master and then trigger the activation of the standby master.