[pgpool-general: 9280] Re: Load balance question.

[Ron Johnson]

On Tue, Nov 26, 2024 at 1:35 PM Joan Ventura <ing.joanventura at gmail.com>
wrote:

> I have 2 servers. 1 primary master and 1 slave(read-only). The slave is
> replicating from the master.
>
> I am trying to configure a pgpool server. I already started the server,
> but the all query are been sent to the primary.
>
> How can i configure to send the read query to the slave?
>
> i have backend_flag0 = 'ALWAYS_PRIMARY' but everything that i put on
> backend_flag1 for the slave give error, except 'ALLOW_TO_FAILOVER', i have
> tried 'SECUNDARY' and 'slave'.
>

You misspelled SECONDARY.


> Also i have the setting load_balance_mode =0.
>

Why 0, when 0 always means "off"?

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241126/36b7d9bc/attachment.htm>