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

Yugo Nagata nagata at sraoss.co.jp
Fri Apr 18 17:25:05 JST 2014


Hi,

On Thu, 17 Apr 2014 01:25:05 +0000
Jamie Koceniak <jkoceniak at mediamath.com> wrote:

> 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?

basebackup.sh is run unser the user who executes PostgreSQL server. 
Please confirm that backends are running unser postgres user and that
postgres at backend1 can ssh to postgres at backend2 without password.

> 
> Thanks!


-- 
Yugo Nagata <nagata at sraoss.co.jp>


More information about the pgpool-general mailing list