Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 9.0 Streaming Replication and Load Balancing? - Mailing list pgsql-general

From Sumit Raja
Subject Re: Postgres 9.0 Streaming Replication and Load Balancing?
Date
Msg-id CAB4mO2czCn50Xy19XDkO+Wa=Nm+TknhqjAUE5G1dFfnM3Fv9Bg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 9.0 Streaming Replication and Load Balancing?  (Paulo Correia <paulo.correia@pdmfc.com>)
Responses Re: Postgres 9.0 Streaming Replication and Load Balancing?
List pgsql-general
Tree view 
On 14 May 2012 17:28, Paulo Correia <paulo.correia@pdmfc.com> wrote:
> Hello all!

> Having a Postgres 9.0 with assynchronous streaming replication to a
> hot-standby slave, both with CentOs 5.6, how can I use both DB instances for
> query load balancing?
> I've tried with pgPool-II but the pooling mechanism is disruptive with the
> existing pool on the application servers.

Is the application RW or read only? What is the disruption being
caused? Are you seeing specific exceptions?

- Sumit

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: Uppercase to lowercase trigger?
Next
From: Condor
Date:
Subject: Vacuum does not show in pg_stat_all_tables