Re: Clusters - Mailing list pgsql-performance

From Sean Chittenden
Subject Re: Clusters
Date
Msg-id 20021028211846.GM92719@perrin.int.nxad.com
Whole thread Raw
In response to Re: Clusters  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Clusters  (Andrew Sullivan <andrew@libertyrms.info>)
Re: Clusters  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> > together behind an SLB? Assume that all systems have a qlogic
> > card, and are attached to a SAN, and that the SAN holds the
> > data. Can PostgreSQL be configured to read from the SAN? Does each
> > system have to initialize the DB?
>
> You can't do this safely.  PostgreSQL wants to control its disk.
> Someone has said on the (?) -general list that he has modified the
> PostgreSQL code to do this, but it makes me nervous.

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

--
Sean Chittenden

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Clusters
Next
From: Andrew Sullivan
Date:
Subject: Re: Clusters