VMware Tanzu Greenplum

 standby master not starting

VMware Community Member's profile image
VMware Community Member posted Mar 18, 2024 04:47 AM

Hi my standby master not starting with below error while doing HA testing

 

with error 20240318:11:41:42:203148 gpstop:gp-master-dev2:gpadmin-[CRITICAL]:-gpstop failed. (Reason='FATAL: the database system is in recovery mode

DETAIL: last replayed record at 36/A7FFA538

Kevin Huang's profile image
Kevin Huang

Are you running gpstop on standby master or the master node? If you're attempting on the standby master server then gpstop doesn't work because it can't establish a connection with the standby master since it doesn't accept connections by design. You need to be using gpinitstandby or gpactivatestandby utilities to test HA.