Re: How do I disconnect other users gracefully from a

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: P G <pg_dba(at)yahoo(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How do I disconnect other users gracefully from a
Date: 2003-06-23 16:58:14
Message-ID: Pine.LNX.4.33.0306231057300.23895-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Kovalcik 2003-06-23 18:47:06 How do I select the last Id in a column???
Previous Message P G 2003-06-23 15:50:32 How do I disconnect other users gracefully from a database???