[pgpool-general: 7892] PGPool Load Balancing [SEC=UNOFFICIAL]
Mark Schloss
Mark.Schloss at austrac.gov.au
Wed Nov 24 13:43:55 JST 2021
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)
Any advice as to what I have wrong is appreciated.
Regards
Mark
UNOFFICIAL
**********************************************************************
Please note that your email address is known to AUSTRAC for the
purposes of communicating with you. The information transmitted in
this e-mail is for the use of the intended recipient only and may
contain confidential and/or legally privileged material. If you have
received this information in error you must not disseminate, copy or
take any action on it and we request that you delete all copies of
this transmission together with attachments and notify the sender.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211124/69a48b6b/attachment.htm>
More information about the pgpool-general
mailing list