Re: Pgpool Load Balancing

Hi,

If we are using RDS with read replica, do we need to enable the above
option.

Regards,
Fahad

On Wed, Jun 3, 2015 at 12:34 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:

> You need to change these:
>
> master_slave_mode = off
> master_slave_sub_mode = 'slony'
>
> to:
>
> master_slave_mode = on
> master_slave_sub_mode = 'stream'
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > Hi,
> >
> > Thanks for the reply.
> >
> > I am using postgresql version 9.4 in aws rds and its read replicas
> > pgpool-II version 3.1.
> >
> > and my pgpool.conf
> > Please let me know if anything is wrong.
> >
> > Regards,
> > Fahad
> >
> > On Wed, Jun 3, 2015 at 12:04 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org>
> wrote:
> >
> >> More details, pgpool-II version and pgpool.conf please, PostgreSQL
> >> version of S please.
> >>
> >> Also you would want to move to pgpool mailing list.
> >> (search on pgpool.net)
> >>
> >> I'm not sure but this ML may not be appropriate for technical
> >> discussions on pgpool-II.
> >>
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS, Inc. Japan
> >> English: http://www.sraoss.co.jp/index_en.php
> >> Japanese:http://www.sraoss.co.jp
> >>
> >> > Hi,
> >> >
> >> >
> >> > I am trying to load balance read queries using pgpool in aws,
> >> > My database setup is like one postgres master rds and two read
> replicas
> >> of
> >> > the master
> >> > But not able to load balance the read queries. All the queries are
> going
> >> to
> >> > node 0( host 0).
> >> >
> >> > Thanks in Advance
> >> >
> >> >
> >> > Regards,
> >> > Fahad
> >>
>