Password rotation and c3p0 connection pool

How does Postgres password rotation works when password is changed while the application has connection pool that was started with the old password. How can java’s c3p0 connection pool continue to work (and open new connections) when it does not have the new password.

Can this be done without interrupting existing connections and seamlessly use the new password with new pool connections?


That’s more a question for c3p0 instead of Vault because the application has to handle the reconnect. :man_shrugging:t3:

Maybe something like this: