Re: Including replication slot data in base backups - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Including replication slot data in base backups
Date
Msg-id CAB7nPqRZhZ51YH1cv=1H3oG+TKHeoAgoq8x13s4Cbun6Qg_JNg@mail.gmail.com
Whole thread Raw
In response to Re: Including replication slot data in base backups  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Including replication slot data in base backups  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Wed, Apr 2, 2014 at 10:27 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> The new master won't necessarily have all the neccessary WAL available, no?
No, they won't have it, and things begin to get bad once a base backup
includes a slot that has a non-null value of restart_lsn. I imagine
that if we want to guarantee the correctness of a replication slot we
would need to fetch from archives the necessary WAL files needed for
it when a node is in recovery, which is not something that this patch
does...
-- 
Michael



pgsql-hackers by date:

Previous
From: Joshua Yanovski
Date:
Subject: Proposal: COUNT(*) (and related) speedup
Next
From: Andres Freund
Date:
Subject: Re: Including replication slot data in base backups