Hello.
I need failover postgresql installation. Two servers work's together. If
one server fail - another server doing queries.
In MySQL i'm use two server (mysql-ndb and two mysql api server (getting
queries) with mysql-proxy. If one server fail mysql-proxy route all
queries to another.
How
http://www.postgresql.org/docs/8.4/static/high-availability.html would
be a good place to start research. And the archives of this thread
would be another - there are recent messages about this sort of thing.
And google postgres high availability or equivalent.
I use slony but there are plenty
On Tue, 2010-07-13 at 13:33 +0400, Vasiliy G Tolstov wrote:
I need failover postgresql installation. Two servers work's together.
If one server fail - another server doing queries.
snip
How can i do this in postgresql?
If you don't {have/want to use} shared storage, you can use WAL