<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>I had the exact same problem and found that postgresql apt
repository only holds the most recent versions of packages. But
fortunately, they maintain a "morgue" containing previous
releases: <a class="moz-txt-link-freetext" href="http://atalia.postgresql.org/morgue/p/pgpool2/">http://atalia.postgresql.org/morgue/p/pgpool2/</a> (found it
through the APT postgresql FAQ - really hard to find IMO)<br>
</p>
<p>This just saved me last week ;)</p>
<p>Thomas<br>
</p>
<br>
<div class="moz-cite-prefix">On 27/02/2018 17:34, Mathias Buresch
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:732D726B-F413-4319-BE47-86BA218809E4@de.clara.net">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
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="" moz-do-not-send="true">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=""
moz-do-not-send="true">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 class="moz-txt-link-freetext" href="http://www.claranet.de">http://www.claranet.de</a><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=""
moz-do-not-send="true">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=""
moz-do-not-send="true">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=""
moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">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=""
moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">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="" moz-do-not-send="true">http://www.sraoss.co.jp/index_en.php</a><br
class="">
Japanese:<a
href="http://www.sraoss.co.jp"
class="" moz-do-not-send="true">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=""
moz-do-not-send="true">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=""
moz-do-not-send="true">http://www.sraoss.co.jp/index_en.php</a><br
class="">
Japanese:<a
href="http://www.sraoss.co.jp"
class=""
moz-do-not-send="true">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="" moz-do-not-send="true">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=""
moz-do-not-send="true">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="">
<a class="moz-txt-link-freetext" href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04</a><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:
<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br
class="">
Japanese:<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><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="">
<a class="moz-txt-link-abbreviated" href="mailto:mathias.buresch@de.clara.net">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 class="moz-txt-link-freetext" href="http://www.claranet.de">http://www.claranet.de</a><br
class="">
<br class="">
<br class="">
<br class="">
<br class="">
</blockquote>
_______________________________________________<br class="">
pgpool-general mailing list<br
class="">
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br
class="">
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><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="" moz-do-not-send="true">pgpool-general@pgpool.net</a><br
class="">
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><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=""
moz-do-not-send="true">pgpool-general@pgpool.net</a><br
class="">
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br
class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a></pre>
</blockquote>
<br>
</body>
</html>