Re: Dropping a DB while it is in use?

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Dropping a DB while it is in use?
Дата
Msg-id 3FF8BEAF.4050302@bigfoot.com
обсуждение исходный текст
Ответ на Dropping a DB while it is in use?  ("Chad N. Tindel" <chad@tindel.net>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: what is the cause that scan type is showing as 'seq scan' after
Следующее
От: Stef
Дата:
Сообщение: Re: ERD tool for postgres?