Such documentation does not exists because such configuration does not exists. What do you exactly mean b=y "active/active" in this case?<br><br><br><div class="gmail_quote">On Sun, Jun 5, 2011 at 11:31 PM, Sachin Gokhale <span dir="ltr"><<a href="mailto:sysadmin@indicussoftware.com">sysadmin@indicussoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Where I get active/active setup document for postgres? I searched on<br>
clusterlabs site...but didn't get any help.<br>
<font color="#888888"><br>
sachin<br>
</font><div><div></div><div class="h5"><br>
On Fri, 20 May 2011 08:12:09 -0600<br>
Serge Dubrouski <<a href="mailto:sergeyfd@gmail.com">sergeyfd@gmail.com</a>> wrote:<br>
<br>
> On Fri, May 20, 2011 at 7:56 AM, Daniel Bozeman <<br>
> <a href="mailto:daniel.bozeman@americanroamer.com">daniel.bozeman@americanroamer.com</a>> wrote:<br>
><br>
> > Sachin,<br>
> ><br>
> > Check out pgpool-II (<a href="http://pgpool.projects.postgresql.org/" target="_blank">http://pgpool.projects.postgresql.org/</a>). Using<br>
> > pgpool, you can use postgres 9.0 streaming replication to set up a master<br>
> > server and a hot-standby which can accept read-only queries. pgpool will<br>
> > automatically send read-only transactions to the hot-standby, while writes<br>
> > will be sent to the master database and replicated to the standby using<br>
> > postgres streaming replication. Pgpool will also manage failover and online<br>
> > recovery of your postgres instances. You can then use Pacemaker to make<br>
> > pgpool and a virtual IP pointing to it highly available.<br>
> ><br>
> > That being said, implementing a reliable active/passive cluster with<br>
> > Pacemaker is not trivial. I am currently using LSB to manage pgpool, but I<br>
> > plan to write my own OCF resource or test/modify the one provided with the<br>
> > older pgpool-ha project.<br>
> ><br>
><br>
> Depends on what you call active/passive. Active/Passive can be easily<br>
> implemented with DRBD replication and there is at least 2 HOW-TO documents<br>
> on clusterlabs web site. Streaming replication is more like Active/Active<br>
> and this one isn't trivial at all. And not because of Pacemaker but because<br>
> of the way how Streaming replication is implemented in PostgreSQL. If it was<br>
> close to Oracle DataGuard for example it would be much easier.<br>
><br>
><br>
> > Take care,<br>
> ><br>
> > Daniel<br>
> ><br>
> > On May 20, 2011, at 7:37 AM, Serge Dubrouski wrote:<br>
> ><br>
> ><br>
> ><br>
> > On Thu, May 19, 2011 at 11:07 PM, Sachin Gokhale <<br>
> > <a href="mailto:sysadmin@indicussoftware.com">sysadmin@indicussoftware.com</a>> wrote:<br>
> ><br>
> >> Hello,<br>
> >><br>
> >> I have two nodes active/passive cluster created using documentation from<br>
> >> clusterlabs. Replication is working fine on my setup. I am using this<br>
> >> for Postgresql database.<br>
> >><br>
> >> But, I am getting how I configure or test Faileover scenario & how can I<br>
> >> add load balancing feature for my Postgres database.<br>
> >><br>
> ><br>
> > Do you need read only load balancing or read/write? First one is possible<br>
> > with PGSQL hot-standby databases, second one isn't possible in PGSQL AFAIK.<br>
> ><br>
> ><br>
> >><br>
> >> Looking for your kine help.<br>
> >> Thanks in advance.<br>
> >><br>
> >> Regards,<br>
> >><br>
> >> Sachin<br>
> >> ******************************************************<br>
> >> Sachin N. Gokhale<br>
> >> System Administrator<br>
> >> <<a href="mailto:sysadmin@indicussoftware.com">sysadmin@indicussoftware.com</a>><br>
> >> Indicus Software Pvt. Ltd.<br>
> >> 28' Varshanand Society.<br>
> >> Sinhgad Road Pune - 411038<br>
> >> Tel. No. - 91-20-24341287/88<br>
> >> Fax No. - 91-20-24341289<br>
> >> ******************************************************<br>
> >><br>
> >><br>
> >> _______________________________________________<br>
> >> Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> >> <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
> >><br>
> >> Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> >> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> >> Bugs:<br>
> >> <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
> >><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Serge Dubrouski.<br>
> > _______________________________________________<br>
> > Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> > <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
> ><br>
> > Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> > Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> > Bugs:<br>
> > <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> > <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
> ><br>
> > Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> > Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> > Bugs:<br>
> > <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
> ><br>
> ><br>
><br>
><br>
> --<br>
> Serge Dubrouski.<br>
<br>
******************************************************<br>
Sachin N. Gokhale<br>
System Administrator<br>
<<a href="mailto:sysadmin@indicussoftware.com">sysadmin@indicussoftware.com</a>><br>
Indicus Software Pvt. Ltd.<br>
28' Varshanand Society.<br>
Sinhgad Road Pune - 411038<br>
Tel. No. - 91-20-24341287/88<br>
Fax No. - 91-20-24341289<br>
******************************************************<br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Serge Dubrouski.<br>