Re: Re: pgbackrest with no PITR option configuraton

From: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: PGSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Re: pgbackrest with no PITR option configuraton
Date: 2025-09-05 19:04:26
Message-ID: 6c3f2cf8d4f94f478586f751aec54617@nrc-cnrc.gc.ca
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you for fast reply .

Unfortunately the configuration you mentioned here is still giving error : ( was jus tmy typo in this msg)

ERROR: [068]: archive_command '/bin/true' must contain pgbackrest
2025-09-05 11:54:32.422 P00 INFO: check command end: aborted with exception [068]
here is my pgbackrest entries for postgresql.conf
archive_command = '/bin/true'
archive_mode = on
log_filename = 'postgresql.log'
max_wal_senders = 3
wal_level = replica

And:
archive_command='pgbackrest --stanza=XXX-01 archive-push /bin/true'
gives this error and hangs here :
INFO: check repo1 configuration (primary)

________________________________
From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Sent: Friday, September 5, 2025 11:31:29 AM
To: Ghiurea, Isabella
Cc: PGSQL ADMIN
Subject: EXT: Re: pgbackrest with no PITR option configuraton

***Attention*** This email originated from outside of the NRC. ***Attention*** Ce courriel provient de l'extérieur du CNRC.

On Fri, Sep 5, 2025 at 2:26 PM Ghiurea, Isabella <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca<mailto:Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>> wrote:

Hi List,

My requirement is to use pgbackrest for running full PG backups only no need for PITR.

How to configure this in archive_command configuration parameter for pgbackrest conf.

seems pgbackrest always asks for archive_mode =on but I assume in archive_commnad I can instruct to not use/generate the WAL files. I trieded archive_command="/bint/rue" but getting error.

Any other suggestions ?

"PgBackrest without PITR" sounds like pg_basebackup.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ft 2025-09-07 14:11:03 pg_curl with cockies
Previous Message Tim Gerber 2025-09-05 18:44:14 Re: pgbackrest with no PITR option configuraton