Thread: Replication slot on master failure

On Mon, Sep 26, 2016 at 7:49 PM, hariprasath nallasamy
<hariprasathnallasamy@gmail.com> wrote:
>        We are using replication slot for capturing some change sets to
> update dependent tables.
>        Will there be inconsistency if the master fails and the standby takes
> the role of master.?

Replication slot creation is not replicated to standbys if that's what
you are looking for. So if you use a slot on master and consume its
data up to a given point, and then promote a standby, you may see a
gap of data after creating a slot, or if you created a slot previously
you may consume twice the same WAL records. Note that replication
slots created on standbys are initialized from the last checkpoint
redo record, so you could take advantage of this property before
promoting a standby.
--
Michael