Re: allow servers to access to the same data

From: Tulio <tulio(at)informidia(dot)com(dot)br>
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:30:42
Message-ID: 507EB302.9040804@informidia.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#333333">
You can use a stream replication in hot standby (native) to have the
same data and access in both (but not update and insert in 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(dot)1010408(at)gmail(dot)com" type="cite">it's
possible to access the same data from two different servers. the
two servers have the same IP and not run simultaneously
<br>
<br>
<br>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 916 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fathi Ben Nasr 2012-10-17 13:36:27 Re: PostgreSQL Magazine
Previous Message Craig Ringer 2012-10-17 13:26:01 Re: allow servers to access to the same data