<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>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 id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">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>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>