Salü, we're trying to set up a multi-master (write anywhere) setup between two PostgreSQL databases and have so far failed with both Postgres-R and PGCluster. Our setup involves two machines (VMs for testing, iron later once it works) on a local network, both accessible "externally" from the DB clients, both are supposed to be usable for reading and writing, even if one of them goes down.
I tried a setup with a replication server on one of the cluster nodes, or on two of them (initially). My first setups were with PostgreSQL 8.1 on Debian etch, followed by the same on lenny, and now pgsql 8.3 on lenny. Neither setup is really working, although I got very close with the 8.1 on lenny variant, where one client can e.g. INSERT something, and the other one sees it immediately, but the client is hanging (i.e. the INSERT query is never returning), and the database locked and "under restoration". Switching to Debian/i386 (etch or lenny) is, unfortunately, not an option due to the sheer size of the production database (the boxen have 8 GiB RAM, which, while fitting into PAE, would not be usable by a normal programme using the ELF32 ABI), and other reasons. Do you see any chance to get a setup like this (we actually do not care about with which patch for pgsql it's done, just that it works) running? Thanks in advance! bye, //Th.Glaser -- SyGroup GmbH Thorsten Glaser Tel: +41 61 333 80 33 Güterstrasse 86 Fax: +41 61 383 14 67 4053 Basel Web: www.sygroup.ch [EMAIL PROTECTED] _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
