How to view database replication details.
View details on the state of database replication, including the IP addresses of the Primary and Standby servers, as well as the size (in MB) of the Replication Queue Threshold and Replication Queue Size.
To view database replication details:
- Select the Administration tab. Tabs remember the page you last worked on, so select the tab again to ensure you're on the Administration page.
- Under Database Management, click Database Management. The Database Management page opens.
Replication. The Database Replication page
- The General section displays the following
- Database Replication—indicates if database replication is enabled or disabled.
- Primary Server—displays the IP address of the Primary server.
- Standby Server 1—displays the IP address of the first Standby server.
- Standby Server 2—displays the IP address of the second Standby server, if one is configured.
- Replication Queue Threshold (MB)—displays the warning threshold size of the replication data directory, in megabytes. WAL files will start to accumulate in the replication data directory if the network connection between the primary and standby servers is lost. When the total size of the files in the replication data directory reaches this size, Address Manager sends an SNMP trap to warn you that replication files may be accumulating on the server and are not being replicated to the Standby server.
- Replication Break Threshold (GB)—displays
the warning threshold size of the replication break, in
gigabytes (GB). When the total size of WAL files reaches this
size, Address Manager creates a
replication_break file in
/data/pgdata directory, waits for 10
minutes, then breaks replication. The values for this field
range between 5GB and 30GB; the default value is 5 GB.Note: To establish database replication again, refer to Resetting database replication.
- The Status section displays the following
- Replication Status—displays the database replication service status.
- Replication Queue Size (MB)—displays the current size, in megabytes, of the database replication data file.
- The General section displays the following information: