<div dir="ltr">Hello I have a problem trying to recover a node. If I run the command pcp_recovery_node it fails as show:<div><br></div><div><p class="MsoNormal"><span lang="EN-US">[root@pgsql1
bin]# /usr/pgpool-9.3/bin/pcp_recovery_node -d pgsql1 9898 root r00t 1</span></p>
<p class="MsoNormal"><span lang="EN-US">DEBUG:
send: tos="R", len=42</span></p>
<p class="MsoNormal"><span lang="EN-US">DEBUG:
recv: tos="r", len=21, data=AuthenticationOK</span></p>
<p class="MsoNormal"><span lang="EN-US">DEBUG:
send: tos="D", len=6</span></p>
<p class="MsoNormal"><span lang="EN-US">DEBUG:
recv: tos="e", len=20, data=recovery failed</span></p>
<p class="MsoNormal"><span lang="EN-US">DEBUG:
command failed. reason=recovery failed</span></p>
<p class="MsoNormal">BackendError</p>
<span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif">DEBUG: send: tos="X", len=4</span><br></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><br></span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif">the postgres log show:</span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><br></span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><p class="MsoNormal"><span lang="EN-US">LOG:
sentencia: SELECT pgpool_recovery('base-backup', 'pgsql2',
'/var/lib/pgsql/9.3/data', '5432')</span></p>
<p class="MsoNormal">ERROR: no existe la función pgpool_recovery(unknown,
unknown, unknown, unknown) en carácter 8</p>
<p class="MsoNormal">HINT: Ninguna función coincide en el nombre y tipos
de argumentos. <span lang="EN-US">Puede ser
necesario agregar conversión explícita de tipos.</span></p>
<p class="MsoNormal"><span lang="EN-US">SENTENCIA:
SELECT pgpool_recovery('base-backup', 'pgsql2', '/var/lib/pgsql/9.3/data',
'5432')</span></p></span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><br></span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><br></span></div><div><br></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif">But If I run the query select.... it works fine:</span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><br></span></div><div><span lang="EN-US" style="font-size:11pt;line-height:115%;font-family:Calibri,sans-serif"><p class="MsoNormal"><span lang="EN-US">CLC-Nut=#
SELECT pgpool_recovery('base-backup', 'pgsql2', '/var/lib/pgsql/9.3/data',
'5432');</span></p>
<p class="MsoNormal"><span lang="EN-US"> pgpool_recovery</span></p>
<p class="MsoNormal"><span lang="EN-US">-----------------</span></p>
<p class="MsoNormal"><span lang="EN-US"> t</span></p>
<p class="MsoNormal"><span lang="EN-US">(1 fila)</span></p><p class="MsoNormal"><span lang="EN-US"><br></span></p><p class="MsoNormal"><span lang="EN-US">And the postgers log show:</span></p><p class="MsoNormal"><span lang="EN-US"><br></span></p><p class="MsoNormal"><span lang="EN-US">LOG: sentencia: SELECT
pgpool_recovery('base-backup', 'pgsql2', '/var/lib/pgsql/9.3/data', '5432');</span></p><p class="MsoNormal"><span lang="EN-US">LOG: sentencia: select
pg_start_backup('pgpool-recovery')</span></p><p class="MsoNormal"><span lang="EN-US"> pg_start_backup</span></p><p class="MsoNormal"><span lang="EN-US">-----------------</span></p><p class="MsoNormal"><span lang="EN-US"> 0/3B000028</span></p><p class="MsoNormal"><span lang="EN-US">(1 fila)</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">LOG: ejecutar <unnamed>: SELECT gid FROM
pg_prepared_xacts</span></p><p class="MsoNormal"><span lang="EN-US">LOG: sentencia: select pg_stop_backup()</span></p><p class="MsoNormal"><span lang="EN-US">NOTICE: pg_stop_backup completado, todos los
segmentos de WAL requeridos han sido archivados</span></p><p class="MsoNormal"><span lang="EN-US"> pg_stop_backup</span></p><p class="MsoNormal"><span lang="EN-US">----------------</span></p><p class="MsoNormal"><span lang="EN-US"> 0/3B0000B8</span></p><p class="MsoNormal"><span lang="EN-US">
</span></p><p class="MsoNormal"><span lang="EN-US">(1 fila)</span></p><p class="MsoNormal"><span lang="EN-US"><br></span></p><p class="MsoNormal"><span lang="EN-US">Does anyone know what is wrong?</span></p><p class="MsoNormal"><span lang="EN-US"><br></span></p><p class="MsoNormal"><span lang="EN-US">Thanks</span></p><p class="MsoNormal"><span lang="EN-US">Juanma</span></p></span></div></div>