Postgres Pro
Downloads
Home   >   mailing lists

Query on Primary_conninfo - Mailing list pgsql-general

From Praneel Devisetty
Subject Query on Primary_conninfo
Date
Msg-id CAHnVB4CwpkerWCg_-kUM51cr_im1KZfmjbOQn86k4Mu+FQuVbg@mail.gmail.com
Whole thread Raw
Responses Re: Query on Primary_conninfo
List pgsql-general
Tree view
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 by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
Next
From: Stephen Frost
Date:
Subject: Re: Difference in the tablespace folders on primary and secondary nodes