Hi,<div><br></div><div>I am running pgpool 3.0.5 and pgpooladmin 3.1.1 and have two databases (Postgresql 9.0) with master/slave streaming replication. I followed the instructions <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index.html">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index.html</a> to set it up. So far, replication and failover work fine- if my primary server (Ubuntu1) fails then the secondary (Ubuntu2) becomes the primary. At this point the pgpooladmin interface shows the new primary server with a "disconnect" button and the new secondary with "disconnect" and "promote".</div>
<div><br></div><div>Since I have some software that makes it very hard to edit the connection information, they are still connected to the old Primary server Ubuntu1. They can successfully connect, but they have a read-only connection.</div>
<div><br></div><div>I would like to be able to promote Ubuntu1 to be the new primary server again, but when I press "promote" nothing happens in either the pgpool log or the postgresql logs. Eventually I get a message about "wait_connection_closed" in the pgpool log, after a time-out of some kind.</div>
<div><br></div><div>I think I must be missing something in my setup so:</div><div><br></div><div>Is it possible to do promotion like that in 3.0?</div><div>If so- what have I missed to get the promote button to work?</div>
<div>If not- what is the best method of promoting a slave back to master?</div><div><br></div><div>Many thanks</div><div><br></div><div>Jo<br clear="all"><div><br></div>-- <br><div><b></b><b>Jo Cook</b><br>Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18 7RL, UK <br>
t:<a href="tel:%2B44%20750%20095%208167" value="+447500958167" target="_blank">+44 750 095 8167</a><br><div>
<a href="http://www.isharemaps.com/" target="_blank">iShare - Data integration and publishing platform</a><br><br>
***************************************** <font color="#ff0000"><br></font></div></div><div>
<br>
<font size="0.7em">
Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN
VAT no. 864201149.</font></div><br>
</div>