Re: AW: [Extern] Re: postgres restore & needed history files - Mailing list pgsql-general

From Ron
Subject Re: AW: [Extern] Re: postgres restore & needed history files
Date
Msg-id 8129a929-8dfe-89e3-4104-fbf7e9d4eaaa@gmail.com
Whole thread Raw
In response to AW: [Extern] Re: postgres restore & needed history files  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-general
On 1/12/23 10:50, Zwettler Markus (OIZ) wrote:
[snip]
> 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
tothe backup retention?
 

Yet another reason why you should not roll your own PITR backup solution.  
Use something like pgBackRest (what I use) or BarMan.

-- 
Born in Arizona, moved to Babylonia.



pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: [Extern] Re: postgres restore & needed history files
Next
From: Ron
Date:
Subject: gexec from command prompt?