<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Damn it.. I cannot even downgrade to the old version because it seems it is no more available in the repository (<a href="https://apt.postgresql.org/pub/repos/apt/pool/main/p/pgpool2/" class="">https://apt.postgresql.org/pub/repos/apt/pool/main/p/pgpool2/</a>)<div class=""><br class=""></div><div class="">Is there a reason why only RedHat is available on your site and Ubuntu/Debian packages are provided that worse?</div><div class=""><div class="">
<br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class=""><a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a><br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class="">http://www.claranet.de<br class=""><br class=""><br class=""><br class="">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 27. Feb 2018, at 16:50, Mathias Buresch <<a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Ah ok.. Probably this is only working with building from source?? I have Ubuntu and working with the Debian packages.<br class=""><div class="">
<br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class=""><a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a><br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class=""><a href="http://www.claranet.de" class="">http://www.claranet.de</a><br class=""><br class=""><br class=""><br class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On 27. Feb 2018, at 16:47, Mathias Buresch <<a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">How to install the patch? It is not really working with “patch <patchfile>”.<div class=""><br class=""></div><div class=""><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04</a></div><div class="">This is the content of the patch file, correct?<br class=""><div class="">
<br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class=""><a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a><br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class=""><a href="http://www.claranet.de/" class="">http://www.claranet.de</a><br class=""><br class=""><br class=""><br class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On 27. Feb 2018, at 16:08, Mathias Buresch <<a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">In the moment I am trying to reproduce on another system and if the patch is gonna working. But already the failover did not work when updating only one node. Both postgresql are shown as standby.. none was set to master - this was working before.<br class="">A question to that and just nice to know - do you provide failover and whatever scripts? Because I have script for failover and promote and so on out of other websites because I didnt found any good script.<br class=""><br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class=""><a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a><br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class=""><a href="http://www.claranet.de/" class="">http://www.claranet.de</a><br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">On 27. Feb 2018, at 15:20, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" class="">ishii@sraoss.co.jp</a>> wrote:<br class=""><br class="">No. Only 3.7.2 is affected by [1] since it tried to fix a problem<br class="">related to "ALWAYS_MASTER" which is new in 3.7.0.<br class=""><br class="">Best regards,<br class="">--<br class="">Tatsuo Ishii<br class="">SRA OSS, Inc. Japan<br class="">English: <a href="http://www.sraoss.co.jp/index_en.php" class="">http://www.sraoss.co.jp/index_en.php</a><br class="">Japanese:<a href="http://www.sraoss.co.jp" class="">http://www.sraoss.co.jp</a><br class=""><br class=""><blockquote type="cite" class="">Will 3.6.9 and the other releases also have the same issue then or is this just a 3.7.2 problem?<br class=""><br class=""><blockquote type="cite" class="">On Feb 27, 2018, at 7:45 AM, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" class="">ishii@sraoss.co.jp</a>> wrote:<br class=""><br class="">Not decided yet. I need to find a way to solve the original problem<br class="">which was supposed to be solved by [1].<br class=""><br class="">Best regards,<br class="">--<br class="">Tatsuo Ishii<br class="">SRA OSS, Inc. Japan<br class="">English: <a href="http://www.sraoss.co.jp/index_en.php" class="">http://www.sraoss.co.jp/index_en.php</a><br class="">Japanese:<a href="http://www.sraoss.co.jp" class="">http://www.sraoss.co.jp</a><br class=""><br class=""><blockquote type="cite" class="">Target date for 3.7.3?<br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">On Feb 27, 2018, at 7:26 AM, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" class="">ishii@sraoss.co.jp</a>> wrote:<br class=""><br class="">Today I have just found a serious regression in 3.7.2: it does not<br class="">work if the primary is other than node 0, sending write queries to<br class="">node 0, which is the standby (In my testing, 3.7.2 does work if the<br class="">primary is node 0). I guess your primary is not node 0, right?<br class=""><br class="">The cause was this commit [1]:<br class=""><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d" class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d</a><br class=""><br class="">So I today reverted the commit [2]:<br class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04<br class=""><br class="">Until 3.7.3 is released, you could:<br class=""><br class="">1) Let node 0 to be the primary<br class=""><br class="">2) down grade to 3.7.1<br class=""><br class="">3) Apply the patch [2] to 3.7.2.<br class=""><br class="">Sorry for the inconvenience.<br class="">--<br class="">Tatsuo Ishii<br class="">SRA OSS, Inc. Japan<br class="">English: http://www.sraoss.co.jp/index_en.php<br class="">Japanese:http://www.sraoss.co.jp<br class=""><br class=""><blockquote type="cite" class="">Hello,<br class=""><br class="">after updating the PgPool from 3.6.8 to 3.7.2 is is not working anymore.<br class="">The “show pool_nodes” is showing the primary and standby correctly but it sends “Update” and “Select update” and others to standby. The workaround now is that we have disabled the standby-Postgresql.<br class=""><br class="">Probably we will downgrade to the old version and check again.<br class="">In parallel I try to find out what the Release Notes are telling about that. Maybe you can tell me how I can debug and find out what is happening there??<br class=""><br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class="">mathias.buresch@de.clara.net<br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class="">http://www.claranet.de<br class=""><br class=""><br class=""><br class=""><br class=""></blockquote>_______________________________________________<br class="">pgpool-general mailing list<br class="">pgpool-general@pgpool.net<br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></blockquote></blockquote></blockquote></blockquote></blockquote><br class="">_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a><br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></div></div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div>_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a><br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></div></blockquote></div><br class=""></div></body></html>