How to check whether the replication is configured or not in PostgreSQL DB-Server?
For Version 10 or above:
On master node:
Run the following command in psql shell:
select client_addr, state, sent_lsn, write_lsn, flush_lsn, replay_lsn from pg_stat_replication;
Output:
If it displays "empty-set" --> replication is not configured properly
If replication slave details are listed --> replication is configured properly
For Version below 10:
On master node:
Run the following command in psql shell:
select client_addr, state, sent_location, write_location,flush_location, replay_location from pg_stat_replication;
Output:
If it displays "empty-set" --> replication is not configured properly
If replication slave details are listed --> replication is configured properly
New to ADSelfService Plus?
Related Articles
RBM - Configure Content Check using Playback Script
Related topic: Check out this link if you want to configure content check through the Chrome Extension (Web Transaction Recorder). Content Check option Applications Manager's Real Browser Monitoring allows to configure content check to be done on the ...How to check whether Microsoft NLB is configured or not in my Windows Server?
First, verify that your Windows server version must be 2008 and above to support NLB. Otherwise, NLB is not supported Then type wbemtest in the start menu to open the 'Windows Management Instrumentation Tester'. Use the namespace 'MicrosoftNLB' to ...How can I troubleshoot the issue when attempting to add a PostgreSQL Database server, but encountering a failure with an error message prompt?
While attempting to add a PostgreSQL database monitor, if you encounter any errors, please follow the steps below based on the specific error received: Host not valid. Kindly check the host name given or PostgreSQL production server is down or The ...Troubleshooting 'NLB is not configured in this Server' error
The following conditions must be met before you can proceed to troubleshoot WMI nodes: 1. The node should have been successfully added via WMI. 2. WMI should be working properly on the remote server. Using wbemtest.exe to troubleshoot WMI: 1. Open ...How can I transfer bundled PostgreSQL to a remote PostgreSQL server?
Backup and restore the Applications Manager Database Create a backup of Applications Manager Shutdown Applications Manager. Connect to the bundled PostgreSQL database using the instructions provided here. Execute the following pg_dump command to ...