Обсуждение: viewing the slaves which are connected to a master in streaming replication
viewing the slaves which are connected to a master in streaming replication
От
Lonni J Friedman
Дата:
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
Re: viewing the slaves which are connected to a master in streaming replication
От
Raghavendra
Дата:
On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman <netllama@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.
Re: viewing the slaves which are connected to a master in streaming replication
От
Lonni J Friedman
Дата:
On Thu, Feb 14, 2013 at 10:05 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote: > > On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman <netllama@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 awesome, thanks, that's exactly what I was seeking.