MIME-Version: 1.0
References: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
 <0ba329ef-62aa-4ab3-aefd-141baabced3b@aklaver.com> <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> <f1ad892c-43fb-4c4b-96f3-01f71ae4f4bf@aklaver.com>
In-Reply-To: <f1ad892c-43fb-4c4b-96f3-01f71ae4f4bf@aklaver.com>
From: Saul Perdomo <saul.perdomo@gmail.com>
Date: Thu, 23 Jan 2025 14:02:12 -0500
Message-ID: <CAN3jBgGPTuGKUFU=7gvdzjfRfzHYv74NuCsVAQD+J9PhoERcVA@mail.gmail.com>
Subject: Re: Return of the pg_wal issue..
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Paul Brindusa <paulbrindusa88@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000132824062c6440ff"
Archived-At: <https://www.postgresql.org/message-id/CAN3jBgGPTuGKUFU%3D7gvdzjfRfzHYv74NuCsVAQD%2BJ9PhoERcVA%40mail.gmail.com>
Precedence: bulk

--000000000000132824062c6440ff
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFa.m. Adrian Klaver <adrian.klaver@aklav=
er.com>
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
> adrian.klaver@aklaver.com
>
>

--000000000000132824062c6440ff
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Thanks for the correction Adrian - my oversimplification =
went too far, and into &quot;plain wrong&quot; territory.<div dir=3D"auto">=
<br></div><div dir=3D"auto">(The detail that I felt was too much for this e=
xplanation was: &quot;and the way to simply get rid of them would be to set=
 your archive command to &#39;/bin/true&#39;, say&quot;.. but didn&#39;t wa=
nt to make it seem like I was suggesting Paul do that)=C2=A0</div></div><br=
><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D=
"gmail_attr">On Thu, Jan 23, 2025, 11:07=E2=80=AFa.m. Adrian Klaver &lt;<a =
href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8=
ex;border-left:1px #ccc solid;padding-left:1ex">On 1/23/25 06:51, Saul Perd=
omo wrote:<br>
<br>
&gt; This is why everybody will tell you &quot;don&#39;t just delete these =
files, <br>
&gt; archive them properly!&quot; Again, for operational purposes, you coul=
d just <br>
&gt; delete them. But you really want to make a /copy /of them before=C2=A0=
you <br>
&gt; do... you know, /just in case /something bad happens to your DB that <=
br>
&gt; makes you want to roll it back in time.<br>
<br>
No you can&#39;t just delete them for operational purposes without knowledg=
e <br>
of whether they are still needed or not.<br>
<br>
Per:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/wal-intro.html" rel=3D"n=
oreferrer noreferrer" target=3D"_blank">https://www.postgresql.org/docs/cur=
rent/wal-intro.html</a><br>
<br>
and<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/wal-configuration.html" =
rel=3D"noreferrer noreferrer" target=3D"_blank">https://www.postgresql.org/=
docs/current/wal-configuration.html</a><br>
<br>
Short version, a WAL file must remain until a checkpoint is done that <br>
makes it&#39;s content no longer needed.<br>
<br>
&gt; Cheers<br>
&gt; Saul<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000132824062c6440ff--