Hello,
docker image support multiple postgresql hosts separated by comma sign for failover purpouse
DB_ADDR
: Specify hostname of the database (optional). For postgres only, you can provide a list of hostnames separated by comma to failover alternative host. The hostname can be the host only or pair of host and port, as example host1,host2 or host1:5421,host2:5436 or host1,host2:5000. And keycloak will append DB_PORT (if specify) to the hosts without port, otherwise it will append the default port 5432, again to the address without port only.
Is it possible to implement target_session_attrs in connection setting so we can have easy HA setup?
https://paquier.xyz/postgresql-2/postgres-10-libpq-read-write/
host=host1 target_session_attrs=any
host=host1,host2 port=port1,port2 target_session_attrs=any
postgresql://host1:port2,host2:port2/?target_session_attrs=read-write