Yes i can drop database when i directly connect to master server. <span id="result_box" class="short_text" lang="en"><span class="hps">I do not understand why pgpool sent command to postgresql master server to </span></span>shutdown and then <span id="result_box" class="short_text" lang="en"><span class="hps">initiates failover procedure? Nobody can't access to master server </span></span>except me and i don't restart the master db by myself. Those <span id="result_box" class="short_text" lang="en"><span class="hps">behavior i see </span></span><span id="result_box" class="short_text" lang="en"><span class="hps">for the second time.</span></span><br>
<br><div class="gmail_quote">2012/5/21 Lazaro Ruben Garcia Martinez <span dir="ltr"><<a href="mailto:lgarciam@uci.cu" target="_blank">lgarciam@uci.cu</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:14pt;font-family:Times New Roman">When there are open connections in a database, it can not be dropped. Maybe pgpool connects to the database server for balancing some query or there are other user connected to the database. Can you try to drop the database directly?<br>
<br>Regards.<br><br><hr><blockquote style="padding-left:5px;font-size:12pt;font-style:normal;margin-left:5px;font-family:Helvetica,Arial,sans-serif;text-decoration:none;font-weight:normal;border-left:2px solid rgb(16,16,255)">
<div><div class="h5">I have pgpool-II version 3.1.3 installed and three db postgresql 9.1.3 in streaming replication. When i try to drop database i see this in pgpool log:<br><br>2012-05-21 15:01:48 LOG: pid 15484: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 6769 statement: DROP DATABASE xxx; message: database "xxx" is being accessed by other users<br>
2012-05-21 15:02:20 LOG: pid 26326: postmaster on DB node 1 was shutdown by administrative command<br>2012-05-21 15:02:20 LOG: pid 26326: degenerate_backend_set: 1 fail over request from pid 26326<br>2012-05-21 15:02:20 LOG: pid 4975: starting degeneration. shutdown host 10.141.2.54(5432)<br>
2012-05-21 15:02:20 LOG: pid 4975: Restart all children<br>2012-05-21 15:02:20 LOG: pid 4975: execute command: /etc/pgpool.d/failover.sh 1 10.141.2.54 5432 /var/lib/postgresql/9.1/main 0 10.141.2.53 0 1<br>2012-05-21_15:02:20 failover: Master failed at 10.141.2.54 (0). New master is 10.141.2.53 (0)<br>
2012-05-21_15:02:20 failover: New master start triggered.<br><br>Why pgpool initiated failover procedure on statement drop database? I add drop statement in black_function_list may be this helps me.<br><br clear="all"><br>
-- <br>σ ΥΧΑΦΕΞΙΕΝ σΕΜΡΧΛΑ εΧΗΕΞΙΚ<br>
<br></div></div>_______________________________________________<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" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote><br></div>
<br>
<div>
<a href="http://www.uci.cu/" target="_blank">
<img src="">
</a></div>
<br></div></blockquote></div><br><br clear="all"><br>-- <br>σ ΥΧΑΦΕΞΙΕΝ σΕΜΡΧΛΑ εΧΗΕΞΙΚ<br>