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

Поиск
Список
Период
Сортировка
От Rudolf van der Leeden
Тема How to find the primary server of a hot standby server?
Дата
Msg-id 0F09A748-DB17-44B3-BCE0-2FEAA22E8FE5@logicunited.com
обсуждение исходный текст
Ответы Re: How to find the primary server of a hot standby server?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Craig James
Дата:
Сообщение: Re: Connect to a server with SSL encrypted connection?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: How to find the primary server of a hot standby server?