[pgpool-general: 7895] Re: PGPool Load Balancing [SEC=UNOFFICIAL]

[Tatsuo Ishii]

> UNOFFICIAL
> 
> Hi,
> 
> I am preparing for an upgrade from 4.1.4 to 4.2.5 and have installed the new version in our test environment. After making the necessary configuration changes required for the upgrade I am finding the load balancing does not seem to be working - the standby database is not shown as the load balance node and queries are all serviced by the primary. Our setup is one primary database and one standby with streaming replication. I have set the following -
> 
> load_balance_mode = on
> disable_load_balance_on_write = 'transaction'
> 
> The output of show pool_nodes is
> 
> node_id | hostname | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
> ---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
> 0       | xxxx     | 5432 | up     | 0.500000  | primary | 18         | true              | 0                 |                   |                        | 2021-11-24 15:33:12
> 1       | xxxxxxx  | 5432 | unused | 0.500000  | standby | 0          | false             | 0                 |                   |                        | 2021-11-24 15:33:12
> (2 rows)

Looks like the initial pgpool_status for node 1 is down or unused, and
pgpool was started without -D option. You can try pcp_attach_node
command to let pgpool recognize node 1 is working.

Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp