On Fri, Oct 15, 2010 at 9:39 AM, Guillaume Lelarge <guilla...@lelarge.info>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. -- Shoaib Mir http://shoaibmir.wordpress.com/
