<span style="font-family:arial,sans-serif;font-size:12.800000190734863px">Hello,</span><div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
I'm first going to introduce myself a little bit. I'm a student adapted informatics and I'm currently working on my thesis. One requirement of my thesis is a highly available postgresql database. I choose to use PGpool as it is useful for recovering a failed node and making the hot standby the master on a master failure.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Current situation:</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">I followed this tutorial: <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html</a></div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">All my servers are running Debian squeeze. I have two nodes with a postgresql-9.1 installed using apt-get. I installed it with the repository squeeze-backports. On the loadbalancer I also installed pgpool2 (3.1.3) with the squeeze backports repository. On this loadbalancer I installed PgpoolAdmin.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">PgpoolAdmin can see the nodes. So it tells me if the node is up/down/disconnected. On the 'Node Status' tab I click 'details' and can see all the details of the node so this connection is ok I think.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">The tutorial continues with the master server already running and the standby server with postgresql stopped.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Then I have to click "Recovery" to bring the standby server automatically up.</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">However when I click "Recovery" I get the this error: <label style="font-weight:bold">Error Code: </label>e1012 <label style="font-weight:bold">Error Message: </label>pcp_recovery_node command error occurred.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Can someone help me get this working? Maybe it helps when someone explains what scripts and commando's are being triggered and which connections are set up when I hit the recovery button because I think there's something wrong.</div>
<div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Thanks in advance.</div>