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

[Janusz Borkowski]

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.

J.

On 26.05.2015 12:20, juaruelo . wrote:
> 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 <mailto:cardaniuc at gmail.com>>:
>
>
>     Do you have pgpool_recovery loaded?
>
>     "juaruelo ." <jmruedal at gmail.com <mailto: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 <mailto: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 <mailto:pgpool-general at pgpool.net>
>     http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150526/39afbf6d/attachment.htm>