[pgpool-general: 1921] Re: Basebackup failed

[Tatsuo Ishii]

Please take a look at [pgpool-general: 1917]. It discusses similar topic.
(just in case I attached the mail).

> Hello
> 
> 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.
> 
> In pgpool.log, I get:
> 
> 2013-07-23 01:53:14 LOG:   pid 32698: starting recovering node 1
> 2013-07-23 01:53:14 LOG:   pid 32698: CHECKPOINT in the 1st stage done
> 2013-07-23 01:53:14 LOG:   pid 32698: starting recovery command: "SELECT
> pgpool_recovery('basebackup.sh', '192.168.0.103', '/var/lib/pgsql')"
> 2013-07-23 01:53:14 ERROR: pid 32698: exec_recovery: basebackup.sh command
> failed at 1st stage
> 
> 
> 
> If I run my script by hand with:
> 
>  ./basebackup.sh /var/lib/pgsql/data 192.168.0.103 /var/lib/pgsql
> 
> 
> It works fine.
> 
> Here is the state of my two nodes:
> 
>  psql -p 5431 -h 192.168.0.109 -c "show pool_nodes;" -U postgres
>  node_id |   hostname    | port | status | lb_weight |  role
> ---------+---------------+------+--------+-----------+--------
>  0       | 192.168.0.102 | 5432 | 2      | 0.500000  | master
>  1       | 192.168.0.103 | 5432 | 3      | 0.500000  | slave
> (2 rows)
> 
> 
> 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.
> 
> Where should the basebackup.sh script be located on disk?

It should be on PostgreSQL's database cluster directory
(/usr/local/pgsql/data etc.).

> How do I tell
> which path pgpool is using to run it? The log does not mention where it is
> trying to find it.
> 
> Thank you!
> 
> Gilbert
-------------- next part --------------
An embedded message was scrubbed...
From: Tatsuo Ishii <ishii at postgresql.org>
Subject: [pgpool-general: 1917] Re: pcp_recovery_node fails BackendError
Date: Tue, 23 Jul 2013 09:36:55 +0900 (JST)
Size: 5941
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130723/e5524eff/attachment.mht>