Support invalidating replication slots due to horizon and wal_level
Andres Freund <andres@anarazel.de>
Support invalidating replication slots due to horizon and wal_level Needed for logical decoding on a standby. Slots need to be invalidated because of the horizon if rows required for logical decoding are removed. If the primary's wal_level is lowered from 'logical', logical slots on the standby need to be invalidated. The new invalidation methods will be used in a subsequent commit. Logical slots that have been invalidated can be identified via the new pg_replication_slots.conflicting column. See 6af1793954e for an overall design of logical decoding on a standby. Bumps catversion for the addition of the new pg_replication_slots column. Author: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com> Author: Andres Freund <andres@anarazel.de> Author: Amit Khandekar <amitdkhan.pg@gmail.com> (in an older version) Reviewed-by: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com> Reviewed-by: Andres Freund <andres@anarazel.de> Reviewed-by: Robert Haas <robertmhaas@gmail.com> Reviewed-by: Fabrízio de Royes Mello <fabriziomello@gmail.com> Reviewed-by: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Alvaro Herrera <alvherre@alvh.no-ip.org> Discussion: https://postgr.es/m/20230407075009.igg7be27ha2htkbt@awork3.anarazel.de
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/system-views.sgml | modified | +10 −0 |
| src/backend/access/transam/xlog.c | modified | +6 −2 |
| src/backend/catalog/system_views.sql | modified | +2 −1 |
| src/backend/replication/logical/logical.c | modified | +7 −0 |
| src/backend/replication/slot.c | modified | +125 −26 |
| src/backend/replication/slotfuncs.c | modified | +11 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +3 −3 |
| src/include/replication/slot.h | modified | +8 −1 |
| src/test/regress/expected/rules.out | modified | +3 −2 |
Documentation touched
Discussion
- Minimal logical decoding on standbys 360 messages · 2018-12-12 → 2023-04-12