Is it possible to specify client side pgsql cluster high avaliablity in zammad with target_session_attrs atribute?
For example pgsql client can utilize it like this
psql -U zammad "postgresql://server1:5432,server2:5432,server3:5432/zammad?target_session_attrs=read-write"
and java connection strings can use something like
jdbc:postgresql://server1:5432,server2:5432,server3:5432/dbname?target_session_attrs=read-write
.
If I see correctly zammad uses ruby-pg which seems to have support for this feature.
But as database.yaml specifies separate fields for hostname and portseparately, I am not sure if zammad itself supports this feature.
Infos:
- Used Zammad version: 5.2
- Used Zammad installation type: package
- Operating system: CentOs
- Browser + version: Irelevant
Expected behavior:
- Zammad is capable of client side pgsql cluster HA.