MIME-Version: 1.0
References: <CAKgGyB_4kn5Sec8jtY4MfvKcaeXTPdsVQd5m8TU3GF4mGcnBMA@mail.gmail.com>
 <CAKAnmmLMG74OpVK0TTCr0dpK_LzJPRXTKOqs-yObJ-w3cUufvQ@mail.gmail.com>
In-Reply-To: <CAKAnmmLMG74OpVK0TTCr0dpK_LzJPRXTKOqs-yObJ-w3cUufvQ@mail.gmail.com>
From: KK CHN <kkchn.in@gmail.com>
Date: Wed, 25 Feb 2026 12:56:55 +0530
Message-ID: <CAKgGyB8roFcOii2HnAsVPyh3P_z4O3BYcO6+CamWdVFsDP1v6w@mail.gmail.com>
Subject: Re: pgbackrest after a network outage unable to perform backup [fails always]
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006c40db064ba0d667"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB8roFcOii2HnAsVPyh3P_z4O3BYcO6%2BCamWdVFsDP1v6w%40mail.gmail.com>
Precedence: bulk

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

On Tue, Feb 24, 2026 at 9:20=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Tue, Feb 24, 2026 at 5:18=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote=
:
>
>> This goes for hours now, not yet finished. Is this normal behaviour ?
>>
>
> Yes, if there is a lot of WAL
>
> My goal is to initiate a full backup afresh on the reposerver , so it
>> doesn't matter all the old piled up WAL files
>>
>
> You will need to (carefully!) disable pgbackrest archiving, clean up the
> old WAL, then start it up again. Basic sequence:
>
> 1. Set archive_command to '/bin/true'
> 2. Kill any existing pgbackrest processes, empty out the spool directory
> 3. Wait for Postgres to cleanup / recycle the WAL (speed up with a manual
> CHECKPOINT)
> 4. Restore your archive_command to the pgbackrest version
> 5. Run pgbackrest check to verify WALs are being archived again
> 6. Run a full backup
>
> Ideally, test these steps on a dev system, and understand why each step
> and why in that order. :)
>

Thank  you  Greg .


>
>
> Cheers,
> Greg
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Feb 24,=
 2026 at 9:20=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids=
@gmail.com">htamfids@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb=
 24, 2026 at 5:18=E2=80=AFAM KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail.co=
m" target=3D"_blank">kkchn.in@gmail.com</a>&gt; wrote:</div><div class=3D"g=
mail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"l=
tr"><div>This goes for hours now, not yet finished. Is this normal behaviou=
r ?</div></div></blockquote><div><br></div><div>Yes, if there is a lot of W=
AL</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><d=
iv dir=3D"ltr"><div>My goal is to initiate a full backup afresh on the repo=
server , so it doesn&#39;t matter all the old piled up WAL files</div></div=
></blockquote><div><br></div><div>You will need to (carefully!) disable pgb=
ackrest archiving, clean up the old WAL, then start it up again. Basic sequ=
ence:</div><div><br></div><div>1. Set archive_command to &#39;/bin/true&#39=
;</div><div>2. Kill any existing pgbackrest processes, empty out the spool =
directory</div><div>3. Wait for Postgres to cleanup / recycle the WAL (spee=
d up with a manual CHECKPOINT)</div><div>4. Restore your archive_command to=
 the pgbackrest version</div><div>5. Run pgbackrest check to verify WALs ar=
e being archived again</div><div>6. Run a full backup</div><div><br></div><=
div>Ideally, test these steps on a dev system, and understand why each step=
 and why in that order. :)=C2=A0</div></div></div></blockquote><div><br></d=
iv><div>Thank=C2=A0 you=C2=A0 Greg .</div><div>=C2=A0</div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quot=
e"><div><br></div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gmail_si=
gnature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></div><=
div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com" tar=
get=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Postgre=
s Software Products &amp; Tech Support</div><div><br></div></div></div></di=
v>
</blockquote></div></div>

--0000000000006c40db064ba0d667--