In my experience, everyone's setup is slightly different so it's hard to find a generic solution. pgcopydb is pretty good

I can't remember the name but I saw a Ruby based tool on Hacker News a few months ago that'd automate logical rep setup and failover for you