Re: Clusters - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Clusters
Date
Msg-id 20021028163216.I21128@mail.libertyrms.com
Whole thread Raw
In response to Re: Clusters  (Sean Chittenden <sean@chittenden.org>)
List pgsql-performance
On Mon, Oct 28, 2002 at 01:18:46PM -0800, Sean Chittenden wrote:
>
> Didn't Tom say that it was possible if you had different WAL logs for
> each instance?  ie, just share the data directory, but everything else
> has to be on a per instance basis.  Check the archives, someone just
> asked about this a week ago or so.  -sc

As Sean says, check the archives.  But I think the problem is bigger
than just the WAL.  For instance, the pidfile is in the data
directory, so each system is going to try to overwrite that.  Plus,
there's no read-only mode for Postgres, so if one of the systems
writes where it shouldn't, you'll blow everything away.  I can
appreciate that some people like to play at the bare metal this way,
but it gives me ulcers ;-)

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Clusters
Next
From: eric soroos
Date:
Subject: Low Budget Performance