In order to effectively manage a replication cluster, repmgr needs to store
information about the servers in the cluster in a dedicated database schema.
This schema is automatically created by the repmgr extension, which is installed
during the first step in initializing a repmgr-administered cluster
(repmgr primary register
)
and contains the following objects:
repmgr.events
: records events of interestrepmgr.nodes
: connection and status information for each server in the
replication clusterrepmgr.monitoring_history
: historical standby monitoring information
written by repmgrd
repmgr.nodes
, additionally showing the
name of the server's upstream node
The repmgr metadata schema can be stored in an existing database or in its own dedicated database. Note that the repmgr metadata schema cannot reside on a database server which is not part of the replication cluster managed by repmgr.
A database user must be available for repmgr to access this database and perform
necessary changes. This user does not need to be a superuser, however some operations
such as initial installation of the repmgr extension will require a superuser
connection (this can be specified where required with the command line option
--superuser
).