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

From Tulio
Subject Re: allow servers to access to the same data
Date
Msg-id 507EB302.9040804@informidia.com.br
Whole thread Raw
In response to allow servers to access to the same data  (GMAIL <federico.serale@gmail.com>)
Responses Re: allow servers to access to the same data  ("Daniel Serodio (lists)" <daniel.lists@mandic.com.br>)
List pgsql-general
You can use a stream replication in hot standby (native) to have the same data and access in both (but not update and
insertin the slave, just select) <br /> and create a virtual IP using heartbeat.. configuring a master to use some IP
(virtual)and when this lost the IP, the second server (slave) will be use this IP..<br /> and will allow update and
insert...<br/><br /> is it that you want?<br /><br /><br /> Em 17/10/2012 10:20, GMAIL escreveu: <blockquote
cite="mid:507EB0B7.1010408@gmail.com"type="cite">it's possible to access the same data from two different servers. the
twoservers have the same IP and not run simultaneously <br /><br /><br /></blockquote> 

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: allow servers to access to the same data
Next
From: Fathi Ben Nasr
Date:
Subject: Re: PostgreSQL Magazine