[pgpool-general: 5104] Re: About SELECT load balancing in master/slave mode

[Dennis Gearon]

There plenty of write conditions that will require a read first.

On Nov 6, 2016 4:13 AM, <erdenebat at skysys.mn> wrote:

> I'm testing pgpool-II 3.5.4. While load balancing is turned off, pgpool-II
> gives a following error:
>
>
> LOG: pool_read_kind: error message from 1 th kind backend:database "mydb"
> does not exist
>
> ERROR: unable to read message kind
>
> DETAIL: kind does not match between master(53) slot[1] (45)
>
>
> backend1 is standby server. I don't understand why pgpool-II tries to read
> from standby while load balancing is off.
>
> Regards,
> Erdenebat
>
>
> 06.11.2016, 19:31, "erdenebat at skysys.mn" <erdenebat at skysys.mn>:
>
> I turned off load balancing. But it seems that load balancing is still
> working.
> On the standby, it gives an error 'database does not exist'.
> I understand that pgpool-II does not access standby while load balancing
> is off.
>
>
> 02.11.2016, 17:57, "erdenebat at skysys.mn" <erdenebat at skysys.mn>:
>
> Hello guys,
>
> In pgpool-II FAQ
> <http://www.pgpool.net/mediawiki/index.php/FAQ#It_seems_my_pgpool-II_does_not_do_load_balancing._Why.3F>,
> it states that "SELECT will be load balanced even in a transaction if
> operated in the master/slave mode".
> Is there any way to do it in reverse? Is there any configuration not to
> load balance SELECT statement if a transaction is in the master/slave mode?
>
> Thanks in advance,
> Erdenebat Oyungerel
>
> ,
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> _______________________________________________
> 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.sraoss.jp/pipermail/pgpool-general/attachments/20161106/90d3933e/attachment.html>