Re: pgbackrest after a network outage unable to perform backup [fails always]
KK CHN <kkchn.in@gmail.com>
From: KK CHN <kkchn.in@gmail.com>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2026-02-25T07:26:55Z
Lists: pgsql-general
On Tue, Feb 24, 2026 at 9:20 PM Greg Sabino Mullane <htamfids@gmail.com> wrote: > On Tue, Feb 24, 2026 at 5:18 AM 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 > >