[pgpool-general: 7847] PGPOOL II - ERROR: executing recovery, execution of command failed at "1st stage"
Pavel Křehlík
krehlik at techsys.cz
Thu Nov 4 18:13:32 JST 2021
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>
More information about the pgpool-general
mailing list