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

[Luca Maranzano]

Hi Mark,
there is a big change from 4.1 to 4.2, because configuration files can be
identical on all nodes and to distinguish nodes id you have to create the
pgpool_node_id file on every node.
Please read section 8.2.5 here
https://www.pgpool.net/docs/latest/en/html/example-cluster.html.

>From your output it seems that the standby is not correctly recognized.
HTH
Cheers
Luca

On Wed, Nov 24, 2021 at 5:44 AM Mark Schloss <Mark.Schloss at austrac.gov.au>
wrote:

> *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.
>
> **********************************************************************
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211124/88900344/attachment.htm>