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

From: Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com>
Subject: How to find the primary server of a hot standby server?
Date: 2010-10-14 21:18:10
Message-ID: 0F09A748-DB17-44B3-BCE0-2FEAA22E8FE5@logicunited.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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.

Thanks,
Rudolf VanderLeeden
Scoreloop AG, Germany

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Cédric Villemain 2010-10-14 21:25:41 Re: oracle to psql migration - slow query in postgres
Previous Message Ivan Voras 2010-10-14 20:32:09 Re: oracle to psql migration - slow query in postgres