Multi Master - Cluster Replication with Pigsty

[mulyadi1994]

I have 2 pigsty clusters in 2 different regions. Currently, I can do multi-cluster replication, but in region 2, it only does read-only transactions. Can I set it up as active-active or multi-master?

[Vonng]

Then you'll need to setup logical replication between two clusters.
It's a standard postgresql thing: publication / subscription with pure sql
BTW, these two extensions may also be helpful:

• pgactive
• pglogical

[mulyadi1994]

Hi,

I’m trying to use pgactive to join a node into a group (region2), but the process is stuck because the supervisor keeps holding a lock.

When I run pgactive_join_group, it times out with:

ERROR: canceling statement due to lock timeout
CONTEXT: SQL statement "LOCK TABLE pg_catalog.pg_shseclabel IN EXCLUSIVE MODE"

From pg_locks I see this:

pid | datname | usename | state | query | mode | granted
-------+-----------------------+----------+--------+-------------------+--------------+---------
59012 | pgactive_supervisordb | postgres | active | scanning backends | RowShareLock | t

If I kill the backend, the supervisor immediately respawns and grabs the lock again.
So I can’t run pgactive_join_group at all in region2.

Setup:

PostgreSQL version 17.5

pgactive version 2.1.5-1PIGSTY~noble

Question:
Any suggestion how to temporarily disable the pgactive supervisor (or bypass the lock) so I can successfully run pgactive_join_group?

Thanks in advance!