Does PGX support automatic certificate rotation?

[jsirianni]

Is your feature request related to a problem? Please describe.

My certificates are short lived, roughly 3 days.

Describe the solution you'd like

Does PGX support re-reading certificate files when they are updated?

Describe alternatives you've considered

Attempting to use fsnotify to re-construct the Postgres client.

Additional context

Short lived certificates are becoming more common. At the moment, I need to restart my applications in order to consume new certificates.

[jackc]

There's nothing builtin. But assuming you are using pgxpool, you may be able to use BeforeConnect to modify the ConnConfig as you see fit.