public inbox for [email protected]  
help / color / mirror / Atom feed
pgbackrest 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]>
  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:31  Ron Johnson <[email protected]>
  parent: 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:44  Tim Gerber <[email protected]>
  parent: Ron Johnson <[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 19:04  Ghiurea, Isabella <[email protected]>
  parent: Ron Johnson <[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