pg_auto_failover icon indicating copy to clipboard operation
pg_auto_failover copied to clipboard

Question: Running with wal_level = logical?

Open wilsoniya opened this issue 1 year ago • 0 comments

Hi there, I'm looking to set up logical replication for change data capture. This requires running postgres with wal_level = logical per the postgres docs: https://www.postgresql.org/docs/14/logical-replication-config.html ; is it possible for pg_auto_failover to operate with wal_level = logical?

Please note, I'm not looking to get pg_auto_failover cluster members to replicate via logical replication as was discussed in #400, and I'm not concerned at this time with failing over logical replication slots; I understand that's not supported in its entirety yet.

  • If it's possible to run pg_auto_failover with wal_level = logical, how can this configuration be set? It seems like pg_auto_failover manages this configuration.
  • Do you foresee any complications transitioning an existing formation from replica -> logical wal_level? Can the transition just be made by modifying config files and restarting the servers?

wilsoniya avatar Mar 15 '24 19:03 wilsoniya