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

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2023-01-13 11:23:24 AW: AW: [Extern] Re: postgres restore & needed history files
Previous Message vignesh C 2023-01-13 06:33:26 Re: Support logical replication of DDLs