<br><br><div class="gmail_quote">2010/6/29 Gordan Bobic <span dir="ltr"><<a href="mailto:gordan@bobich.net">gordan@bobich.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <div class="im">On 06/29/2010 01:26 PM, ESGLinux wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi all,<br> <br> I need to mount a two nodes cluster with postgres as service. I have<br> mounted it in the past but with a shared storage and using GFS but now I<br> don´t have this element.<br> </blockquote> <br></div> Any particular reason why you cannot use DRBD to provide that element without a standalone SAN?<div class="im"><br></div></blockquote><div><br></div><div>the reason is that I haven´t done it before ;-). perhaps it´s time to take a look at DRBD...</div> <div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im"> <br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> The idea is to have a master node with all the data in its own disk and<br> have a mechanism to replicate this data to the slave node in its own<br> disk. If the master goes down the slave begin to give the service and<br> the flow of data will go from this node to the other one. (the slave<br> node becomes the master one)<br> </blockquote> <br></div> Have a look at Bucardo replication system for PostgreSQL:<br> <a href="http://bucardo.org/" target="_blank">http://bucardo.org/</a><br> <br></blockquote><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> It is as similar a solution as PostgreSQL has available to MySQL's replication.<br> <br> It's master-slave only, though, there is no provision for master-master replication like in MySQL (but master-master is riddled with race conditions anyway, and you shouldn't be using it if you don't understand the edge cases that are likely to break your app).<br> <br> Have a look here for more info on PostgreSQL's replication/clustering functionality:<br> <br> <a href="http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling" target="_blank">http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling</a><br> <br></blockquote><div><br></div><div>Interesting link, I´m going to evaluate this solutions</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">You're probably better off asking about this stuff on the PostgreSQL mailing lists, though.<br> <font color="#888888"> <br></font></blockquote><div><br></div><div>I´ll do it, </div><div><br></div><div>Thank you all for your answers</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <font color="#888888"> Gordan</font><div><div></div><div class="h5"><br> <br></div></div></blockquote><div><br></div><div>ESG</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div class="h5"> --<br> Linux-cluster mailing list<br> <a href="mailto:Linux-cluster@redhat.com" target="_blank">Linux-cluster@redhat.com</a><br> <a href="https://www.redhat.com/mailman/listinfo/linux-cluster" target="_blank">https://www.redhat.com/mailman/listinfo/linux-cluster</a><br> </div></div></blockquote></div><br>