Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question: Running with wal_level = logical? #1030

Open
wilsoniya opened this issue Mar 15, 2024 · 0 comments
Open

Question: Running with wal_level = logical? #1030

wilsoniya opened this issue Mar 15, 2024 · 0 comments

Comments

@wilsoniya
Copy link

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 wilsoniya changed the title Running with wal_level = logical Question: Running with wal_level = logical? Mar 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant