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

Reply via email to