<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Oh, I see...:)</span><div style="font-family:arial,sans-serif;font-size:13px">Thank you for your comment Tatsuo.</div><div style="font-family:arial,sans-serif;font-size:13px">
Wouldn't it be better that this behavior will be configurable via the conf file?</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Thank you.</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 18, 2014 at 12:43 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"><div class="HOEnZb"><div class="h5">> Hey :)<br>
> I have pgpool with 2 backends, master/slave streaming replication mode.<br>
> When I stop the service on the slave, the node is deattched correctly and<br>
> all child processes are restarted to update thier backends connections [<br>
> when i run show pool_pools I can see that every pool_pid was changed and<br>
> all pools are connected to one backend, the master ].<br>
> However,<br>
> when I start the service again on the failed standby, and run the<br>
> pcp_attach_node command, the child processes are not restarted, thus, all<br>
> connections that were open before the failback, are remain open and<br>
> connected only to the master, until a pgpool restart is invoked and then,<br>
> all the pools connections are connected to both backends. I need to mention<br>
> that every *new* session to the pgpool after the attache, is connected to<br>
> both backends.<br>
><br>
> My question is, why after pcp_attach_node command, the child processes are<br>
> not restarted as they should, like they do after failover.<br>
><br>
> Thank you very much!<br>
<br>
</div></div>Actually pgpool-II behaved as you wish before. However lots of users<br>
complained that already connected sessions were disconnected when<br>
standby nodes were re-attached. Thus I fixed things as users<br>
requested.<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" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br></div>