On Wed, May 7, 2025 at 6:46 PM Greg Sabino Mullane <htamf...@gmail.com> wrote:
> On Wed, May 7, 2025 at 7:15 AM KK CHN <kkchn...@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 > > -- > Crunchy Data - https://www.crunchydata.com > Enterprise Postgres Software Products & Tech Support > >
