Обсуждение: Dropping a DB while it is in use?

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.

Thanks,

Chad

Chad N. Tindel wrote:

> 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