Reconnect after connection loss

[eqbalz]

Is there a good way to detect temporary connection loss and attempt to reconnect maybe a predefined number of times? I am trying to use Hammerdb for Postgres sending couple of queries to a read replica which sometimes restarts under certain conditions and I want to continue the test by retrying a few times.

[resuna]

One thing we do for long-running connections is to catch errors and probe with a "select(1)" statement to see if the connection is really down, and retry the connection at the application level. For intermittent connections when we suspect we may not have connected in a while we do that test pre-emptively.