If the primary master fails, log replication stops. Use the
gpstate -f command to check the state of standby replication. Use
gpactivatestandby to activate the standby master. Upon activation of the standby master, Greenplum Database reconstructs the master host state at the time of the last successfully committed transaction.
Ensure a standby master host is configured for the system. See Enabling Master Mirroring.
gpactivatestandby utility from the standby master host you are activating. For example:
$ gpactivatestandby -d /data/master/gpseg-1
-d specifies the data directory of the master host you are activating.
After you activate the standby, it becomes the active or primary master for your Greenplum Database array.
After the utility finishes, run
gpstate to check the status:
$ gpstate -f
The newly activated master's status should be Active. If you configured a new standby host, its status is Passive. When a standby master is not configured, the command displays
-No entries found and the message indicates that a standby master instance is not configured.
Optional: If you did not specify a new standby host when running the
gpactivatestandby utility, use
gpinitstandby to configure a new standby master at a later time. Run
gpinitstandby on your active master host. For example:
$ gpinitstandby -s <new_standby_master_hostname>
Parent topic: Enabling High Availability and Data Consistency Features