[pgpool-general: 9279] Load balance question.

[Joan Ventura]

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

Also i have the setting load_balance_mode =0.

Any idea?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241126/5b9f905d/attachment.htm>