Horton

Re: POC: enable logical decoding when wal_level = 'replica' without a server restart

shveta malik <shveta.malik@gmail.com>

View thread
From: shveta malik <shveta.malik@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Shlok Kyal <shlok.kyal.oss@gmail.com>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, Amit Kapila <amit.kapila16@gmail.com>, Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, shveta malik <shveta.malik@gmail.com>
Date: 2025-09-02T04:55:40Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix regression test failure when wal_level is set to minimal.

  2. Toggle logical decoding dynamically based on logical slot presence.

  3. Disallow server start with sync_replication_slots = on and wal_level < logical.

On Tue, Sep 2, 2025 at 10:24 AM shveta malik <shveta.malik@gmail.com> wrote:
>
> Few trivial comments for doc:

Sorry, the email got sent without comments.

1)
+        It is important to note that when
<varname>wal_level</varname> is set to
+        <literal>replica</literal> the effective WAL level can
automatically change

comma after replica missing.

2)
Do we need to mention it as CAUTION somewhere that the last logical
slot drop may disable logical decoding on primary resulting in slots
invalidation on standby?

thanks
Shveta