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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
