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