public inbox for [email protected]  
help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Arpad Kiss A <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Question about different behaviour in pg_wal when archive_mode is set on or off
Date: Thu, 26 Jun 2025 07:17:56 -0700
Message-ID: <CAKFQuwYM+7jw61L0ums6FOVfp8qqEaGbarO7EWQz25EzYry_rg@mail.gmail.com> (raw)
In-Reply-To: <AS8P189MB148022F6C262DC2C83CDFE97A97AA@AS8P189MB1480.EURP189.PROD.OUTLOOK.COM>
References: <AS8P189MB148022F6C262DC2C83CDFE97A97AA@AS8P189MB1480.EURP189.PROD.OUTLOOK.COM>

On Thursday, June 26, 2025, Arpad Kiss A <[email protected]> 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.


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Question about different behaviour in pg_wal when archive_mode is set on or off
  In-Reply-To: <CAKFQuwYM+7jw61L0ums6FOVfp8qqEaGbarO7EWQz25EzYry_rg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox