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. 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
