<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 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 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 href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a 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 href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a 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>