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

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