WAL Archiving and base backup

2022-01-12 Thread Issa Gorissen
Hello all, I've been upgrading some of our PostgreSQL instances from 9.x to 12.x and we're using a master/slave setup based on continuous archiving. I can read on https://www.postgresql.org/docs/12/continuous-archiving.html 25.3.3.2. Making an Exclusive Low-Level Backup that the exclusive me

Re: WAL Archiving and base backup

2022-01-12 Thread Issa Gorissen
Thx a lot. I thought about it but was not so sure about having a complex script (compared to the very simple version when using the exclusive backup - but this this is deprecated...). I will test your option with the simpler version and post it back to it can maybe land in PostgreSQL documenta

Re: WAL Archiving and base backup

2022-01-16 Thread Issa Gorissen
On 1/16/22 01:23, Mladen Gogala wrote: On 1/14/22 16:00, David G. Johnston wrote: I still don't really understand what is so great about it.  About its only redeeming feature is a declaration that "it is in core" and that newcomers can just default to it without thinking.  I'd rather just p