Обсуждение: How do I disconnect other users gracefully from a database???

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?

Thanks.


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

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'