Re: Postgres 9.0 Streaming Replication and Load Balancing?

Hello Sumit,

At the given point there are no exceptions since the tests for using
pgPool-II with the application using a master and a slave resulted in
all connections being done on the master and none on the slave.

As the application as it's own connection pool, eventually all
connections will have a RW operation and as so all these connections
will be linked to the master.

As so, I cannot benefit from load balancing since all my connections
will be redirected to the master by pgPool-II, even if they are RO.

Is it possible to have pgPool-II making only load balance with no
connection pool?

Best regards,
Paulo Correia

On 15/05/12 09:01, Sumit Raja wrote:
> 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
>