Re: Postgres 9.0 Streaming Replication and Load Balancing?

From: Sumit Raja <sumit(dot)raja(at)raja-consulting(dot)co(dot)uk>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 9.0 Streaming Replication and Load Balancing?
Date: 2012-05-15 08:01:28
Message-ID: CAB4mO2czCn50Xy19XDkO+Wa=Nm+TknhqjAUE5G1dFfnM3Fv9Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14 May 2012 17:28, Paulo Correia <paulo(dot)correia(at)pdmfc(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2012-05-15 08:59:21 Vacuum does not show in pg_stat_all_tables
Previous Message Chris Angelico 2012-05-15 07:57:00 Re: Uppercase to lowercase trigger?