| From: | Edu Joao <edujoao29(at)gmail(dot)com> |
|---|---|
| To: | "Zechman, Derek S" <Derek(dot)S(dot)Zechman(at)snapon(dot)com> |
| Cc: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pgbackrest question |
| Date: | 2026-07-23 02:52:22 |
| Message-ID: | CALB6gDXBJZfXQLiXoB9c6=WRnggn4zZ3C=g32P07_-kELoxdog@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Who the he’ll sending me this
On Wed, Jul 22, 2026 at 22:49 Zechman, Derek S <Derek(dot)S(dot)Zechman(at)snapon(dot)com>
wrote:
> I agree, why – what is the point of archiving wals outside of backup to a
> different location? This is a general want to learn question and not a
> critque. Thanks. Thinking outloud – I would think you would want wals in
> the same location outside of backup so pgbackrest can restore to any time
> outside of the backup window for optimal point in time recovery.
>
>
>
> *From:* Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> *Sent:* Wednesday, July 22, 2026 4:22 PM
> *To:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> *Subject:* Re: pgbackrest question
>
>
>
> On Wed, Jul 22, 2026 at 4: 13 PM Murthy Nunna <mnunna@ fnal. gov> wrote:
> Hi, I am new to pgbackrest… Using pgbackrest is it possible to run a backup
> that includes WALs that spans the duration of the backup ONLY. I prefer to
> archive WALs outside
>
> On Wed, Jul 22, 2026 at 4:13 PM Murthy Nunna <mnunna(at)fnal(dot)gov> wrote:
>
> Hi,
>
>
>
> I am new to pgbackrest… Using pgbackrest is it possible to run a backup
> that includes WALs that spans the duration of the backup ONLY. I prefer to
> archive WALs outside of pgbackrest for the routine archiving.
>
>
>
> Why? pgbackrest does a great job managing WALs and data backups, keeping
> everything consistent.
>
>
>
> More importantly, during restore, pgbackrest assumes that all the WALs
> will be where it thinks they are. Thus, while the backups *might* work,
> restores would fail.
>
>
>
> And if that is possible, can I use such a backup for PITR by providing the
> required WALs that go beyond the backup duration?
>
>
>
> This is something I can do today using pg_basebackup. I am looking to
> mimic this using pgbackrest.
>
>
>
> pgbackrest is not pg_basebackup; do not try to make pgbackrest act like
> pg_basebackup.
>
>
>
> --
>
> Death to <Redacted>, and butter sauce.
>
> Don't boil me, I'm still alive.
>
> <Redacted> lobster!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2026-07-23 04:04:02 | Re: pgbackrest question |
| Previous Message | Zechman, Derek S | 2026-07-23 02:49:03 | RE: pgbackrest question |