I have a system which uses pgsql to query a database. The system is running 24/7, polling the database for changes. Unfortunately the database get's shut down from time to time, resulting in a timeout(timeout, State) status in pgsql_connection. The connection gets closed afterwards, which is OK I think, because after the database restart, the connection must be reestablished anyway.
I would like epgsql to handle this reconnection procedure internally, is this possoble? If not, how can I be notified of the broken connection to reestablish the connection by myself?