Postgres Pro
Downloads
Home   >   mailing lists

How to find the primary server of a hot standby server? - Mailing list pgsql-admin

From Rudolf van der Leeden
Subject How to find the primary server of a hot standby server?
Date
Msg-id 0F09A748-DB17-44B3-BCE0-2FEAA22E8FE5@logicunited.com
Whole thread Raw
Responses Re: How to find the primary server of a hot standby server?
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: Re: Connect to a server with SSL encrypted connection?
Next
From: Guillaume Lelarge
Date:
Subject: Re: How to find the primary server of a hot standby server?