We are using Keycloak and Keycloak is using Liquibase.
In order to shift from primary database to secondary (failover) without dropping connections to the application, ex
- pause connections in pgbouncer
- do a failover
- change IP in pgbouncer
We would like to run pgbouncer in transaction mode. (We are now using session mode).
But testing fails and we are not able to restart Keyclock when using transaction mode. We think that liquibase is run doing Keycloak startup and liquibase is expecting a session lock. (not possible in transactions mode).
Is that observation correct - that liquibase using session locks?
Or in another way prevent us for using pgbouncer in transaction mode? Can it we configure not to ?
Or maybe I just misunderstands it … then my apologies
Thanks for a good product