0

i have one simply question: citus 11 support the HA? This is the structure that i have implemented with 7 node ( replication with pg_autofailover):

enter image description here

The problem occurs when i disable a worker1_primary and i try to make an sql insert in the coordinator_primary: the response of citus is: connection with remote worker1_primary refused.

The citus nodes table is this one ( from select * from pg_dist_node ): enter image description here

thanks in advance for any reply

Al3
  • 183
  • 1
  • 3
  • 11
  • i am trying to achieve the same. have you installed citus first or pg_auto_failer over? – jack Sep 15 '22 at 14:53
  • I tried with first setup citus with 3 node and then create monitor and then add existing citus node as primary and create secondary node. – jack Sep 15 '22 at 14:54
  • I was getting error while adding primary node in monitor using pg_autoctl. It override my existing settings of pg_hba.cnf and data. – jack Sep 15 '22 at 14:55
  • 1
    The installation order is not important: you can install citus first or pg_auto_failover. For use an existing postgres cluster you can use a PGDATA variable to pass it to pg_auto_failover. For example PGDATA=/var/lib/postgresql/14/main. if you use a PGDATA=./primary it create a new data cluster in the directory of postgres user. – Al3 Sep 17 '22 at 09:42
  • Okay Got it. They are adding support for citus open source in pg_auto_failover. – jack Sep 19 '22 at 15:02
  • You can find it over there. https://github.com/citusdata/pg_auto_failover/pull/933 – jack Sep 19 '22 at 15:02

0 Answers0