Architecting Selective Data Sync with PostgreSQL Logical Replication
Learn how to implement selective data synchronization in PostgreSQL using Logical Replication, including configuration steps, monitoring for WAL buildup, and failure mode analysis.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Learn how to implement selective data synchronization in PostgreSQL using Logical Replication, including configuration steps, monitoring for WAL buildup, and failure mode analysis.
Goal Determine whether a standby server that was initially set up with wal_level=replica must be restarted, reinitialized, or simply have its wal_level parameter changed and reloaded after the primary’s wal_level is switched to logical during a pg_upgrade to PostgreSQL 14, in order to maintain logical replication compatibility. Constraints and Uncertainty Po