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

Greg Donald gdonald at gmail.com
Sun Jan 6 14:48:20 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




--
Greg Donald


More information about the pgpool-general mailing list