On Thu, Feb 14, 2013 at 10:05 AM, Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> wrote: > > On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman <netllama@xxxxxxxxx> > 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 awesome, thanks, that's exactly what I was seeking. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
