hapostgres / hapostgres/pg_auto_failover

Question: Running with wal_level = logical?

Open
#1,030 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
142
Avg merge
5h 8m
Merged PRs (30d)
1

Description

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?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.