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
