<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>We have a critical application that uses PostgreSQL as its database. For high availability we are have the servers running as master and slaves using Pacemaker and openAIS/Corosync. The server pairs are geographically separated connected with a bridged VPN.
We have Pacemaker working with our applications and had PostgreSQL with DRBD functioning. However, our network conditions was affecting the DRBD replication too greatly. I was asled to look at using write ahead logging (WAL) streaming mode as an alternative
to replicating the database. I have replication without pacemaker now working. </p>
<p> </p>
<p> Now I am trying to get that integrated with pacemaker. In my searches, I see that pacemaker with DRBD seems to be the prevelant implementation an most documentation was written around that. However, due to our network conditions, I am looking for information
on doing this with WAL. I did find a resource agent that was wirtten for what I am doing (<a href="https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication">https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication</a>).
The issue is the example if complex with the explanation written only toward that example. Is there another place that I can get documentation on this resource agent? Is there another way that this could be accmoplished that someone has tried? </p>
<p> </p>
<p>Please let me know.</p>
<p>Keith</p>
<p> </p>
</div>
</body>
</html>