<div dir="ltr"><div><div>Hi,<br></div><div><br></div><div>I had version 4.0.x working fine and tried to upgrade to version 4.1.2</div><div>Now I cannot run the online recovery and I cannot figure out why.</div><div>Here is my configs:<br></div><div><br></div>pgpool.conf:<br><br> recovery_user = 'postgres'<br> # Online recovery user<br> recovery_password = ''<br> # Online recovery password<br><br> recovery_1st_stage_command = 'recovery_1st_stage'<br><div><br></div><div>(like the documentation example)<br></div>[node1]# su - postgres<br>[node1]$ vi /var/lib/pgsql/data/recovery_1st_stage<br>[node1]$ vi /var/lib/pgsql/data/pgpool_remote_start<br>[node1]$ chmod +x /var/lib/pgsql/data/{recovery_1st_stage,pgpool_remote_start}<br><div><br></div><div>#I'm using custom folder instead of
/var/lib/pgsql/data
/11/data<br></div>-bash-4.2$ echo $PGDATA<br>/var/lib/pgsql/data<br><div><br></div><div>#file is present and with proper permissions<br></div>-bash-4.2$ ll | grep recovery_1st_stage<br>-rwxr-xr-x 1 postgres postgres 2708 May 26 12:54 recovery_1st_stage<br><div><br></div><div>#extension is also there:<br></div>-bash-4.2$ psql template1 -c "CREATE EXTENSION pgpool_recovery"<br>ERROR: extension "pgpool_recovery" already exists<br></div><div><br></div><div>#
.pgpoolkey is on postgres home folder<br></div><div>-bash-4.2$ pwd<br>/var/lib/pgsql<br>-bash-4.2$ ll -a | grep .pgpoolkey<br>-rw------- 1 postgres postgres 15 May 27 17:13 .pgpoolkey</div><div><br></div><div>#
pool_passwd has the correct credentials<br></div><div>[root@node1 pgpool-II]# cat pool_passwd<br>pgpool:AES8G1vPLHVO8dPOJrWMfl5BQ==<br>postgres:AES+LJaYEZCYYD3X2eQw8++yQ==</div><div><br></div><div><br>then executing:<br><br>pcp_recovery_node -w -h 10.3.84.4 -p 9898 -U pgpool -n 1<br><br></div>gives this output in the log<br><div><br>2020-05-27 18:48:12: pid 6478: LOG: starting recovering node 1<br>2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>2020-05-27 18:48:12: pid 6478: DETAIL: starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage', 'node-02', '/var/lib/pgsql/data', '5432', 1, '5432')"<br>2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>2020-05-27 18:48:12: pid 6478: DETAIL: disabling statement_timeout<br>2020-05-27 18:48:12: pid 6478: ERROR: executing recovery, execution of command failed at "1st stage"<br>2020-05-27 18:48:12: pid 6478: DETAIL: command:"recovery_1st_stage"<br>2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exit with SUCCESS.<br>2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exits with status 0<br><br>Look like recovery_1st_stage is not executed as on previous version I could see content of
recovery_1st_stage file in the log.</div><div><br></div><div>What I'm missing here? What else can I check? <br><br></div><div>Best regards,</div><div>Luís Alves<br></div></div>