Thread: Re: Pgbackrest failure for INCR and DIFF but not FULL backup

Re: Pgbackrest failure for INCR and DIFF but not FULL backup

From
Greg Sabino Mullane
Date:
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