[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