<div dir="ltr"><div>template1=# exit<br>-bash-4.2$ psql template1 -c "CREATE EXTENSION pgpool_recovery"<br>ERROR: extension "pgpool_recovery" already exists<br>-bash-4.2$<br><br><br>[root@zile ~]# pcp_recovery_node -h 192.168.vip.vip -p 5432 -U pgpool -n 1<br>Password:<br>ERROR: unable to read data from socket.<br><br>[root@zile ~]# tail -10 /var/lib/pgsql/13/data/log/postgresql-Wed.log<br>2021-01-06 08:54:25.465 +03 [29639] FATAL: the database system is shutting down<br>2021-01-06 08:54:25.470 +03 [1446] LOG: database system is shut down<br>2021-01-06 08:54:47.739 +03 [1094] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit<br>2021-01-06 08:54:47.739 +03 [1094] LOG: listening on IPv4 address "0.0.0.0", port 5432<br>2021-01-06 08:54:47.739 +03 [1094] LOG: listening on IPv6 address "::", port 5432<br>2021-01-06 08:54:47.739 +03 [1094] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"<br>2021-01-06 08:54:47.740 +03 [1094] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"<br>2021-01-06 08:54:47.786 +03 [1292] LOG: database system was shut down at 2021-01-06 08:54:25 +03<br>2021-01-06 08:54:47.913 +03 [1094] LOG: database system is ready to accept connections<br>2021-01-06 09:01:14.477 +03 [1809] LOG: invalid length of startup packet<br><br>[root@zile ~]# tail -10 /var/log/pgpool_log/pgpool-2021-01-06_085447.log<br>2021-01-06 08:54:59: pid 1148: LOG: new IPC connection received<br>2021-01-06 08:54:59: pid 1088: LOG: watchdog cluster now holds the quorum<br>2021-01-06 08:54:59: pid 1088: DETAIL: updating the state of quarantine backend nodes<br>2021-01-06 08:54:59: pid 1148: LOG: new IPC connection received<br>2021-01-06 08:55:03: pid 1399: LOG: successfully acquired the delegate IP:"192.168.vip.vip"<br>2021-01-06 08:55:03: pid 1399: DETAIL: 'if_up_cmd' returned with success<br>2021-01-06 08:55:03: pid 1148: LOG: watchdog escalation process with pid: 1399 exit with SUCCESS.<br>2021-01-06 08:55:04: pid 1148: LOG: new outbound connection to turhal:9000<br>2021-01-06 08:55:04: pid 1148: LOG: new outbound connection to niksar:9000<br>2021-01-06 08:56:38: pid 1354: LOG: watchdog: lifecheck started<br>[root@zile ~]#<br></div><div><br></div><div>Thanks</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 6, 2021 at 4:15 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Tue, 5 Jan 2021 18:02:26 +0300<br>
Murat K <<a href="mailto:srvrmurat@gmail.com" target="_blank">srvrmurat@gmail.com</a>> wrote:<br>
<br>
> Hi All,<br>
> <br>
> I am implementing Pgpool-II + Watchdog Setup Example<br>
> <<a href="https://www.pgpool.net/docs/42/en/html/example-cluster.html" rel="noreferrer" target="_blank">https://www.pgpool.net/docs/42/en/html/example-cluster.html</a>> . I managed<br>
> to install pgpool 4.2.1 and run but having problems with online recovery<br>
> (pcp_recovery_node) and switchover/failover scenarios.<br>
> <br>
> # pcp_recovery_node -h vip.vip.vip.vip -p 9898 -U pgpool -n 1<br>
> Password:<br>
> ERROR: executing recovery, execution of command failed at "1st stage"<br>
> DETAIL: command:"recovery_1st_stage"<br>
> <br>
> I reviewed failover, follow primary, recovery_1st_stage scripts but could<br>
> not make it work.<br>
> Can somebody shed some light?<br>
<br>
Did you execute "CREATE EXTENSION ..." following this section?<br>
<br>
<a href="https://www.pgpool.net/docs/42/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-ONLINE-RECOVERY" rel="noreferrer" target="_blank">https://www.pgpool.net/docs/42/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-ONLINE-RECOVERY</a><br>
<br>
If you could share the pgpool log, I may figure out the cause.<br>
<br>
> Regards,<br>
> murat<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>