Re: Shared disk - Mailing list pgsql-general

From Christopher Browne
Subject Re: Shared disk
Date
Msg-id m3acsl6ix2.fsf@knuth.knuth.cbbrowne.com
Whole thread Raw
In response to Shared disk  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
List pgsql-general
A long time ago, in a galaxy far, far away, NageshwarR@PLANETASIA.COM (Nageshwar Rao) wrote:
> I would like to use shared disk for two Postgresql database. I mean
> that two Postgresql Database point to same $PGDATA directory. Is
> this possible in Postgresql Clarification is appreciated.:p>

No, you can't do this, at least not if you expect the two database
processes to run at the same time.

There are High Availability systems that work in somewhat this
fashion; both servers access the same disk.  But with a very precise
set of semantics:

  -> The database filesystem is only mounted on one system at a time

  -> The database process only runs on one system at a time

  -> If the HA system detects that one server has gone down, it
     "kicks" it to keep it down, and starts up services on the other
     one.
--
select 'cbbrowne' || '@' || 'gmail.com';
http://linuxfinances.info/info/postgresql.html
You don't *run* programs on Ultrix.
                - Mark Moraes
Right, you chase them.
                - Rayan Zachariassen

pgsql-general by date:

Previous
From: tomas@nocrew.org (Tomas Skäre)
Date:
Subject: Re: Query is not using index when it should
Next
From: Ioannis Theoharis
Date:
Subject: Clustering in the presence of hierarchies (fwd)