Re: Multiple backends on a single physical database - Mailing list pgsql-admin

From Vincent Janelle
Subject Re: Multiple backends on a single physical database
Date
Msg-id 3DA520E1.5020005@goblinstudios.com
Whole thread Raw
In response to Multiple backends on a single physical database  (Anuradha Ratnaweera <anuradha@gnu.org>)
Responses Re: Multiple backends on a single physical database
List 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 by date:

Previous
From: Anuradha Ratnaweera
Date:
Subject: Multiple backends on a single physical database
Next
From: Reiner Dassing
Date:
Subject: Upgrade to new version