public inbox for [email protected]
help / color / mirror / Atom feedpgbackrest with no PITR option configuraton
4+ messages / 3 participants
[nested] [flat]
* pgbackrest with no PITR option configuraton
@ 2025-09-05 18:26 Ghiurea, Isabella <[email protected]>
2025-09-05 18:31 ` Re: pgbackrest with no PITR option configuraton Ron Johnson <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Ghiurea, Isabella @ 2025-09-05 18:26 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgbackrest with no PITR option configuraton
2025-09-05 18:26 pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
@ 2025-09-05 18:31 ` Ron Johnson <[email protected]>
2025-09-05 18:44 ` Re: pgbackrest with no PITR option configuraton Tim Gerber <[email protected]>
2025-09-05 19:04 ` Re: Re: pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
0 siblings, 2 replies; 4+ messages in thread
From: Ron Johnson @ 2025-09-05 18:31 UTC (permalink / raw)
To: Ghiurea, Isabella <[email protected]>; +Cc: pgsql-admin
On Fri, Sep 5, 2025 at 2:26 PM Ghiurea, Isabella <
[email protected]> 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!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgbackrest with no PITR option configuraton
2025-09-05 18:26 pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
2025-09-05 18:31 ` Re: pgbackrest with no PITR option configuraton Ron Johnson <[email protected]>
@ 2025-09-05 18:44 ` Tim Gerber <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: Tim Gerber @ 2025-09-05 18:44 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: Ghiurea, Isabella <[email protected]>; pgsql-admin
You also have a mis-spelling in the archive_command which I'm guessing is
why it failed. Needs to be:
archive_command="/bin/true"
On Fri, Sep 5, 2025 at 1:31 PM Ron Johnson <[email protected]> wrote:
> On Fri, Sep 5, 2025 at 2:26 PM Ghiurea, Isabella <
> [email protected]> 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!
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re: pgbackrest with no PITR option configuraton
2025-09-05 18:26 pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
2025-09-05 18:31 ` Re: pgbackrest with no PITR option configuraton Ron Johnson <[email protected]>
@ 2025-09-05 19:04 ` Ghiurea, Isabella <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: Ghiurea, Isabella @ 2025-09-05 19:04 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: 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 <[email protected]>
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 <[email protected]<mailto:[email protected]>> 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!
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-09-05 19:04 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-09-05 18:26 pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
2025-09-05 18:31 ` Re: pgbackrest with no PITR option configuraton Ron Johnson <[email protected]>
2025-09-05 18:44 ` Re: pgbackrest with no PITR option configuraton Tim Gerber <[email protected]>
2025-09-05 19:04 ` Re: Re: pgbackrest with no PITR option configuraton Ghiurea, Isabella <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox