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