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