Re: Multiple backends on a single physical database

Поиск
Список
Период
Сортировка
От Vincent Janelle
Тема Re: Multiple backends on a single physical database
Дата
Msg-id 3DA520E1.5020005@goblinstudios.com
обсуждение исходный текст
Ответ на Multiple backends on a single physical database  (Anuradha Ratnaweera <anuradha@gnu.org>)
Ответы Re: Multiple backends on a single physical database  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
No.  Only one postmaster can access the PGDATA dir at one time.
 Attempting to run multiple copies will result in data corruption.

http://gborg.postgresql.org/project/pgreplication/projdisplay.php
contains the gborg project for replication.

Anuradha Ratnaweera wrote:

>I am wondering if it is sane to mount PGDATA over NFS on many
>machines and run posmaster backends on them, so that all the
>postmasters are using the same database.
>
>Obviously performance is going to suffer because network traffic
>is going to be high, but later we may use a distributed filesystem
>with replications instead of NFS.
>
>Thanks in advance.
>
>    Anuradha
>
>
>




В списке pgsql-admin по дате отправления:

Предыдущее
От: Anuradha Ratnaweera
Дата:
Сообщение: Multiple backends on a single physical database
Следующее
От: Reiner Dassing
Дата:
Сообщение: Upgrade to new version