Hello All,
Does anybody have a live cluster with 2 or more computers running PostgreSQL, connected to single database on shared storage or to replicated database with load balancing between them?
No, because you can't share the same database files between two independent servers. You could run PG on a cluster if it could distribute shared memory, but without specialised hardware it would be very slow.
Replication is fine, although load-balancing needs to be thought through. There's been plenty of discussion of this recently, search the archives for "cluster" or "replication" or "slony".
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
