Thread: BUG #12598: pgpool 9.4 broken online recovery node
The following bug has been logged on the website: Bug reference: 12598 Logged by: Andrey Romashkin Email address: aromashkin@i-cb.ru PostgreSQL version: 9.4.0 Operating system: Centos 7 Description: After upgrage pgpool to 9.4 with postgresql and on clean installation. if start recoveru failed node /usr/pgpool-9.4/bin/pcp_recovery_node -d 60 localhost 9898 user pass 1 DEBUG: send: tos="R", len=46 DEBUG: recv: tos="r", len=21, data=AuthenticationOK DEBUG: send: tos="D", len=6 DEBUG: recv: tos="e", len=20, data=recovery failed DEBUG: command failed. reason=recovery failed BackendError DEBUG: send: tos="X", len=4 in posgresql log < 2015-01-19 13:27:25.786 MSK >ERROR: function pgpool_recovery(unknown, unknown, unknown, unknown) does not exist at character 8 < 2015-01-19 13:27:25.786 MSK >HINT: No function matches the given name and argument types. You might need to add explicit type casts. < 2015-01-19 13:27:25.786 MSK >STATEMENT: SELECT pgpool_recovery('recoveryst1', 'db-node2', '/var/lib/pgsql/9.4/data', '5432') pgpool installed from yum.postgresql.org
Hi, On Mon, 2015-01-19 at 10:30 +0000, aromashkin@i-cb.ru wrote: > 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 I think pgpool_recovery extension is missing. CREATE EXTENSION pgpool_recovery; should do the trick. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
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>