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

[juaruelo .]

Thanks for your answer Alexandru.

I think I have pgpool_recovery. It exists in the public schema in all DB. I
created as:

CREATE OR REPLACE FUNCTION pgpool_recovery(script_name text, remote_host
text, remote_data_directory text, remote_port text)
  RETURNS boolean AS
'/usr/pgsql-9.3/lib/pgpool-recovery.so', 'pgpool_recovery'
  LANGUAGE c VOLATILE STRICT
  COST 1;
ALTER FUNCTION pgpool_recovery(text, text, text, text)
  OWNER TO postgres;




2015-05-25 22:56 GMT+02:00 Alexandru Cardaniuc <cardaniuc at gmail.com>:

>
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150526/1c99af1a/attachment.html>