Re: BUG #12598: pgpool 9.4 broken online recovery node - Mailing list pgsql-bugs

From Ромашкин Андрей
Subject Re: BUG #12598: pgpool 9.4 broken online recovery node
Date
Msg-id 54BD2B34.9080006@i-cb.ru
Whole thread Raw
In response to Re: BUG #12598: pgpool 9.4 broken online recovery node  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-bugs
Hi <br /><span class="ita-kd-inputtools-div"></span><div class="g-unit" id="gt-src-c"><div
id="gt-src-p"></div></div><divid="tts_button"><object data="//ssl.gstatic.com/translate/sound_player2.swf" height="18"
id="tts"type="application/x-shockwave-flash" width="18"></object></div><span class="" id="result_box" lang="en"><span
class="hps">I'm</span><span class="hps">very</span> <span class="hps">sorry, I</span> <span class="hps">discovered
that</span><span class="hps">the problem was</span> <span class="hps">CREATE EXTENSION</span><span
class="hps"></span><span>,</span><span class="hps">and</span> <span class="hps">it's my fault</span><span>,</span>
<spanclass="hps">did not see</span> <span class="hps">the error message</span> <span class="hps">creation</span> <span
class="hps">functions</span><span class="hps">pgpool_restore</span> <span class="hps">after</span> <span
class="hps">drop</span><span class="hps">functions and</span> <span class="hps">recall</span>  CREATE EXTENSION <span
class="hps">theproblem disappeared</span><span>.</span></span><span class="" id="result_box" lang="en"><span><br /><br
/></span></span><divclass="moz-cite-prefix">19.01.2015 18:04, Devrim Gündüz пишет:<br /></div><blockquote
cite="mid:1421679849.20060.2.camel@gunduz.org"type="cite"><pre wrap=""> 
Hi,

On Mon, 2015-01-19 at 10:30 +0000, <a class="moz-txt-link-abbreviated"
href="mailto:aromashkin@i-cb.ru">aromashkin@i-cb.ru</a>wrote: 

</pre><blockquote type="cite"><pre wrap="">in posgresql log
< 2015-01-19 13:27:25.786 MSK >ERROR:  function pgpool_recovery(iso-8859-1,
iso-8859-1, iso-8859-1, iso-8859-1) does not exist at character 8
</pre></blockquote><pre wrap="">
I think pgpool_recovery extension is missing.

CREATE EXTENSION pgpool_recovery;

should do the trick.

Regards,
</pre></blockquote><br /><pre class="moz-signature" cols="72">--
Ромашкин Андрей
e-mail: <a class="moz-txt-link-abbreviated" href="mailto:aromashkin@i-cb.ru">aromashkin@i-cb.ru</a>
icq 895560
mob +7 (926) 295-0336
ООО "Ай-Куб"</pre>

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #12571: Web site documentation error for make_timestamp
Next
From: Pedro Gimeno
Date:
Subject: Re: BUG #12589: Poor randomness from random() with some seeds; poor resolution