Re: Re: pgbackrest with no PITR option configuraton
| От | Ghiurea, Isabella |
|---|---|
| Тема | Re: Re: pgbackrest with no PITR option configuraton |
| Дата | |
| Msg-id | 6c3f2cf8d4f94f478586f751aec54617@nrc-cnrc.gc.ca обсуждение исходный текст |
| Ответ на | Re: pgbackrest with no PITR option configuraton (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Список | 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]
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
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@gmail.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
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.Ghiurea@nrc-cnrc.gc.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!
В списке pgsql-admin по дате отправления: