<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Possibly the pcp command contacts
through pgpool to a postgres instance which has not installed
pgpool_recovery. I assume you have a few postgres instances -
maybe they differ in this aspect.<br>
<br>
J. <br>
<br>
On 26.05.2015 12:20, juaruelo . wrote:<br>
</div>
<blockquote
cite="mid:CAOrc-qOCM8FAEQNV4ggyY=78YN+3LwfHHv7cxkYSe5Rp8=JSTw@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks for your answer Alexandru.
<div><br>
</div>
<div>I think I have pgpool_recovery. It exists in the public
schema in all DB. I created as:</div>
<div><br>
</div>
<div>
<div>CREATE OR REPLACE FUNCTION pgpool_recovery(script_name
text, remote_host text, remote_data_directory text,
remote_port text)</div>
<div> RETURNS boolean AS</div>
<div>'/usr/pgsql-9.3/lib/pgpool-recovery.so',
'pgpool_recovery'</div>
<div> LANGUAGE c VOLATILE STRICT</div>
<div> COST 1;</div>
<div>ALTER FUNCTION pgpool_recovery(text, text, text, text)</div>
<div> OWNER TO postgres;</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-05-25 22:56 GMT+02:00 Alexandru
Cardaniuc <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:cardaniuc@gmail.com" target="_blank">cardaniuc@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
Do you have pgpool_recovery loaded?<br>
<div>
<div class="h5"><br>
"juaruelo ." <<a moz-do-not-send="true"
href="mailto:jmruedal@gmail.com">jmruedal@gmail.com</a>>
writes:<br>
<br>
> Hi everyone, I have a problem that is stopping me.
I have made the question 2 weeks ago but nobody helped
me.<br>
> Does anyone had my problem?<br>
><br>
> I have a problem trying to recover a node. If I run
the command pcp_recovery_node it fails as show:<br>
><br>
> [root@pgsql1 bin]#
/usr/pgpool-9.3/bin/pcp_recovery_node -d pgsql1 9898
root r00t 1<br>
><br>
> DEBUG: send: tos="R", len=42<br>
><br>
> DEBUG: recv: tos="r", len=21, data=AuthenticationOK<br>
><br>
> DEBUG: send: tos="D", len=6<br>
><br>
> DEBUG: recv: tos="e", len=20, data=recovery failed<br>
><br>
> DEBUG: command failed. reason=recovery failed<br>
><br>
> BackendError<br>
><br>
> DEBUG: send: tos="X", len=4<br>
><br>
> the postgres log show:<br>
><br>
> LOG: sentencia: SELECT
pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432')<br>
><br>
> ERROR: no existe la función
pgpool_recovery(unknown, unknown, unknown, unknown) en
carácter 8<br>
><br>
> HINT: Ninguna función coincide en el nombre y
tipos de argumentos. Puede ser necesario agregar
conversión<br>
> explícita de tipos.<br>
><br>
> SENTENCIA: SELECT pgpool_recovery('base-backup',
'pgsql2', '/var/lib/pgsql/9.3/data', '5432')<br>
><br>
> But If I run the query select.... it works fine:<br>
><br>
> CLC-Nut=# SELECT pgpool_recovery('base-backup',
'pgsql2', '/var/lib/pgsql/9.3/data', '5432');<br>
><br>
> pgpool_recovery<br>
><br>
> -----------------<br>
><br>
> t<br>
><br>
> (1 fila)<br>
><br>
> And the postgers log show:<br>
><br>
> LOG: sentencia: SELECT
pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432');<br>
><br>
> LOG: sentencia: select
pg_start_backup('pgpool-recovery')<br>
><br>
> pg_start_backup<br>
><br>
> -----------------<br>
><br>
> 0/3B000028<br>
><br>
> (1 fila)<br>
><br>
> <br>
><br>
> LOG: ejecutar <unnamed>: SELECT gid FROM
pg_prepared_xacts<br>
><br>
> LOG: sentencia: select pg_stop_backup()<br>
><br>
> NOTICE: pg_stop_backup completado, todos los
segmentos de WAL requeridos han sido archivados<br>
><br>
> pg_stop_backup<br>
><br>
> ----------------<br>
><br>
> 0/3B0000B8<br>
><br>
> (1 fila)<br>
><br>
> Does anyone know what is wrong?<br>
><br>
> Thanks<br>
><br>
> Juanma<br>
><br>
</div>
</div>
> _______________________________________________
pgpool-general mailing<br>
> list <a moz-do-not-send="true"
href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a moz-do-not-send="true"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
"Never let school interfere with your education."<br>
- Mark Twain<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a moz-do-not-send="true"
href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a moz-do-not-send="true"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</font></span></blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>