<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="">I know :) Just wondered why only RedHat is on your <a href="http://pgpool.net" class="">pgpool.net</a> site.<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="">http://www.claranet.de<br class=""><br class=""><br class=""><br class="">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 28. Feb 2018, at 00:17, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" class="">ishii@sraoss.co.jp</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Sorry but I am not the maintainer of <a href="http://apt.postgresql.org" class="">apt.postgresql.org</a> and I cannot<br class="">speak of their support policy.<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="">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> <<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>>)<br class=""><br class="">Is there a reason why only RedHat is available on your site and Ubuntu/Debian packages are provided that worse?<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="">http://www.claranet.de<br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">On 27. Feb 2018, at 16:50, Mathias Buresch <mathias.buresch@de.clara.net> wrote:<br class=""><br class="">Ah ok.. Probably this is only working with building from source?? I have Ubuntu and working with the Debian packages.<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 <mailto: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 type="cite" class="">On 27. Feb 2018, at 16:47, Mathias Buresch <mathias.buresch@de.clara.net <mailto:mathias.buresch@de.clara.net>> wrote:<br class=""><br class="">How to install the patch? It is not really working with “patch <patchfile>”.<br class=""><br class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04 <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04><br class="">This is the content of the patch file, correct?<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 <mailto: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 <http://www.claranet.de/><br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">On 27. Feb 2018, at 16:08, Mathias Buresch <mathias.buresch@de.clara.net <mailto:mathias.buresch@de.clara.net>> wrote:<br class=""><br 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="">mathias.buresch@de.clara.net <mailto: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 <http://www.claranet.de/><br class=""><br class=""><br class=""><br class=""><br class=""><blockquote type="cite" class="">On 27. Feb 2018, at 15:20, Tatsuo Ishii <ishii@sraoss.co.jp> 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: http://www.sraoss.co.jp/index_en.php<br class="">Japanese:http://www.sraoss.co.jp<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 <ishii@sraoss.co.jp> 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: http://www.sraoss.co.jp/index_en.php<br class="">Japanese:http://www.sraoss.co.jp<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 <ishii@sraoss.co.jp> 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="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d<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="">pgpool-general@pgpool.net<br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></blockquote><br class=""></blockquote><br class="">_______________________________________________<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><br class=""></blockquote></div></div></blockquote></div><br class=""></body></html>