[pgpool-general: 8486] Re: disable load balancing to a master/slave cluster with streaming replication

[Giuseppe Sacco]

Hi all,

Il giorno lun, 07/11/2022 alle 13.40 +0100, Giuseppe Sacco ha scritto:
> Hello,
> I setup a master/slave configuration with postgresql 14, and I would like to
> send all read queries to the slave and all write statements to master. I
> enabled load balancing and specified backend_weight equal 0 for the master
> and 1 for the slave. Now, when clients connect and issue a write statement,
> they get errors about the postgresql being in read only. So, I think, these
> statements were sent to the slave machine.
[...]

How may I collect information about the way pgpool select the backend? Is
there any specific string I should look for in the log when running with
option -d? Does debug output include valuable information?

Thank you,
Giuseppe