google-templatespostgresql

Check cluster status

To check the status of your PostgreSQL cluster, log in to the master or primary database server host using SSH, start the PostgreSQL command-line client using your administrative credentials, and run the following command within it:

SELECT client_addr, state FROM pg_stat_replication;

The output of this command will be a list of cluster nodes and their current replication status.

Last modification September 5, 2018