Re: Forcing connections closed - Mailing list pgsql-admin

From Andrew Rawnsley
Subject Re: Forcing connections closed
Date
Msg-id B8491520-52CA-11D8-87A8-000393A47FCC@ravensfield.com
Whole thread Raw
In response to Re: Forcing connections closed  (Juan Miguel <juanmime@ono.com>)
List pgsql-admin
You can also get pid information from the system view pg_stat_activity,
which also tells you who your killing and what database they're
connected to.

On Jan 29, 2004, at 5:36 PM, Juan Miguel wrote:

> You can kill the procs (connections) using kill -9 PID
>
> For example,
>
> ps aux | grep post
>
> gives you a list of the postgres processes (all the active
> connections, and main postmaster). Here you can see the IP of the
> manchines connected from.
> Therefore, its easy to create an shell script for killing the
> connection of a client machine.
>
>> Thanks for that, however that's quite heavy handed in that it will
>> stop
>> the postgres instance.
>>
>> Is there any way to close connections to a database without stopping
>> postgres itself?
>> E.G I have three databases, A,B and C, and only want to close C.
>>
>> Thanks
>>
>> On Fri, 2004-01-30 at 10:21, Gregory S. Williamson wrote:
>>
>>
>>> pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
>>>
>>> e.g.
>>> pg_ctl stop -D /data/postgres/gex_runtime -m fast
>>>
>>> will shut down all connections and stop the postgres instance:
>>> Shutdown modes are:
>>>  smart       quit after all clients have disconnected
>>>  fast        quit directly, with proper shutdown
>>>  immediate   quit without complete shutdown; will lead to recovery
>>> on restart
>>>
>>> HTH,
>>>
>>> Greg Williamson
>>> DBA
>>> GlobeXplorer LLC
>>>
>>> -----Original Message-----
>>> From:    Hadley Willan [mailto:hadley.willan@deeperdesign.co.nz]
>>> Sent:    Thu 1/29/2004 1:03 PM
>>> To:    PGSQL Admin
>>> Cc:
>>> Subject:    [ADMIN] Forcing connections closed
>>>
>>> Hello,
>>>    How do I force postmaster to terminate active connections on other
>>> databases?
>>>
>>> Thanks
>>>
>>
>>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
>      joining column's datatypes do not match
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: commit after dead lock
Next
From: Tom Lane
Date:
Subject: Re: commit after dead lock