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

[Tatsuo Ishii]

> Hello all,
> 
> I use pgpool 4.2.5 on Centos 7 with Postgresql 13.
> I am setting up two nodes according to https://www.pgpool.net/docs/42/en/html/example-cluster.html
> I am at the section 8.2.9.1. Set up PostgreSQL standby server and here I have a problem with pcp_recovery_node.
> For example delegate IP is 192.168.8.139. I need recovery IP '192.168.8.137'
> 
> this is the command:
> pcp_recovery_node -h 192.168.8.139 -p 9898 -U pgpool -n 0 -d
> Password:
> DEBUG: recv: tos="m", len=8
> DEBUG: recv: tos="r", len=21
> DEBUG: send: tos="D", len=6
> DEBUG: recv: tos="E", len=130
> ERROR:  executing recovery, execution of command failed at "1st stage"
> DETAIL:  command:"recovery_1st_stage"
> 
> DEBUG: send: tos="X", len=4
> 
> and here is the log :
> 2021-11-04 10:04:38: pid 28665: LOG:  starting recovering node 0
> 2021-11-04 10:04:38: pid 28665: LOG:  executing recovery
> 2021-11-04 10:04:38: pid 28665: DETAIL:  starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage', '192.168.8.137', '/var/lib/pgsql/13/data', '5432', 0, '5432')"
> 2021-11-04 10:04:38: pid 28665: LOG:  executing recovery
> 2021-11-04 10:04:38: pid 28665: DETAIL:  disabling statement_timeout
> 2021-11-04 10:04:39: pid 28665: ERROR:  executing recovery, execution of command failed at "1st stage"
> 2021-11-04 10:04:39: pid 28665: DETAIL:  command:"recovery_1st_stage"
> 
> I tried run this from PGADMIN: SELECT pgpool_recovery('recovery_1st_stage', '192.168.8.137', '/var/lib/pgsql/13/data', '5432', 0, '5432')
> ERROR: pgpool_recovery failed
> SQL state: XX000
> 
> File recovery_1st_stage is located in /var/lib/pgsql/13/data  directory with permissions 0755 and group/owner postgres/postgres.
> What should be wrong? Could you help me?

To know what's wrong the PostgreSQL log on the primary node (perhaps
node 1?) is necessary. Can you share that?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp