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 507F363A.4010306@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
Please reply to the mailing list, not directly to me.

Reply follows below.

On 10/17/2012 10:46 PM, GMAIL wrote:
i want that the main pc save two identical databases, the first database will be saved on local hard drive and the second database will be saved on a nas.
if the main pc has a failover, a second pc will be turned up with the same ip and access to the database on the nas

How do you intend to get the main pc to save two identical databases?

I wouldn't recommend running Pg off a NAS file system like NFS or CIFS.

This plan is fragile and failure prone. I very strongly recommend that you use replication instead. See

  http://www.postgresql.org/docs/current/static/high-availability.html
  http://wiki.postgresql.org/wiki/Shared_Storage

--
Craig Ringer

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: problem with distinct not distincting...
Next
From: Craig Ringer
Date:
Subject: Re: database corruption questions