Sample Header Ad - 728x90

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