Re: How do I disconnect other users gracefully from a

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: How do I disconnect other users gracefully from a
Дата
Msg-id Pine.LNX.4.33.0306231057300.23895-100000@css120.ihs.com
обсуждение исходный текст
Ответ на How do I disconnect other users gracefully from a database???  (P G <pg_dba@yahoo.com>)
Список pgsql-admin
On Mon, 23 Jun 2003, P G wrote:

> What is the graceful way to disconnect other users
> from a database without shutting it down?  Is there a
> command that I can use within psql or is it simply
> "kill $PID_OF_USER" from the OS shell command line?

That's how I do it, but if you're just looking to shut down / restart the
database and need to bump everybody off, look at the -m switch to pg_ctl.

-m SHUTDOWN-MODE      May be 'smart', 'fast', or 'immediate'




В списке pgsql-admin по дате отправления:

Предыдущее
От: P G
Дата:
Сообщение: How do I disconnect other users gracefully from a database???
Следующее
От: Michiel Lange
Дата:
Сообщение: locking all databases