From: Guillaume Lelarge <guillaume@lelarge.info>
To: Rudolf van der Leeden <vanderleeden@logicunited.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to find the primary server of a hot standby server?
Date: Fri, 15 Oct 2010 00:39:51 +0200
Message-ID: <4CB786B7.7080700@lelarge.info> (raw)
In-Reply-To: <0F09A748-DB17-44B3-BCE0-2FEAA22E8FE5@logicunited.com>
References: <0F09A748-DB17-44B3-BCE0-2FEAA22E8FE5@logicunited.com>
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.
--
Guillaume
http://www.postgresql.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, vanderleeden@logicunited.com
Subject: Re: How to find the primary server of a hot standby server?
In-Reply-To: <4CB786B7.7080700@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox