Query on Primary_conninfo

Поиск
Список
Период
Сортировка
От Praneel Devisetty
Тема Query on Primary_conninfo
Дата
Msg-id CAHnVB4CwpkerWCg_-kUM51cr_im1KZfmjbOQn86k4Mu+FQuVbg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query on Primary_conninfo  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general
Hi, 

I have a postgresql cluster running on 13.9.13 and standby has primary_connfino as below

host=kabc03-dev01-ins06-pgs54-dbs-asy.int.dev.example.com port=5432 user=pubuser_1 passfile='/home/postgres/.pgpass' application_name=dr_node1

hostname keng03-dev01-ins06-wfm54-dbs-asy.int.dev.example.com is internally mapped to a fqdn, say node1. When  a failover occurs hostname  is mapped to node2(new master) post failover via a script.

Standy is not picking this change even after a reload.

Restarting standby is working out, but as PG13 supports reload of primary_connfino is there a reliable way to achieve this without restarting standby database.

Thanks 
Praneel


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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Difference in the tablespace folders on primary and secondary nodes