Horton

Revert "Allow logical replication snapshots to be database-specific"

Álvaro Herrera <alvherre@kurilemu.de>

View on postgr.es
Commit: 01a80f062146af1b17b411c35cb8d992c487fa7c
Author: Álvaro Herrera <alvherre@kurilemu.de>
Date: 2026-05-24T04:33:19Z
Releases: 19 (unreleased) 
Revert "Allow logical replication snapshots to be database-specific"

This reverts commit 0d3dba38c777, which was determined to have
fundamental flaws.  This restricts REPACK (CONCURRENTLY) so that only
one process can run it concurrently on different tables and even on
different databases; we'll lift that restriction in another way during
the next development cycle.

Reported-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAA4eK1Jg21ODQ7fS2fvN5W_S5kDRhAP5inj3XMRQaa=s-GbYhw@mail.gmail.com

Files

PathChange+/−
contrib/pg_visibility/pg_visibility.c modified +2 −2
doc/src/sgml/logicaldecoding.sgml modified +0 −4
src/backend/access/index/genam.c modified +0 −8
src/backend/access/rmgrdesc/standbydesc.c modified +0 −2
src/backend/access/transam/xlog.c modified +1 −1
src/backend/access/transam/xlogfuncs.c modified +1 −1
src/backend/postmaster/bgwriter.c modified +1 −1
src/backend/replication/logical/decode.c modified +2 −10
src/backend/replication/logical/logical.c modified +0 −3
src/backend/replication/logical/snapbuild.c modified +2 −58
src/backend/replication/pgrepack/pgrepack.c modified +0 −7
src/backend/replication/slot.c modified +1 −1
src/backend/storage/ipc/procarray.c modified +1 −22
src/backend/storage/ipc/standby.c modified +2 −22
src/include/access/xlog_internal.h modified +1 −1
src/include/miscadmin.h modified +0 −9
src/include/replication/output_plugin.h modified +0 −1
src/include/replication/snapbuild.h modified +1 −2
src/include/storage/procarray.h modified +1 −1
src/include/storage/standbydefs.h modified +0 −1
src/include/storage/standby.h modified +1 −2

Discussion