Postgres 逻辑复制槽在 16.9 和 17.5 版本中的失效问题
1 分•作者: saisrirampur•10 个月前
我们向 ClickHouse 的客户群发了一份通知，认为与更广泛的 hn 社区分享也很有价值。<p>在 Postgres 16.9 和 17.5 版本中，引入了一个罕见的错误，可能导致逻辑复制槽失效，从而潜在地中断 CDC 管道。如果发生这种情况，可能需要对您的数据管道进行完全的重新同步。<p>您可以在这里阅读技术细节：<p>postgresql.org/message-id/fla…<p>该补丁已合并到 Postgres 主分支中，并将很快在 16.10 和 17.6 版本中提供：<p>github.com/postgres/postg…<p>如果您正在使用逻辑复制，我们建议您暂时不要升级到 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