On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman <netll...@gmail.com>wrote:
> 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 > > You can check with pg_stat_replication for replicating server's information. http://www.postgresql.org/docs/9.2/static/monitoring-stats.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
