Re: allow servers to access to the same data

From: Tulio <tulio(at)informidia(dot)com(dot)br>
To: "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br>
Cc: GMAIL <federico(dot)serale(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: allow servers to access to the same data
Date: 2012-10-17 18:14:55
Message-ID: 507EF59F.4020307@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">
Sorry Daniel, but I don't have..<br>
and I was needing test this I was searching other tutorial... <br>
and was configuring ans testing..<br>
<br>
are you brazilian.. not?<br>
read this.. <a
href="http://www.hardware.com.br/tutoriais/drbd-heartbeat-samba/pagina2.html">http://www.hardware.com.br/tutoriais/drbd-heartbeat-samba/pagina2.html</a><br>
can be usefull for you..<br>
I don't know to much.. cause I'm stating in DB.. (aproximately one
year)<br>
but if can I help in something.. send me..<br>
<br>
<br>
Em 17/10/2012 14:53, Daniel Serodio (lists) escreveu:
<blockquote cite="mid:507EF09B(dot)6090105(at)mandic(dot)com(dot)br" type="cite">
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
Tulio wrote:
<blockquote cite="mid:507EB302(dot)9040804(at)informidia(dot)com(dot)br"
type="cite">
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
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>
</blockquote>
I've come across a few mentions of Heartbeat being used for
PostgreSQL failover, do have any links to more information about
this?<br>
<br>
<blockquote cite="mid:507EB302(dot)9040804(at)informidia(dot)com(dot)br"
type="cite"> 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>
</blockquote>
</blockquote>
<br>
Thanks in advance,<br>
Daniel Serodio</blockquote>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2012-10-17 18:25:12 Re: allow servers to access to the same data
Previous Message Merlin Moncure 2012-10-17 17:59:44 Re: problem with distinct not distincting...