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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: KK CHN <kkchn(dot)in(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Pgbackrest failure for INCR and DIFF but not FULL backup
Date: 2025-05-07 13:16:01
Message-ID: CAKAnmm+ToUhZPGrzDssn2S4ie+znw0hVH_xKXe=6XRMSYjQS5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 7, 2025 at 7:15 AM KK CHN <kkchn(dot)in(at)gmail(dot)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

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-05-07 13:55:08 Re: pg_rewind problem: cannot find WAL
Previous Message Alicja Kucharczyk 2025-05-07 12:16:49 Re: huge_pages=on cause could not map anonymous shared memory: Cannot allocate memory