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

Поиск
Список
Период
Сортировка
От KK CHN
Тема Re: Pgbackrest failure for INCR and DIFF but not FULL backup
Дата
Msg-id CAKgGyB-2k0xEdSMME_yQu80JsxpApmm8_j8N1ekGjHNsjTSOzA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pgbackrest failure for INCR and DIFF but not FULL backup  (Greg Sabino Mullane <htamfids@gmail.com>)
Список pgsql-general
Дерево обсуждения


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 по дате отправления: