Re: PostgreSQL on cluster

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: PostgreSQL on cluster
Дата
Msg-id
4200FC79.8000609@archonet.com
Ответ на
Список
Дерево обсуждения
PostgreSQL on cluster Yury Don <yura@vpcit.ru>
Re: PostgreSQL on cluster Richard Huxton <dev@archonet.com>
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
В списке pgsql-general по дате отправления
От: Rick Schumeyer
Дата:
Сообщение: basic pg lock question
От: Tom Lane
Дата:
FAQ