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

[Tatsuo Ishii]

Glad to hear that. Thanks for the feedback.

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

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