<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EstiloCorreo18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-US>Tatsuo, In this email, there is an attached
file called cib.xml for using pgpool-HA with heartbeat 3.0.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>It was tested in 2 machines with this
enviroment, in each one:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
CentOS 6<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
PostgreSQL 9.0.5<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Pgpool-II V_3.0_STABLE<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Pgpool-HA recent release.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Heartbeat 3.0.5: <a
href="http://hg.linux-ha.org/heartbeat-STABLE_3_0/archive/7e3a82377fa8.tar.bz2">http://hg.linux-ha.org/heartbeat-STABLE_3_0/archive/7e3a82377fa8.tar.bz2</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Cluster Glue 1.0.9: <a
href="http://hg.linux-ha.org/glue/archive/glue-1.0.9.tar.bz2">http://hg.linux-ha.org/glue/archive/glue-1.0.9.tar.bz2</a>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Resource Agents 3.9.2: <a
href="https://github.com/ClusterLabs/resource-agents/tarball/v3.9.2">https://github.com/ClusterLabs/resource-agents/tarball/v3.9.2</a>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>•
Pacemaker 1.0.9: <a
href="http://hg.clusterlabs.org/pacemaker/stable-1.0/archive/tip.tar.bz2">http://hg.clusterlabs.org/pacemaker/stable-1.0/archive/tip.tar.bz2</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The ha.cf file of heartbeat was configured
like this:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal>debugfile /var/log/ha-debug<o:p></o:p></p>
<p class=MsoNormal>logfile /var/log/ha-log<o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>logfacility
local0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>keepalive 2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>deadtime 30<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>warntime 10<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>initdead 30<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>udpport
694<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>bcast
eth0
# Linux<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>auto_failback on<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>node
pg_01.vnz.uci.cu<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>node
pg_02.vnz.uci.cu<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>crm yes<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>I’m not an expert with Heartbeat, but is a
pleasure to my bring us this configuration. Perhaps this file can be
published in the official site of pgpool.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>In other moment, I going to try to write a
tutorial about this, but in Spanish.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Regards.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>