Enable logical decoding when wal_level = 'replica' without a server restart

Edit
ID 5479
Title Enable logical decoding when wal_level = 'replica' without a server restart
CI (CFBot) Needs rebase! Needs rebase since 20 hours. Failing since 20 hours.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Replication & Recovery
Tags
Created 2024-12-31 04:52:39
Last modified 2025-12-04 02:23:24 (41 minutes ago)
Latest email 2025-12-03 21:08:45 (5 hours ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
Target version
Authors Masahiko Sawada (masahikosawada)
Reviewers Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun)Become reviewer
Committer
Links
Emails
POC: enable logical decoding when wal_level = 'replica' without a server restart
First at 2024-12-31 04:44:38 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest at 2025-12-04 02:33:20 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (PS_enum_for_cache.diff) at 2025-12-02 22:39:02 from Peter Smith <smithpb2250 at gmail.com>
    Attachment (PS_enum_for_cache.diff) at 2025-12-02 22:39:02 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-12-01 07:02:59 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v30-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-26 21:01:28 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v30-0003-PoC-Ensure-XLogLogicalInfoActive-returns-consist.patch) at 2025-11-26 00:29:05 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-20 20:18:08 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v28-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-19 17:33:43 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v27-0002-FIXUP-remove-status_change_allowed-flag.patch) at 2025-11-18 20:22:02 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-13 23:30:22 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v25-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-12 10:06:19 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v24-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-11-05 23:02:00 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v23-0001-Toggle-logical-decoding-dynamically-based-on-log.patch) at 2025-10-31 21:38:34 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v22-0002-Enable-and-disable-logical-decoding-also-when-sl.patch) at 2025-10-24 22:35:58 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-23 21:53:15 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v20-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-22 22:59:56 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v19-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-17 17:38:45 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v18-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-13 22:47:56 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v17-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-13 20:33:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v16-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-10-08 22:43:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (0002-POC-change.patch.txt) at 2025-09-30 01:58:11 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-09-25 19:15:27 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v15-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-09-22 21:57:46 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v14-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-09-05 23:21:02 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v13-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-09-05 22:15:42 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v12-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-08-29 04:07:41 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v11-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-08-27 06:41:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v10-0001-Enable-logical-decoding-dynamically-based-on-log.patch) at 2025-08-25 19:24:07 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v9-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-08-22 22:20:49 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v8-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-08-21 17:03:23 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v7-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-08-07 21:59:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-08-06 00:47:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-08-01 23:23:16 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Enable-logical-decoding-dynamically-based-on-logi.patch) at 2025-07-25 06:14:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Add-pg_-de-activate_logical_decoding-SQL-function.patch) at 2025-07-15 17:07:11 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-to-create-logical-slots-with-no-WAL-reserva.patch) at 2025-06-10 21:00:55 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-to-create-logical-slots-with-no-WAL-reserva.patch) at 2025-06-04 01:10:44 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v3-0003-PoC-Convert-wal_level-a-PGC_SIGHUP-parameter.patch) at 2025-02-17 20:07:56 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0001-PoC-Convert-wal_level-a-PGC_SIGHUP-parameter.patch) at 2025-02-11 22:11:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (add_check_hook.patch) at 2025-02-03 11:40:13 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-PoC-Convert-wal_level-a-PGC_SIGHUP-parameter.patch) at 2025-01-24 19:16:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (PS_guc_show_hook.txt) at 2025-01-13 06:52:15 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PoC_online_activate_logical_decoding.patch) at 2024-12-31 04:44:38 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
History
When Who What
2025-12-04 02:23:24 Masahiko Sawada (masahikosawada) Moved from CF PG19-3 to CF PG19-4
2025-12-03 06:36:26 CFbot Patch needs rebase
2025-10-08 22:47:18 Masahiko Sawada (masahikosawada) Moved from CF PG19-2 to CF PG19-3
2025-09-02 01:33:38 Hayato Kuroda (ha-kun) Added ha-kun as reviewer
2025-08-21 23:56:31 Masahiko Sawada (masahikosawada) New status: Needs review
2025-08-19 23:13:29 CFbot Patch does not need rebase anymore
2025-08-19 23:04:16 Masahiko Sawada (masahikosawada) Moved from CF PG19-1 to CF PG19-2
2025-08-04 15:24:33 CFbot Patch needs rebase
2025-08-01 06:00:32 Dilip Kumar (dilip.kumar) Added dilip.kumar as reviewer
2025-07-28 23:25:32 CFbot Patch does not need rebase anymore
2025-07-24 06:15:25 CFbot Patch needs rebase
2025-06-04 01:44:30 CFbot Patch does not need rebase anymore
2025-04-24 21:51:16 Masahiko Sawada (masahikosawada) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-11 04:15:05 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-02-25 04:57:32 CFbot Patch needs rebase
2025-02-17 21:09:43 CFbot Patch does not need rebase anymore
2025-02-17 12:46:39 CFbot Patch needs rebase
2025-02-03 22:19:48 Masahiko Sawada (masahikosawada) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-31 04:52:46 Masahiko Sawada (masahikosawada) Changed authors to Masahiko Sawada (masahikosawada)
2024-12-31 04:52:40 Masahiko Sawada (masahikosawada) Attached mail thread CAD21AoCVLeLYq09pQPaWs+Jwdni5FuJ8v2jgq-u9_uFbcp6UbA@mail.gmail.com
2024-12-31 04:52:39 Masahiko Sawada (masahikosawada) Created patch record
Edit