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 of other options. See also the not-yet-released version 9 of postgres with streaming replication. -- Ian. On Tue, Jul 13, 2010 at 10:33 AM, Vasiliy G Tolstov <v.tolstov@xxxxxxxxx> wrote: > 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 can i do this in postgresql? > > -- > Vasiliy G Tolstov <v.tolstov@xxxxxxxxx> > Selfip.Ru > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
