Re: Replication

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Replication
Дата
Msg-id CANu8Fiw2HBCe0v7TzPOJ_yRPhRcqCQNRGcQWDYm9M-aH=KTGBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Replication  (Bertrand Paquet <bertrand.paquet@doctolib.fr>)
Ответы Re: Replication  (Scott Mead <scottm@openscg.com>)
Список pgsql-general
Дерево обсуждения
It's been a few years since I worked with slony, and you did not state which version of slony or PostgreSQL you are working with, nor did you indicate the O/S.
That being said, you should be able to formulate a query with a join between sl_path & sl_node that gives you the information you need.

On Thu, Jun 2, 2016 at 9:32 AM, Bertrand Paquet <bertrand.paquet@doctolib.fr> wrote:
Hi,

On an hot standby streaming server, is there any way to know, in SQL, to know the ip of current master ?
The solution I have is to read the recovery.conf file to find primary_conninfo, but, it can be false.

Regards,

Bertrand



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Replication