[pgpool-general: 1822] AWS and pgpool-II

Tatsuo Ishii ishii at postgresql.org
Wed Jun 5 13:40:51 JST 2013


Hi,

I have gotten a few complains about unwanted failover caused by TCP
connection errors on AWS.

By googling "AWS pgpool", I found a similar case:

1) https://forums.aws.amazon.com/thread.jspa?messageID=429906

Posted on Mar 3, 2014. Unfortunately in Japanese. In short, they got
"No route to host" error periodically. The region is
Tokyo(ap-northeast-1a). Up to now no replies so far.

I don't think Amazon is going to fix the problem soon. Maybe pgpool
should be prepared to such an unstable envrionment. For now, I
recommend to set fail_over_on_backend_error = off on AWS.
--
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