pg_auto_failover
pg_auto_failover copied to clipboard
Question: Running with wal_level = logical?
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->logicalwal_level? Can the transition just be made by modifying config files and restarting the servers?