<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">2017-05-18 1:28 GMT+02:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">> Hi! I've been trying to deploy a postgresql cluster in production during<br>
> maintenance windows for a few days now. But I seem to run into an issue<br>
> with pgpool.<br>
><br>
> The pgpool sits on it's own instance infront of 4 x c3.2xlarge instance<br>
> where the actual cluster is housed. The cluster is managed with repmgr. All<br>
> servers are running FreeBSD 11.0 fully patched. I also tried pgpool on<br>
> debian 8.8 with the same result. All of these servers are running on AWS in<br>
> us-east-1. There is an extra instance which I am trying to migrate away<br>
> from - the last one in the attached config. Plan was to setup the cluster,<br>
> clone from current master and then do a switchover and lastly shut down old<br>
> master and detach it from pgpool.<br>
><br>
> The pgpool has no issue finding the backends and marking them as healthy.<br>
> However, when I am trying to add more than one of our webservers to it (RoR<br>
> based API webserver) it silently fails, or so it seems atleast.<br>
<br>
</span>So one of the web servers running RoR cannot connect to Pgpool-II?<br></blockquote><div>No, no more than one was being able to connect. I think this might be due to connection settings? </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<span class=""><br>
> I ran<br>
> pgpool in foreground and did not note any errors at all. Nor were there any<br>
> errors in PostgreSQL servers, except for the occassional slow query.<br>
><br>
> I could during these attempts to deploy connect to the servers indivudally<br>
> from the pgpool instance and execute queries. So I am fairly certain there<br>
> were no connectivity issues - no dropped packets were observed either.<br>
><br>
> I am hoping this is a configuration issue on my end. If not I would like to<br>
> request assistance in how I could debug this.<br>
<br>
</span>One of the starters is, turn on debug mode on Pgpool-II.<br>
<span class=""><br>
> I am attaching the config of pgpool in this mail. Please let me know if you<br>
> see something obviously incorrect.<br>
<br>
</span>So far I see no problems.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br></div></div>