A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
