viewing the slaves which are connected to a master in streaming replication

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: viewing the slaves which are connected to a master in streaming replication
Date: 2013-02-14 18:00:25
Message-ID: CAP=oouEgPrN8iG8MeaQHrMZ8NiXfkCBGYG9hhoTZ-39kyMO1jA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've got a postgres-9.2.x cluster, doing streaming replication to
several hot standby servers. I'd like to be able to query the master
to see the hostname or IP address of each connected streaming
replication standby server.

I know that I can view which servers are connected to the master by
looking at 'ps' output, grepping for 'wal sender process' for the IP
address of each standby server that is currently connected. However,
I was hoping that there was a more elegant method for obtaining this
information? I've googled a bit, and haven't found any SQL magic to
do it, but perhaps I'm just not searching for the right thing?

thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raghavendra 2013-02-14 18:05:55 Re: viewing the slaves which are connected to a master in streaming replication
Previous Message Kevin Grittner 2013-02-12 22:00:42 Re: update Timestamp updated whenever the table is updated