Обсуждение: Re: Pgbackrest failure for INCR and DIFF but not FULL backup

Поиск
Список
Период
Сортировка

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

От
Greg Sabino Mullane
Дата:
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

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

От
KK CHN
Дата:


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