How do I disconnect other users gracefully from a database???
How do I disconnect other users gracefully from a database???
От:
P G <pg_dba@yahoo.com>
Дата:
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
Re: How do I disconnect other users gracefully from a
От:
"scott.marlowe" <scott.marlowe@ihs.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'