| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | 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 |