On Fri, Oct 15, 2010 at 9:39 AM, Guillaume Lelarge
<guillaume@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/