Query on Primary_conninfo

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

Responses

Browse pgsql-general by date

  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?