From Dev.to
PostgreSQL 19's sequence replication only catches up when you tell it to
A logical replication subscriber in PostgreSQL has always replicated your rows and ignored your sequences. Promote it to primary after a failover, and the first few inserts try to reuse IDs that alrea...