Le 15/10/2010 00:53, Shoaib Mir a écrit : > On Fri, Oct 15, 2010 at 9:39 AM, Guillaume Lelarge > <guillaume@xxxxxxxxxxxx>wrote: > >> Le 14/10/2010 23:18, Rudolf van der Leeden a écrit : >>> [...] >>> quick question to the PG 9 community. >>> >>> I can query a hot standby server if recovery is still active using >>> the administration function pg_is_in_recovery(). Is there also a way >>> to query for the 'primary server', i.e. which server is delivering >>> the WAL records? >>> >>> I'd like to monitor a bunch of standby servers in terms of >>> configuration and operation. >>> >> >> There's no "SQL" way to know this, AFAICT. But I would love to be proven >> wrong: I would be able to add this info to pgAdmin, which would be great. >> >> >> > What about doing a query like: > > show wal_level; > > If it shows *hot_standby* then that server should have been setup as master. > As an extra step you can also check for archive_mode as well if its enabled > or not. > It only helps you to know that the serveur you're currently connected to is acting as a primary server. It doesn't tell you who the slaves are. And it doesn't answer the OP's question which is, if I don't get it wrong, "I'm connected to a slave, how do I know which master it works with?". -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
