[pgpool-general: 4933] Re: Load balancing issue

[Lucas Luengas]

Hello.

Have you checked pgpool log file?  Maybe a failover happened?

On Fri, Aug 19, 2016 at 10:48 PM, Vlad Novikov <xou.slackware at gmail.com>
wrote:

> Hello,
>
> I'm have setup pgpool-II with 2 backends in streaming mode (see
> configuration file attached). In particular, I have load_balance_mode = off
> to make sure that in this pool all connections will be established to
> streaming master only. However, over some time I see pgpool-II establishing
> connections to hot standby server. As a result client applications start
> failing as they cannot write to the database they're connected to. So far
> the only solution for me is to keep the hot standby detached (which is not
> a good idea in terms of automated failover).
> Pgpool-II starts behaving like this at about 100 clients connected.
> PostgreSQL max_connections is set to 900 and with hot standby detached
> there are no connection issues reported (all clients can connect to the
> backend with no issues).
> I use pgpool-II and PostgreSQL provided by PostgreSQL official repository.
> PostgreSQL 9.4.9
> pgpool-II 3.5.3
> OS: CentOS 7.2
>
> Is there anything I need to change in the configuration file to make all
> clients connect to master only when both backends are attached? From what I
> understand that is expected with load_balance_mode = off.
>
> Regards,
> Vlad
>
> _______________________________________________
> 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/20160820/70efcd87/attachment.html>