Re: 2 computers 1hd 2 postgres daemons. Is it possible?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Oscar Serrano" <oserra(at)fondos(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible?
Date: 2000-10-17 19:00:42
Message-ID: 1763.971809242@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Oscar Serrano" <oserra(at)fondos(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-10-17 19:11:55 Re: unreasonably slooooow query on small table from JDBC & Zeos
Previous Message Joseph Shraibman 2000-10-17 18:53:56 [Fwd: 2 computers 1hd 2 postgres daemons. Is it possible?]