Postgres Logical Redplication Slot Invalidations in 16.9 and 17.5

We were sending a note to our customer base at ClickHouse , which we thought would be valuable to share with the broader hn community.

In Postgres versions 16.9 and 17.5, a rare bug was introduced that can invalidate logical replication slots, potentially disrupting CDC pipelines. If this occurs, it may require a full resync of your data pipeline.

You can read the technical details here:

postgresql.org/message-id/fla…

The patch has already been merged into the Postgres main branch and will be available in versions 16.10 and 17.6 soon:

github.com/postgres/postg…

If you are using logical replication, we recommend holding off on upgrading to Postgres 16.9 or 17.5 for now. Here are all the older versions that got affected too: PG13.21, 14.18, 15.13, 16.9 and 17.5 have the bug