From: Tom Lane <tgl@sss.pgh.pa.us>
To: Oscar Serrano <oserra@fondos.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible?
Date: Tue, 17 Oct 2000 15:00:42 -0400
Message-ID: <1763.971809242@sss.pgh.pa.us> (raw)
In-Reply-To: <LAEOKGDJENIBFFEBGGIKOEGPCDAA.oserra@fondos.net>
References: <LAEOKGDJENIBFFEBGGIKOEGPCDAA.oserra@fondos.net>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, oserra@fondos.net
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible?
In-Reply-To: <1763.971809242@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox