On Mon, Sep 26, 2016 at 7:49 PM, hariprasath nallasamy <hariprasathnallasamy@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
