Replication: re-initialisation of failed master

Hello all,

We run a 2 node setup replicating between a master and synchronous slave,
currently when we want to failover we basically kill the master off, create
a recovery file and re-point the traffic via a DNS record etc, we're
looking at implementing a corosync/pacemaker setup shortly.

Once we're running with the old secondary as the master the only way we
have to re-stage the old master is to use pg_basebackup against the new
master to replace the previous master's data directory.

It feels that given how little has probably changed on the new master
versus the old master that there should be a faster way of re-initializing
the old master as a slave. Is there some sort of short-cut speedup I'm
missing here? I suppose I'm mainly curious as to what techniques most
admins use to accomplish this!

Thanks in advance
Rob

--

<http://www.codeweavers.net>
​

March Newsletter - Customers want a high quality ‘clicks & bricks’ F & I
experience
<http://us6.campaign-archive2.com/?u=db934935d4174e46e9063c8c4&id=2578f201d7&e=[UNIQID]>

Last Month Product Highlights
<https://www.codeweavers.net/company-blog/february-product-highlights>

*Codeweavers Ltd* | Barn 4 | Dunston Business Village | Dunston | ST18 9AB
Registered in England and Wales No. 04092394 | VAT registration no. 974
9705 63
<https://twitter.com/CodeweaversTeam> <http://www.codeweavers.net/>
<contactus(at)codeweavers(dot)net>
<http://www.linkedin.com/company/225698?trk=tyah>
<https://www.facebook.com/codeweaverssoftware>