Some Postgres drivers, like pgjdbc support specifying multiple hosts in the connection string for failover. If I run a HA Postgres cluster with identical hot mirrors, can I specify multiple hosts in the sandbox connection string such that it would fail over if the primary connection goes down?
As of the time of writing, we are using version 42.2.9 of that driver, so in principle I’d say you should be able to use this feature.