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) Summary
Stats (from CFBot) Patch version: v22, Patch count: 2, First patch: +1540−126, All patches: +1602−130
Topic Replication & Recovery
Tags
Created 2024-12-31 04:52:39
Last modified 2025-10-08 22:47:18 (3 weeks ago)
Latest email 2025-10-29 19:26:19 (4 hours ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
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-10-29 19:26:19 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest 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>
    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-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