Обсуждение: postgresql failover
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@selfip.ru> Selfip.Ru
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@selfip.ru> 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@selfip.ru> > Selfip.Ru > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
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 replication: http://www.postgresql.org/docs/current/static/warm-standby.html There are two tools that I can suggest for this. Walmgr: http://pgfoundry.org/projects/skytools/ or pitrtools: https://projects.commandprompt.com/public/pitrtools/ If you want to use shared storage, I'd suggest using Red Hat Cluster Suite or such. http://www.gunduz.org/download.php?dlid=142 is the link to the presentation that I made 4 years ago about this. We have customer here who is using RHCS+PostgreSQL 8.4 on 4 servers, which use shared storage and they failover each other whenever one of them goes down. You can also use Slony-I or Londiste, too. Please note that 9.0 will ship with major features for this. -HTH. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz