Can Postgres connections defined in the sql data store configurations use JDBC URLs instead of just DB host names and ports? It looks like the connectAddr and connectAttributes don’t allow that as an option here: Temporal Cluster configuration reference | Temporal Documentation.
When we failed over a database recently for maintenance, I noticed hundreds of failed connection attempts to the previous Postgres master DB IP, and the history shards started rebalancing, which normally only seems to happen when we scale the history pods up/down or redeploy the service (which creates new pods and deletes old ones). Ideally, it would be nice if the history pods could connect to a JDBC URL instead of just a DNS hostname so they could automatically fail over to whichever host was configured as master without waiting for DNS updates to affect the change.