You can configure a new Greenplum Database system with a standby master using
gpinitsystem or enable it later using
gpinitstandby. This topic assumes you are adding a standby master to an existing system that was initialized without one.
For information about the utilities
gpinitstandby, see the Greenplum Database Utility Guide.
Ensure the standby master host is installed and configured:
gpadmin system user created, Greenplum Database binaries installed, environment variables set, SSH keys exchanged, and data directory created.
gpinitstandby utility on the currently active primary master host to add a standby master host to your Greenplum Database system. For example:
$ gpinitstandby -s smdw
-s specifies the standby master host name.
To switch operations to a standby master, see Recovering a Failed Master.
You can display the information in the Greenplum Database system view pg_stat_replication. The view lists information about the
walsender process that is used for Greenplum Database master mirroring. For example, this command displays the process ID and state of the
$ psql dbname -c 'SELECT procpid, state FROM pg_stat_replication;'
For information about the
pg_stat_replication system view, see the Greenplum Database Reference Guide.
Parent topic: Enabling Mirroring in Greenplum Database