Postgres client side high availability for zammad

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.

Any update on this please?

Is Zammad able to work with connection string for database(s)?

I had a quick glimpse on the rails part and don’t think your approach works:

H/A environments are out of community scope, you’re possibly on your own sorry.

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.