public inbox for [email protected]  

help / color / mirror / Atom feed
From: Saul Perdomo <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Paul Brindusa <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Return of the pg_wal issue..
Date: Thu, 23 Jan 2025 14:02:12 -0500
Message-ID: <CAN3jBgGPTuGKUFU=7gvdzjfRfzHYv74NuCsVAQD+J9PhoERcVA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
	<[email protected]>
	<CAFeSbqijFCW9xFOfapTzebbPcv2sWgpgrS1kVfFNJ+F7sA8R=A@mail.gmail.com>
	<CAN3jBgFEX-fhXuNkrMYwCeWjtYK2_zSrvEmefkUZciLPHK7Psw@mail.gmail.com>
	<CAFeSbqhs_5M-oz136PB_a1RgNQh5PBGSj-k_zL8hsmfV9ZTptw@mail.gmail.com>
	<CAN3jBgG8W+hiQqUGtJaVkE3wfTmmLO_XqQt=PPvGQbHMcgmndg@mail.gmail.com>
	<[email protected]>

Thanks for the correction Adrian - my oversimplification went too far, and
into "plain wrong" territory.

(The detail that I felt was too much for this explanation was: "and the way
to simply get rid of them would be to set your archive command to
'/bin/true', say".. but didn't want to make it seem like I was suggesting
Paul do that)

On Thu, Jan 23, 2025, 11:07 a.m. Adrian Klaver <[email protected]>
wrote:

> On 1/23/25 06:51, Saul Perdomo wrote:
>
> > This is why everybody will tell you "don't just delete these files,
> > archive them properly!" Again, for operational purposes, you could just
> > delete them. But you really want to make a /copy /of them before you
> > do... you know, /just in case /something bad happens to your DB that
> > makes you want to roll it back in time.
>
> No you can't just delete them for operational purposes without knowledge
> of whether they are still needed or not.
>
> Per:
>
> https://www.postgresql.org/docs/current/wal-intro.html
>
> and
>
> https://www.postgresql.org/docs/current/wal-configuration.html
>
> Short version, a WAL file must remain until a checkpoint is done that
> makes it's content no longer needed.
>
> > Cheers
> > Saul
> >
>
> --
> Adrian Klaver
> [email protected]
>
>


view thread (2+ messages)  latest in thread

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: Return of the pg_wal issue..
  In-Reply-To: <CAN3jBgGPTuGKUFU=7gvdzjfRfzHYv74NuCsVAQD+J9PhoERcVA@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