<div dir="ltr">Thank you very much. That would be helpful.<div><br></div><div>Regards,</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Mar 6, 2016 at 1:17 AM, Lucas Luengas <span dir="ltr"><<a href="mailto:lucasluengas@gmail.com" target="_blank">lucasluengas@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div>Hello.<br><br><span style="font-size:12.8px">Your question: What will be the state </span><span style="font-size:12.8px">of the existing application connections ? <br></span></div><div><span style="font-size:12.8px">My answer: Existing application connections will be closed/disconnected.<br></span></div><div><span style="font-size:12.8px"><br>Your question: will they be taken over by the </span><span style="font-size:12.8px">second pgpool-II server and the Queries continue to run as it is ?<br></span></div><div><span style="font-size:12.8px">Existing application connections will not be taken over by the second server. <br></span></div><div><span style="font-size:12.8px">New connections will be connect to second server.<br></span></div><div><br></div>Your question: <span style="font-size:12.8px"> If i have a SELECT query currently running and the active pgpool-II </span><span style="font-size:12.8px">server fails, will the SELECT query continue to run without interruption </span><span style="font-size:12.8px">from the second pgpool-II server ?<br></span></div><span style="font-size:12.8px">My answer: The query currently running are disconnected. After a few seconds, the next queries (your application connections) connect to second pgpool-II server.<br><br></span></div><span style="font-size:12.8px">Your question: </span><span style="font-size:12.8px"><span style="font-size:12.8px">or it had to be re-executed again ?</span><br></span></div><span style="font-size:12.8px"><span style="font-size:12.8px">My answer: </span>Yes. If you want the SELECT, you must re-execute the SELECT again.<br><br></span></div><span style="font-size:12.8px">Regards.<br><br></span><div><span style="font-size:12.8px"><br><br></span><div><div><div><div><span style="font-size:12.8px"><br><br></span></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Sat, Mar 5, 2016 at 10:45 AM, Venkata Balaji N <span dir="ltr"><<a href="mailto:nag1010@gmail.com" target="_blank">nag1010@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><span style="font-size:12.8px">I have a PostgreSQL clusters (master and standby) configured with Streaming</span><span style="font-size:12.8px"> Replication, we are looking at setting up a pgpool-II with watchdog for </span><span style="font-size:12.8px">connection pooling and failover purposes we would also need to ensure there </span><span style="font-size:12.8px">is no single-point-of-failure threat to pgpool-II.</span><br style="font-size:12.8px"><span style="font-size:12.8px"><br></span><div><span style="font-size:12.8px">My query is -</span><br style="font-size:12.8px"><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">If i have pgpool-II configured with watchdog and if the active pgpool-II </span><span style="font-size:12.8px">crashes, then, my understanding is that all the application connections</span><span style="font-size:12.8px"> will be failed-over to the second pgpool-II server. What will be the state </span><span style="font-size:12.8px">of the existing application connections ? will they be taken over by the </span><span style="font-size:12.8px">second pgpool-II server and the Queries continue to run as it is ?</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Eg: If i have a SELECT query currently running and the active pgpool-II </span><span style="font-size:12.8px">server fails, will the SELECT query continue to run without interruption </span><span style="font-size:12.8px">from the second pgpool-II server ? or it had to be re-executed again ?</span><br style="font-size:12.8px"><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Please help !</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Regards,</span><br style="font-size:12.8px"><span style="font-size:12.8px">Venkata B N</span><br></div></div>
<br></div></div>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">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></blockquote></div><br></div>
</blockquote></div><br></div>