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
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 |