Re: Question about different behaviour in pg_wal when archive_mode is set on or off

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Arpad Kiss A <arpad(dot)a(dot)kiss(at)est(dot)tech>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Question about different behaviour in pg_wal when archive_mode is set on or off
Date: 2025-06-26 14:17:56
Message-ID: CAKFQuwYM+7jw61L0ums6FOVfp8qqEaGbarO7EWQz25EzYry_rg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, June 26, 2025, Arpad Kiss A <arpad(dot)a(dot)kiss(at)est(dot)tech> wrote:

> Can someone explain why the difference in behavior? Does postgres only use
> the seqno only to differentiate the wal files here? Why does postgres not
> rotate out files in the former case?
>

Seems like it is being helpful not throwing away data you may be
experimenting with during a point-in-time recovery.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zechman, Derek S 2025-06-27 13:35:27 analyze-in-stages post upgrade questions
Previous Message Peter J. Holzer 2025-06-26 12:27:41 Re: password rules