Thread: PostgreSQL on cluster

PostgreSQL on cluster

From
Yury Don
Date:
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?

--
Best regards,
 Yury                          mailto:yura@vpcit.ru


Re: PostgreSQL on cluster

From
Richard Huxton
Date:
Yury Don wrote:
> 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