Re: How to find the primary server of a hot standby server?

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