Re: Pgbackrest failure for INCR and DIFF but not FULL backup - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Pgbackrest failure for INCR and DIFF but not FULL backup
Date
Msg-id CAKAnmm+ToUhZPGrzDssn2S4ie+znw0hVH_xKXe=6XRMSYjQS5Q@mail.gmail.com
Whole thread Raw
List pgsql-general
On Wed, May 7, 2025 at 7:15 AM KK CHN <kkchn.in@gmail.com> wrote:
archive_command = 'pgbackrest --stanza=My_Repo archive-push %p && cp %p /data/archive/%f' 

Don't do this. You are archiving twice, and worse, the first part is using async archiving. Remove that whole "cp" part. Once that is fixed, run:

pgbackrest --stanza=My_Repo check

to verify that WAL is being archived quickly and properly. Then test your backups, checking the file /var/log/pgbackrest/My_Repo-archive-push-async.log and your postgres log if any problems arise.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Alicja Kucharczyk
Date:
Subject: Re: huge_pages=on cause could not map anonymous shared memory: Cannot allocate memory
Next
From: Laurenz Albe
Date:
Subject: Re: pg_rewind problem: cannot find WAL