Re: allow servers to access to the same data

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: GMAIL <federico(dot)serale(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: allow servers to access to the same data
Date: 2012-10-17 13:26:01
Message-ID: 507EB1E9.8020501@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tulio 2012-10-17 13:30:42 Re: allow servers to access to the same data
Previous Message GMAIL 2012-10-17 13:20:55 allow servers to access to the same data