PostgreSQL 19 RC1 syncs sequence values in logical replication, but only on demand
A logical replication subscriber has traditionally copied table rows while leaving sequences at their starting values, which can cause duplicate-key errors after failover. The author tested PostgreSQL 19 release candidate 1, which adds support for publishing all sequences and synchronizes them during initial subscriber setup. Version 18 rejects the required syntax entirely, and on 18.6 a promoted subscriber collided with an existing ID while the 19 RC1 subscriber accepted the next value. The fix covers a freshly created subscriber, and the author indicates it is narrower than the release notes suggest, since sequence refresh is available via an explicit command. The release is still a candidate, with general availability currently planned for 19 November 2026, so details could change.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in