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

[Mark Schloss]

UNOFFICIAL
Hi Luca and Tatsuo,

Thank you both for your replies. pcp_attach_node resolved the issue. I wasn't aware the node state was recorded in the status file - the first time I started the 4.2 configuration I had a mistake in the config file in that the standby server details were commented. I thought uncommenting would be enough - lesson learnt!.

Regards

Mark 


UNOFFICIAL

-----Original Message-----
From: Tatsuo Ishii <ishii at sraoss.co.jp> 
Sent: Thursday, 25 November 2021 4:34 PM
To: Mark Schloss <Mark.Schloss at austrac.gov.au>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 7892] PGPool Load Balancing [SEC=UNOFFICIAL] [EXTERNAL]

> 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

**********************************************************************
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.
**********************************************************************