Request a Demo
Home   >   mailing lists

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

From KK CHN
Subject Re: Pgbackrest failure for INCR and DIFF but not FULL backup
Date
Msg-id CAKgGyB-2k0xEdSMME_yQu80JsxpApmm8_j8N1ekGjHNsjTSOzA@mail.gmail.com
Whole thread Raw
In response to Re: Pgbackrest failure for INCR and DIFF but not FULL backup  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view


On Wed, May 7, 2025 at 6:46 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
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:

I'm going to see if putting   archive_command = 'pgbackrest --stanza=My_Repo archive-push %p'   fix the problem.  This was haunting me for more than a week.

Thanks for the suggestion. 


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.

Thanks .  
Krishane


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Karsten P
Date:
Subject: Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union
Next
From: Luca Ferrari
Date:
Subject: Re: pg_rewind problem: cannot find WAL