AW: AW: [Extern] Re: postgres restore & needed history files

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: AW: AW: [Extern] Re: postgres restore & needed history files
Date: 2023-01-13 11:23:24
Message-ID: c9d06edbe32e450291597a34949bc2bc@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Ursprüngliche Nachricht-----
> Von: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> Gesendet: Freitag, 13. Januar 2023 11:25
> An: Zwettler Markus (OIZ) <Markus(dot)Zwettler(at)zuerich(dot)ch>; pgsql-
> general(at)lists(dot)postgresql(dot)org
> Betreff: Re: AW: [Extern] Re: postgres restore & needed history files
>
> On Thu, 2023-01-12 at 16:50 +0000, Zwettler Markus (OIZ) wrote:
> > What would you do in case of a disaster when all history files in
> > pg_wal are gone and also deleted in the backup due to the backup retention?
>
> Easy. Take a new base backup immediately and don't try to restore a backup that
> was taken on an earlier timeline.
>
> Yours,
> Laurenz Albe

Hope I got you right.

You meant the latest backup within the latest timeline is always working even if the latest history files are gone.

Thanks, Markus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitrios Apostolou 2023-01-13 12:49:15 Re: Why is a hash join preferred when it does not fit in work_mem
Previous Message Laurenz Albe 2023-01-13 10:25:02 Re: AW: [Extern] Re: postgres restore & needed history files