[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