[pgpool-general: 1291] Re: pgpool not load balancing

Greg Donald gdonald at gmail.com
Mon Jan 7 02:39:55 JST 2013

On Sun, Jan 6, 2013 at 2:13 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> You are still using pgpool in replication mode, aren't you?
> Jan  5 23:02:49 pool pgpool[17370]: find_primary_node: not in streaming replication mode
> To enable streaming replication mode of pgpool, you need:
> replication_mode = off
> master_slave_mode = on
> master_slave_sub_mode = 'stream'

Works, I can now see equal work loads being distributed to all three servers.

I already had replication setup using PostgreSQL directly so my
confusion was I thought the master_slave* settings were for if I
wanted pgpool to manage replication for me.

Thanks a lot.

Greg Donald

More information about the pgpool-general mailing list