Re: How do I disconnect other users gracefully from a - Mailing list pgsql-admin

From scott.marlowe
Subject Re: How do I disconnect other users gracefully from a
Date
Msg-id Pine.LNX.4.33.0306231057300.23895-100000@css120.ihs.com
Whole thread Raw
In response to How do I disconnect other users gracefully from a database???  (P G <pg_dba@yahoo.com>)
List 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 by date:

Previous
From: P G
Date:
Subject: How do I disconnect other users gracefully from a database???
Next
From: Michiel Lange
Date:
Subject: locking all databases