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

Giuseppe Sacco giuseppe at sguazz.it
Mon Nov 7 23:12:59 JST 2022


Il giorno lun, 07/11/2022 alle 22.41 +0900, Bo Peng 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
> [...]
> If you are using streaming replication mode,
> and you are setteing backend_weight0 = 0 and backend_weight1 = 1,
> Pgpool-II should send all read queries to standby and write queries to
> primary.
> 
> Which version of Pgpool-II are you using?
> How did you set the parameter "backend_clustering_mode"

pgpool-II is version 4.3.3 running on an Ubuntu Linux. Pgpool-II has been
downloaded from apt.postgresql.org. The parameter backend_clustering_mode
has value streaming_replication.

Thank you,
Giuseppe





More information about the pgpool-general mailing list