[pgpool-general: 2769] Re: pcp_recovery_node pitr host key issues

[Jamie Koceniak]

Hi,

When pcp_recovery_node calls my basebackup.sh script, I get this error in my postgresql log when trying to rsync data from master node to down node:

Host key verification failed.^M
rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: unexplained error (code 255) at io.c(605) [sender=3.0.9]

Command I called:
$ pcp_recovery_node -d 600 localhost 9898 admin pw 0

DEBUG: send: tos="R", len=43
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

When I call basebackup.sh as postgres user, it runs fine.
I do have keys set up between both nodes.

from pgpool log:

Apr 17 00:52:00 node0 pgpool[2798]: starting recovering node 0
Apr 17 00:52:00 node0 pgpool[2798]: CHECKPOINT in the 1st stage done
Apr 17 00:52:00 node0 pgpool[2798]: starting recovery command: "SELECT pgpool_recovery('basebackup.sh', 'node0', '/d1/apps/postgresql/9.1/main')"

My config:
#------------------------------------------------------------------------------
# ONLINE RECOVERY
#------------------------------------------------------------------------------
recovery_user = 'postgres'
recovery_password = ''
recovery_1st_stage_command = 'basebackup.sh'
recovery_2nd_stage_command = 'pgpool_recovery_pitr.sh'
recovery_timeout = 600

Is pcp_recovery_node actually running under user=admin (which is in our pcp.conf file) or does it use recovery_user = postgres?
Why am I seeing permission issues?

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140417/8b5524b3/attachment.html>