Question 113692 in PostgreSQL Question posted in
The official documentation can be found here.

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?

Tags:

2

Answers


  1. 0

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

    Login or Signup to reply.
  2. 0

    You can use the following query and check for client_addr, client_port, and client_hostname.

    SELECT * FROM pg_stat_replication;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search