Possible to periodically update passwords?
nick567187 opened this issue · 1 comments
nick567187 commented
This is a replication of an issue posted in PGX which has more fine-grained control over connection pooling.
I am working with Hashicorp Vault in Kubernetes which can dynamically generate database roles for short-lived sessions. Would be nice if go-pg supported a way to instrument the new configs on new connections to the pool or if a new pool can be created while allowing the old one to finish queries and garbage collect
vmihailenco commented
Let's keep this discussion in #1848
Changing password for new connections is not hard, but properly closing existing connections is. As I understand jackc/pgx#676 is only about the former.