Re: Fix safe_wal_size for slots without restart_lsn

From: Xuneng Zhou <xunengzhou(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix safe_wal_size for slots without restart_lsn
Date: 2026-05-28 01:01:01
Message-ID: CABPTF7XaduJtPVMD0aNaP_ufS2E6+C62Gp-iJR3dNqDQk-byuQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, May 27, 2026 at 6:55 PM Xuneng Zhou <xunengzhou(at)gmail(dot)com> wrote:
>
> Hi,
>
> Currently, pg_replication_slots can report a non-null safe_wal_size
> for a replication slot that has never reserved WAL, if
> max_slot_wal_keep_size is finite.
>
> Such a slot has restart_lsn = NULL and wal_status = NULL. safe_wal_size is
> derived from restart_lsn, so it's not meaningful in this state. The
> current code handles WALAVAIL_REMOVED but not WALAVAIL_INVALID_LSN
> before computing safe_wal_size, leading arithmetic on InvalidXLogRecPtr.
>
> Fix this by returning NULL for safe_wal_size when WAL availability is
> WALAVAIL_INVALID_LSN.
>

Fixed the indentation issue in v1 and updated the comment and doc. Not
sure this small issue warrants an additional test, still added one in
case someone wants it.

--
Regards,
Xuneng Zhou
HighGo Software Co., Ltd.

Attachment Content-Type Size
v2-0001-Fix-safe_wal_size-for-slots-without-restart_lsn.patch application/octet-stream 4.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message SATYANARAYANA NARLAPURAM 2026-05-28 01:08:21 Re: [PATCH] Release replication slot on error in SQL-callable slot functions
Previous Message Baji Shaik 2026-05-28 01:00:50 Re: uuidv7 improperly accepts dates before 1970-01-01