Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154])
	by hub.org (8.10.1/8.11.0) with ESMTP id e9HJ0nW93494
	for <pgsql-interfaces@postgresql.org>;
	Tue, 17 Oct 2000 15:00:50 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id e9HJ0g501766;
	Tue, 17 Oct 2000 15:00:42 -0400 (EDT)
To: "Oscar Serrano" <oserra@fondos.net>
cc: pgsql-interfaces@postgresql.org
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible? 
In-reply-to: <LAEOKGDJENIBFFEBGGIKOEGPCDAA.oserra@fondos.net> 
References: <LAEOKGDJENIBFFEBGGIKOEGPCDAA.oserra@fondos.net>
Comments: In-reply-to "Oscar Serrano" <oserra@fondos.net>
	message dated "Tue, 17 Oct 2000 19:20:29 +0200"
Date: Tue, 17 Oct 2000 15:00:42 -0400
Message-ID: <1763.971809242@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200010/161
X-Sequence-Number: 1518

"Oscar Serrano" <oserra@fondos.net> writes:
> But with postgres... ugh! here is a big problem. I've tried to start two
> postgres, one in each Linux, and both having the PGDATA directory in the
> RAID. Both postgres start correctly, but the changes one postgres does, are
> not noticed by the second one.

This will not work; don't even think of trying it, unless you want to
corrupt your database beyond repair.

Postgres depends on shared-memory communication among backends, not only
on disk files, so there is no chance of making this work.

			regards, tom lane