# Waiting for PostgreSQL 19 - Sequence synchronization in logical replication.

DevFeed: [Waiting for PostgreSQL 19 - Sequence synchronization in logical replication.](<https://devfeed.tech/articles/waiting-for-postgresql-19-sequence-synchronization-in-logical-replication-33669.md>)

Original publisher: [Read original article](<https://www.depesz.com/2025/11/11/waiting-for-postgresql-19-sequence-synchronization-in-logical-replication/>)

Author: depesz

Published: 2025-11-11T12:24:23Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Sequences](<https://devfeed.tech/topics/sequences.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [logical](<https://devfeed.tech/tags/logical.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [psql](<https://devfeed.tech/tags/psql.md>), [publications](<https://devfeed.tech/tags/publications.md>), [replication](<https://devfeed.tech/tags/replication.md>), [sequence](<https://devfeed.tech/tags/sequence.md>), [sequences](<https://devfeed.tech/tags/sequences.md>), [synchronization](<https://devfeed.tech/tags/synchronization.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

## AI overview

This article demonstrates PostgreSQL 19's planned sequence synchronization for logical replication. It sets up source and destination databases, tests sequence synchronization, finds that resynchronization must be manually invoked, and reports that synchronizing 10,000 sequences took about one second in the author's test.

## Source excerpt

First, on 9th of October 2025, Amit Kapila committed patch: Add "ALL SEQUENCES" support to publications. This patch adds support for the ALL SEQUENCES clause in publications, enabling synchronization/replication of all sequences that is useful for upgrades. Publications can now include all sequences via FOR ALL SEQUENCES. psql enhancements: \d shows publications for ... Continue reading "Waiting for PostgreSQL 19 - Sequence synchronization in logical replication."