Hello<div><br></div><div>When I try to run a node recovery (ex: /usr/local/bin/pcp_recovery_node -d 100 192.168.0.109 9898 pgpool pgpool 1), I get an error.</div><div><br></div><div>In pgpool.log, I get:</div><div><br></div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div><font face="courier new, monospace">2013-07-23 01:53:14 LOG: pid 32698: starting recovering node 1</font></div></div><div><div><font face="courier new, monospace">2013-07-23 01:53:14 LOG: pid 32698: CHECKPOINT in the 1st stage done</font></div>
</div><div><div><font face="courier new, monospace">2013-07-23 01:53:14 LOG: pid 32698: starting recovery command: "SELECT pgpool_recovery('basebackup.sh', '192.168.0.103', '/var/lib/pgsql')"</font></div>
</div><div><div><font face="courier new, monospace">2013-07-23 01:53:14 ERROR: pid 32698: exec_recovery: basebackup.sh command failed at 1st stage</font></div></div></blockquote><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div><div><br></div></div></blockquote><div>If I run my script by hand with:</div><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><font face="courier new, monospace"> ./basebackup.sh /var/lib/pgsql/data 192.168.0.103 /var/lib/pgsql</font></div>
</blockquote><div><br></div><div>It works fine.</div><div><br></div><div>Here is the state of my two nodes:</div><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div><font face="courier new, monospace"> psql -p 5431 -h 192.168.0.109 -c "show pool_nodes;" -U postgres</font></div>
</div><div><div><font face="courier new, monospace"> node_id | hostname | port | status | lb_weight | role</font></div></div><div><div><font face="courier new, monospace">---------+---------------+------+--------+-----------+--------</font></div>
</div><div><div><font face="courier new, monospace"> 0 | 192.168.0.102 | 5432 | 2 | 0.500000 | master</font></div></div><div><div><font face="courier new, monospace"> 1 | 192.168.0.103 | 5432 | 3 | 0.500000 | slave</font></div>
</div><div><div><font face="courier new, monospace">(2 rows)</font></div></div></blockquote><div><br></div><div>I have put added logging in my basebackup.sh script so I am pretty sure that it does not even get called by pgpool during recovery. I suspect a path/permissions issue.</div>
<div><br></div><div>Where should the basebackup.sh script be located on disk? How do I tell which path pgpool is using to run it? The log does not mention where it is trying to find it.</div><div><br></div><div>Thank you!</div>
<div><br></div><div>Gilbert</div>