[pgpool-general: 8242] Re: pcp_recovery_node command fails
Jon SCHEWE
jon.schewe at raytheon.com
Fri Jun 24 04:34:15 JST 2022
> 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.
More information about the pgpool-general
mailing list