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

[Pavel Křehlík]

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?

Thanks and regards
Pavel


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211104/c7ac33dc/attachment.htm>