[pgpool-general: 1289] Re: pgpool not load balancing
Tatsuo Ishii
ishii at postgresql.org
Sun Jan 6 17:13:16 JST 2013
> On Sat, Jan 5, 2013 at 11:17 PM, Greg Donald <gdonald at gmail.com> wrote:
>> Here's my pgpool.conf:
>>
>> http://pastebin.com/raw.php?i=CVpbG5Mp
>
>
> show pool_nodes;
> node_id | hostname | port | status | lb_weight | role
> ---------+--------------+------+--------+-----------+--------
> 0 | 192.168.1.81 | 5432 | 2 | 0.333333 | master
> 1 | 192.168.1.82 | 5432 | 1 | 0.333333 | slave
> 2 | 192.168.1.83 | 5432 | 1 | 0.333333 | slave
>
>
> Why are the slaves not status 2 as well? They are in sync with the master.
>
> postgres: wal sender process ruser 192.168.1.82(39827) streaming
> 0/ED01F764
> postgres: wal sender process ruser 192.168.1.83(51911) streaming 0/ED01F764
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'
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
More information about the pgpool-general
mailing list