On 22 August 2016 at 10:31, Michael Paquier <michael.paqu...@gmail.com>
wrote:

> On Sun, Aug 21, 2016 at 1:24 PM, Craig Ringer
> <craig.rin...@2ndquadrant.com> wrote:
> > On 21 Aug 2016 12:36 AM, "Bruce Momjian" <br...@momjian.us> wrote:
> >> Seems like another good idea to use pg_basebackup rather than manually
> >> doing base backups;  Magnus has been saying this for a while.
> >
> > The main time that's an issue is when you're rsync'ing to save bandwidth,
> > using CoW volume snapshots, etc. pg_basebackup becomes totally
> impractical
> > on big systems.
>
> Yes, and that's not fun. Particularly when the backup takes so long
> that WAL has already been recycled... Replication slots help here but
> the partitions dedicated to pg_xlog have their limit as well.
>

We can and probably should allow XLogReader to invoke restore_command to
fetch WAL, read it, and discard/recycle it again. This would greatly
alleviate the pain of indefinite xlog retention.

It's a pain to do so while recovery.conf is its own separate magic though,
not part of postgresql.conf.

I have no plans to work on this at this time.

-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Reply via email to