Is there a way to kill all the connections to a DB so that it can safely be dropped? Given that connections to a DB can come from any number of clients, the only way I've found to do this is to shutdown postgres, which is clearly an unacceptable solution because it stops access to the other 50 or so databases that are being used on the system.
You can do a kill -INT to backend that are managing the connection.
Regards Gaeatano Mendola
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
