Обсуждение: pgbackrest with no PITR option configuraton

Поиск
Список
Период
Сортировка

pgbackrest with no PITR option configuraton

От
"Ghiurea, Isabella"
Дата:

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 ?

thank you

Isbella

Re: pgbackrest with no PITR option configuraton

От
Ron Johnson
Дата:
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!

Re: pgbackrest with no PITR option configuraton

От
Tim Gerber
Дата:

On Fri, Sep 5, 2025 at 1:31 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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!

Re: Re: pgbackrest with no PITR option configuraton

От
"Ghiurea, Isabella"
Дата:

 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@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
 
***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!