
PostgreSQL 19's sequence replication only catches up when you tell it to
PostgreSQL 19 RC1 can replicate sequence values to a logical subscriber, closing a long-standing failover gap. I measured it: an instant match on subscribe, then a frozen value through 700 more replicated rows until I ran REFRESH SEQUENCES, and a promotion I did properly still hit the exact duplicate-key error the feature is meant to prevent.





























