Re: allow servers to access to the same data - Mailing list pgsql-general

From Craig Ringer
Subject Re: allow servers to access to the same data
Date
Msg-id 507EB1E9.8020501@ringerc.id.au
Whole thread Raw
In response to allow servers to access to the same data  (GMAIL <federico.serale@gmail.com>)
List pgsql-general
On 17/10/2012 9:20 PM, GMAIL wrote:
> it's possible to access the same data from two different servers. the
> two servers have the same IP and not run simultaneously

On shared storage? Yes, but it's a bad idea, because if they're ever
both started at the same time the data will be critically corrupted. You
need utterly reliable STONITH, preferably power-cut style.

It sounds like you're attempting a shared storage fail-over system.
That's ... not ideal. You're better off with replication based failover.
You should probably explain what you're trying to do and why, so better
advice can be offered.


--
Craig Ringer


pgsql-general by date:

Previous
From: GMAIL
Date:
Subject: allow servers to access to the same data
Next
From: Tulio
Date:
Subject: Re: allow servers to access to the same data