From: | Praneel Devisetty <devisettypraneel(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Query on Primary_conninfo |
Date: | 2023-07-26 12:03:50 |
Message-ID: | CAHnVB4CwpkerWCg_-kUM51cr_im1KZfmjbOQn86k4Mu+FQuVbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2023-07-26 13:55:25 | Re: Difference in the tablespace folders on primary and secondary nodes |
Previous Message | Thomas Kellerer | 2023-07-26 09:56:25 | Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? |