Search code examples
postgresqldatabase-replication

PostgreSQL replication slot - how to see standby nodes

I am using PostgreSQL 11.2. I have replication slots setup. I am able to commit to a table and see it on the standby. I have few more standbys. How can I see from the master what other standbys I have?

Solution

  • By selecting from pg_stat_replication. client_addr will be the IP address of a standby.