[pgpool-general: 3752] Re: recovery node not working

[Alexandru Cardaniuc]

Do you have pgpool_recovery loaded?

"juaruelo ." <jmruedal at gmail.com> writes:

> 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
>
> _______________________________________________ pgpool-general mailing
> list pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-- 
"Never let school interfere with your education."
- Mark Twain