[Pacemaker] Postresql streaming replication support

[Keith Ouellette]

Jesse,





   Thank you for the quick response. Actually yes, the example given at the link below shows several connections between the two (cross-overs).  We only have one connection between the two nodes with a bridged VPN.





[cid:005d0851-7d2e-40eb-888f-0dad3e243765]



The example has an S-LAN, D-LAN and an IC-LAN. I only have one LAN available to me with a bridge VPN between the two routers. I tried to skinny the configuration to a single virtual IP primitive called "ClusterIP", but I think there are some other dependancies in the example that I am not seeing as it did not work, meaning the resources did not start.  Is there another place I can go that may provide more detailed documentation that may help me with my configuration?





Keith

________________________________
From: Jesse Hathaway [jesse.hathaway at getbraintree.com]
Sent: Wednesday, January 09, 2013 2:09 PM
To: The Pacemaker cluster resource manager; Jesse Hathaway
Subject: Re: [Pacemaker] Postresql streaming replication support

On Wed, Jan 9, 2013 at 12:56 PM, Keith Ouellette <Keith.Ouellette at airgas.com<mailto:Keith.Ouellette at airgas.com>> wrote:

  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 (https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication). 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?

Keith we are using the above resource agent in production with streaming replication. Do you have any specific questions about its usage?

--
Jesse Hathaway, Systems Engineer
Braintree<http://getbraintree.com>
917-418-8423
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130109/ccc1e902/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled.jpg
Type: image/pjpeg
Size: 12676 bytes
Desc: Untitled.jpg
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130109/ccc1e902/attachment-0003.bin>