[pgpool-general: 5121] Re: PGPool failover backend communication error clarification

Tatsuo Ishii ishii at sraoss.co.jp
Mon Nov 14 08:39:21 JST 2016


> Hi,
> 
> I have a question regarding the fail_over_on_backend_error option,
> specifically what exactly constitutes a backend communication error.
> Consider a client connecting to a server through pgpool. If for some reason
> a SQL error is returned by the server before a SQL connection is
> established (e.g. an ErrorResponse during start-up, see
> https://www.postgresql.org/docs/current/static/protocol-flow.html) would
> this constitute a backend communication error and mark the server as down?

No.

> I assume that this would be the case during normal health check procedures.

health check procedures are not affected by fail_over_on_backend_error.
What's your concern with health check procedures?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list