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

2023-01-13 Thread Laurenz Albe
On Thu, 2023-01-12 at 16:50 +, 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

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

2023-01-12 Thread Ron
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 to the backup retention? Yet another reason why you should not roll your own PITR backup solution.  Use something like pgB