Dmitry Koterov, 22.01.2014 22:35:
> I googled 1 hour approximately, but have not found a ready solution
> for this. So maybe this feature is in PostgreSQL todo-list, or
> something similar exists somewhere...
>
> Before the actual question, I'd like to give a small analogy. What I
> mostly love in MongoDB is that it supports a fully transparent scheme
> of replication failover. If you have >= 3 MongoDB notes (e.g. 1
> master and 2 replicas), and the master dies, in a couple of seconds a
> replica is AUTOMATICALLY elected as a new master, and all other
> replicas are AUTOMATICALLY begin to follow it. If the dead master is
> back again suddenly, it first appears as a replica, but in a couple
> of seconds it becomes a new master back (because it initially had a
> highest weight assigned), and all replicas become to follow it. All
> these steps are done automatically and transparently. It just works.
>
> So does something similar and more-or-less stable exist for PostgrSQL
> too?
Someone just blogged about this:
http://evol-monkey.blogspot.de/2014/01/setting-up-postgres-automated-failover.html