Thanks very much for your reply Michael. I note that it looks like pgbarman employs pg_receivexlog; I will check it out.
Regards, Ruan ________________________________ From: Michael Paquier <michael.paqu...@gmail.com> Sent: 22 October 2017 22:17:01 To: Rhhh Lin Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Backup strategy using 'wal_keep_segments' On Mon, Oct 23, 2017 at 5:57 AM, Rhhh Lin <ruanline...@hotmail.com> wrote: > Is this approach feasible? Assuming obviously, we have sufficient disk space > to facilitate 1000 WAL files etc. You expose yourself to race conditions with such methods if a checkpoint has the bad idea to recycle past segments that your logic is copying. So I would advise to not do that. Instead of using the archive command, you should also consider using pg_receivexlog combined with a replication slot. This brings way more control with the error handling. -- Michael
