AW: AW: [Extern] Re: postgres restore & needed history files
От | Zwettler Markus (OIZ) |
---|---|
Тема | AW: AW: [Extern] Re: postgres restore & needed history files |
Дата | |
Msg-id | c9d06edbe32e450291597a34949bc2bc@zuerich.ch обсуждение исходный текст |
Ответ на | Re: AW: [Extern] Re: postgres restore & needed history files (Laurenz Albe <laurenz.albe@cybertec.at>) |
Ответы |
Re: AW: AW: [Extern] Re: postgres restore & needed history files
|
Список | pgsql-general |
> -----Ursprüngliche Nachricht----- > Von: Laurenz Albe <laurenz.albe@cybertec.at> > Gesendet: Freitag, 13. Januar 2023 11:25 > An: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>; pgsql- > general@lists.postgresql.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
В списке pgsql-general по дате отправления: