Postgres Database Automatic Reconnect

[Ryan Quinn]

Hi!

I have a little, low-traffic web app which connects to postgres 10 using the pgx library (https://pkg.go.dev/github.com/jackc/pgx), and the database connection gets closed causing 500 server error to be returned. I'm pretty sure this is related to the db server being rebooted after updates and restarting the application fixes the problem.

I found the blog post below about how to process reconnects, and I was wondering how other people handle the db auto-reconnect scenario.

Synopsis: The author attaches functions to the db.Conn variable, and one of the functions has logic to check if the connection is valid then reconnect if the connection is invalid.

https://blog.marahin.pl/golang-postgres-auto-reconnect-4b5e5cc09a39

Ryan