[pgpool-general: 3751] recovery node not working

[juaruelo .]

Hi everyone, I have a problem that is stopping me. I have made the question
2 weeks ago but nobody helped me. Does anyone had my problem?

I have a problem trying to recover a node. If I run the
command pcp_recovery_node it fails as show:

[root at pgsql1 bin]# /usr/pgpool-9.3/bin/pcp_recovery_node -d pgsql1 9898
root r00t 1

DEBUG: send: tos="R", len=42

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

the postgres log show:

LOG:  sentencia: SELECT pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432')

ERROR:  no existe la función pgpool_recovery(unknown, unknown, unknown,
unknown) en carácter 8

HINT:  Ninguna función coincide en el nombre y tipos de argumentos. Puede
ser necesario agregar conversión explícita de tipos.

SENTENCIA:  SELECT pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432')



But If I run the query select.... it works fine:

CLC-Nut=# SELECT pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432');

 pgpool_recovery

-----------------

 t

(1 fila)


And the postgers log show:


LOG:  sentencia: SELECT pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432');

LOG:  sentencia: select pg_start_backup('pgpool-recovery')

 pg_start_backup

-----------------

 0/3B000028

(1 fila)



LOG:  ejecutar <unnamed>: SELECT gid FROM pg_prepared_xacts

LOG:  sentencia: select pg_stop_backup()

NOTICE:  pg_stop_backup completado, todos los segmentos de WAL requeridos
han sido archivados

 pg_stop_backup

----------------

 0/3B0000B8

(1 fila)


Does anyone know what is wrong?


Thanks

Juanma
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150525/6b16850f/attachment.html>