[pgpool-general: 8242] Re: pcp_recovery_node command fails

[Jon SCHEWE]

> I’m trying to use pcp_recovery_node for online recovery in a pgpool/postgresql-12 cluster.
> 
> My cluster has PostgreSQL 12.8 and pgpool 4.3.2 running on CentOS 7.9 linux.
> 
>  
> 
> I’ve tried so many things, I’ll not go into those details just yet. 
> 
>  
> 
> To start with, here is the output of the pcp_recovery_node command:
> 
>  
> 
> pcp_recovery_node -U postgres -h <VIP> -p 9898 -n 0
> 
> Password:
> 
> ERROR:  executing recovery, execution of command failed at "1st stage"
> 
> DETAIL:  command:"recovery_1st_stage"
> 

Do you see anything in your logs about the errors? Usually this is either on stdout from the service or in /var/log/pgpool...
I'm guessing that your recovery_1st_stage script either isn't defined or isn't doing what you expect.