Reconnect automatically

[FedericoCeratto]

Thanks for developing pg.
The current implementation does not handle reconnecting to the database in case of timed out or broken connections. Any workaround?

Also see nim-lang/db_connector#9

[treeform]

I have this lib running in production for 2 years now. I never had connections time out between servers in the same data center. I guess its a very rare event?

[treeform]

Maybe db_postgres does auto reconnect?

[FedericoCeratto]

@treeform it really depend on the reliability of the network and if the server is restarted. Yet, detecting stale connections and reconnecting is usually a basic requirement for database libraries.

[hasanyasin]

Disconnects can also be caused by the server dropping older clients.