<div dir="ltr"><div class="gmail_default" style=""><font face="monospace, monospace">That appears to be correct. To be specific, the postgres and pgpool packages I'm using are found here:</font></div><div class="gmail_default" style=""><font face="monospace, monospace"><br></font></div><div class="gmail_default" style=""><font face="monospace, monospace"><a href="https://download.postgresql.org/pub/repos/yum/9.2/redhat/rhel-6-x86_64/">https://download.postgresql.org/pub/repos/yum/9.2/redhat/rhel-6-x86_64/</a></font><br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><font face="monospace, monospace" size="2"><br></font><div><font face="monospace, monospace" size="2">Mike Neir</font></div><div><font face="monospace, monospace" size="2">Infrastructure Administrator</font></div><div><font face="monospace, monospace" size="2">Liquid Web, Inc.</font></div><div><br></div></div></div></div></div></div><div class="gmail_quote">On Tue, Mar 8, 2016 at 4:01 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Assuming you mean pgdg yum repositories by<br>
<a href="http://www.postgresql.org/download/linux/redhat/" rel="noreferrer" target="_blank">http://www.postgresql.org/download/linux/redhat/</a>, yhe maintainer of it<br>
is Devrim and he is on this list.<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_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="HOEnZb"><div class="h5"><br>
> Muhammad,<br>
><br>
> Excellent news! Thank you for getting that corrected so quickly. Is there<br>
> any way of knowing how long it will take for that change to be reflected in<br>
> pgpool pacakge in the pgdg yum repositories, or is that out of the pgpool<br>
> developers' scope of influence?<br>
><br>
> MN<br>
><br>
><br>
> Mike Neir<br>
> Infrastructure Administrator<br>
> Liquid Web, Inc.<br>
><br>
> On Mon, Mar 7, 2016 at 10:47 AM, Muhammad Usama <<a href="mailto:m.usama@gmail.com">m.usama@gmail.com</a>> wrote:<br>
><br>
>> Hi Mike<br>
>><br>
>> Thanks for pointing out this out, The problem was caused by the logical<br>
>> mistake in the latest version of pgpool-II and I have pushed the fix for it.<br>
>><br>
>><br>
>> <a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=e2f822fae9a4956f210bccafd0eade26642c90fa" rel="noreferrer" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=e2f822fae9a4956f210bccafd0eade26642c90fa</a><br>
>><br>
>> Regards<br>
>> Muhammad Usama<br>
>><br>
>><br>
>> On Sat, Mar 5, 2016 at 5:43 AM, Mike Neir <<a href="mailto:mike@liquidweb.com">mike@liquidweb.com</a>> wrote:<br>
>><br>
>>> Greetings pgpool devs and users,<br>
>>><br>
>>> I am attempting to re-create a postgres 9.2 + pgpool setup that a former<br>
>>> co-worker created so that I may become more familiar with the setup process<br>
>>> and so it can be properly documented. I am configuring a two-node test lab<br>
>>> using streaming replication, where the postgres WAL sender handles writes,<br>
>>> and both the WAL sender and receiver can handle reads.<br>
>>><br>
>>> I believe I have everything configured properly except for one vexing<br>
>>> issue. When running queries through pgpool, even simple status queries, the<br>
>>> workers will eventually die, having reached their internal connection<br>
>>> limit. This is expected, but pgpool does not seem to be forking another<br>
>>> worker to replace it, and that behavior eventually results in pgpool not<br>
>>> being able to handle queries due to a lack of workers. This manifests in<br>
>>> the logs as follows:<br>
>>><br>
>>> 2016-03-04 18:27:50: pid 8754: FATAL: child exiting, 500 connections<br>
>>> reached<br>
>>> 2016-03-04 18:27:50: pid 8303: LOG: child process with pid: 8754 exits<br>
>>> with status 512<br>
>>> 2016-03-04 18:27:50: pid 8303: LOG: child process with pid: 8754 exited<br>
>>> with success and will not be restarted<br>
>>><br>
>>> I have not yet got to the point of importing data into postgres. I can<br>
>>> manifest this condition with repeated execution of the following command:<br>
>>> $ psql -h localhost -U monitor postgres -c "SHOW pool_nodes;"<br>
>>><br>
>>> The behavior is the same on both nodes, regardless of whether it is a WAL<br>
>>> sender or recevier.<br>
>>><br>
>>> I've attempted to dig through the sources to find the scenario that would<br>
>>> tell pgpool that not forking a replacement worker is proper behavior, but<br>
>>> my C is *very* rusty, and I ran out of patience long before I understood<br>
>>> what leads to that condition.<br>
>>><br>
>>> In short, I'm looking for insight on what configuration directives could<br>
>>> lead to that behavior, and how to correct it.<br>
>>><br>
>>> Environment Details:<br>
>>> - Each node is a VM running CentOS 6.7, 64-bit<br>
>>> - Each node is running postgres 9.2.15 (latest version available),<br>
>>> installed via pgdg92 yum repository<br>
>>> - Each node is running pgpool-II-92 3.5.0-1 (latest version available),<br>
>>> installed via pgdg92 yum repository<br>
>>> - I can provide the pgpool or postgres configurations if need be, but<br>
>>> since they are lengthy, I will wait until they're requested.<br>
>>><br>
>>> Mike Neir<br>
>>> Infrastructure Administrator<br>
>>> Liquid Web, Inc.<br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> pgpool-general mailing list<br>
>>> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
>>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>>><br>
>>><br>
>><br>
</div></div></blockquote></div><br></div></div>