Re: Multiple backends on a single physical database

From: Vincent Janelle <random(at)goblinstudios(dot)com>
To: Anuradha Ratnaweera <anuradha(at)gnu(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Multiple backends on a single physical database
Date: 2002-10-10 06:40:33
Message-ID: 3DA520E1.5020005@goblinstudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Reiner Dassing 2002-10-10 07:46:14 Upgrade to new version
Previous Message Anuradha Ratnaweera 2002-10-10 06:09:23 Multiple backends on a single physical database