<div dir="ltr"><div>Dear Guys,<br><br>I have got a problem... <br><br></div><div>I started to use pgpool2 3.3 with postgresql 9.3 on Debian 7.3, using the pgpool/postgresql repositories.<br></div><div><br></div>I have setup a cluster of two pgpool2 nodes and three backend databases. It works in a way after setup, but when I started to test the steps that should be done for recovery/adding a node, I have ran into the following problem:<br>
<br>When <span class="">pgpool</span> starts the pgpool_remote_start
script, it never returns. After the end of the scripts,
pcp_recovery_node waits until the end of time.<br><br>Running the script by hand always work.<br>
<br>postgres@pool-1:~$ /usr/sbin/pcp_recovery_node -d 0 localhost 9898 postgres DifficultPassword 2<br>DEBUG: send: tos="R", len=46<br>DEBUG: recv: tos="r", len=21, data=AuthenticationOK<br>DEBUG: send: tos="D", len=6<br>
<br><div>... and just waits forever...<br><br></div><div>Meanwhile the remote postgresql DB is up and running:<br><br>postgres@pool-3:~$ /usr/lib/postgresql/9.3/bin/pg_ctl -w -D /var/lib/postgresql/9.3/main/ status<br>
pg_ctl: server is running (PID: 8780)<br><br><br></div><div>The pgpool_remote_start script is:<br>postgres@pool-1:~$ /var/lib/postgresql/pgpool_remote_start pool-3 /var/lib/postgresql/9.3/main/<br>waiting for server to start....2014-03-03 14:33:50 CET LOG: database system was shut down at 2014-03-03 14:33:42 CET<br>
2014-03-03 14:33:50 CET LOG: database system is ready to accept connections<br>2014-03-03 14:33:50 CET LOG: autovacuum launcher started<br> done<br>server started<br>2014-03-03 14:33:51 CET LOG: received SIGHUP, reloading configuration files<br>
Connection to pool-3 closed.<br>postgres@pool-1:~$<br><br></div><div>Here is the script text:<br>----------------------<br>#!/bin/sh<br><br>/usr/bin/logger Called "$0" "$*"<br><br>DEST=$1<br>DESTDIR=$2<br>
PGCTL="/usr/lib/postgresql/9.3/bin/pg_ctl"<br><br>COMMAND="ssh -t postgres@$DEST '$PGCTL -w -D $DESTDIR start'"<br>/usr/bin/logger -- Trying "$COMMAND"<br>eval $COMMAND<br></div><div>
----------------------</div>Attila<br></div>