[pgpool-general: 1571] Re: Online Recovery failed with unknown reason

[ninchan8328]

Hi Kong
Thanks for your advice but that didn't help as the remote server is already known by the local host.  And the localhost can log on to the remote host without password.

Thanks 
Ning


Sent via the Samsung Galaxy Note® II, an AT&T 4G LTE smartphone

-------- Original message --------
From: Kong Man <kong_mansatiansin at hotmail.com> 
Date: 04/03/2013  1:45 PM  (GMT-06:00) 
To: pgpool-general at pgpool.net 
Subject: [pgpool-general: 1567] Re: Online Recovery failed with unknown reason 
 
I agreed that the debug mode does not help at all.  The problem could be due to various reasons.  One gotcha I had was, despite a well-established password-less SSH setup, if you haven't made the hostname/IP recognized as a known host, SSH would prompt and pgpool_recovery simply gives out 'ERROR: pgpool_recovery failed' wihtout any additional message.

Try 'ssh se032c-94-31' and see if you get a prompt like the following.  If so, simply answer yes to get the symbolic name on the ~/.ssh/known_hosts file and try your pgpool_recovery one more time.

I hope this leads you to something, if it does not directly address your issue.

Thanks,
-Kong

The authenticity of host '10.89.94.31 (10.89.94.31)' can't be established.
RSA key fingerprint is ....
Are you sure you want to continue connecting (yes/no)? 

> template1=# SELECT pgpool_recovery('basebackup.sh', 'se032c-94-31',
> '/opt/postgres/9.2/data');
> ERROR: pgpool_recovery failed
> template1=# SELECT pgpool_recovery('basebackup.sh', '10.89.94.31',
> '/opt/postgres/9.2/data');
> pgpool_recovery
> -----------------
> t
> (1 row)
> 
> 
> If hostname is used, the command will failed, but IP works fine.
> 
> I double check the hostname is pingable from localhost.
> 
> [root at se032c-94-30 ~]# ping se032c-94-31
> PING se032c-94-31.cisco.com (10.89.94.31) 56(84) bytes of data.
> 64 bytes from se032c-94-31.abc.com (10.89.94.31): icmp_seq=1 ttl=64
> time=0.254 ms
> 64 bytes from se032c-94-31.abc.com (10.89.94.31): icmp_seq=2 ttl=64
> time=0.311 ms


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130404/a713454b/attachment.html>