Re: Dropping a DB while it is in use? - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Dropping a DB while it is in use?
Date
Msg-id 3FF8BEAF.4050302@bigfoot.com
Whole thread Raw
In response to Dropping a DB while it is in use?  ("Chad N. Tindel" <chad@tindel.net>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: what is the cause that scan type is showing as 'seq scan' after
Next
From: Stef
Date:
Subject: Re: ERD tool for postgres?