Pgpool2 doesn't use the slave for load balancing
1
vote
2
answers
5928
views
I've enabled streaming replication in my postgres 9.5.10 installed from ubuntu xenial repo. I want to enable load balance for pgpool-2 (3.7.0 amefuriboshi) installed from sources. So I have this pgpool.conf: https://pastebin.com/qWWgejQN
As you can see, I set both nodes, turned off replication, turned on master/slave mode and set it to stream. And also I enabled memcached caching.
Now I have very big problem that pgpool doesn't want to use slave for balancing:
postgres=# show pool_nodes;
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay
---------+----------------+------+--------+-----------+---------+------------+-------------------+-------------------
0 | localhost | 5433 | up | 0.500000 | primary | 0 | true | 0
1 | host2 | 5433 | unused | 0.500000 | standby | 0 | false | 0
(2 rows)
What am I do wrong?
Asked by abr_stackoverflow
(204 rep)
Nov 25, 2017, 11:59 AM
Last activity: Dec 23, 2021, 01:14 PM
Last activity: Dec 23, 2021, 01:14 PM