[pgpool-general: 7385] Re: ERROR: executing recovery, execution of command failed at "1st stage"

[Bo Peng]

Hi,

On Tue, 5 Jan 2021 18:02:26 +0300
Murat K <srvrmurat at gmail.com> wrote:

> Hi All,
> 
> I am implementing Pgpool-II + Watchdog Setup Example
> <https://www.pgpool.net/docs/42/en/html/example-cluster.html> . I managed
> to install pgpool 4.2.1  and run but having problems with online recovery
> (pcp_recovery_node) and switchover/failover scenarios.
> 
> # pcp_recovery_node -h vip.vip.vip.vip -p 9898 -U pgpool -n 1
> Password:
> ERROR:  executing recovery, execution of command failed at "1st stage"
> DETAIL:  command:"recovery_1st_stage"
> 
> I reviewed failover, follow primary, recovery_1st_stage scripts but could
> not make it work.
> Can somebody shed some light?

Did you execute "CREATE EXTENSION ..." following this section?

https://www.pgpool.net/docs/42/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-ONLINE-RECOVERY

If you could share the pgpool log, I may figure out the cause.

> Regards,
> murat


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan