Postgres 16.9 和 17.5 中的逻辑复制槽失效问题
我们向 ClickHouse 的客户群发送了一条通知，认为这条信息对更广泛的 hn 社区也具有价值。
在 Postgres 版本 16.9 和 17.5 中，出现了一个罕见的错误，该错误可能会使逻辑复制槽失效，从而可能干扰 CDC 管道。如果发生这种情况，可能需要对您的数据管道进行全面重新同步。
您可以在这里阅读技术细节：
postgresql.org/message-id/fla…
该补丁已经合并到 Postgres 主分支，并将在 16.10 和 17.6 版本中很快提供：
github.com/postgres/postg…
如果您正在使用逻辑复制，我们建议您暂时不要升级到 Postgres 16.9 或 17.5。以下是所有受影响的旧版本：PG13.21、14.18、15.13、16.9 和 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.<p>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.<p>You can read the technical details here:<p>postgresql.org/message-id/fla…<p>The patch has already been merged into the Postgres main branch and will be available in versions 16.10 and 17.6 soon:<p>github.com/postgres/postg…<p>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