Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we force fully disconnect all client connected to localhost:5432 - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: Can we force fully disconnect all client connected to localhost:5432
Date
Msg-id 4B3B40B6.5020609@postnewspapers.com.au
Whole thread Raw
In response to Can we force fully disconnect all client connected to localhost:5432  (Gaurav K Srivastav <gauravgkp@gmail.com>)
List pgsql-bugs
Tree view 
On 30/12/2009 2:02 PM, Gaurav K Srivastav wrote:
> Hi,
> Do we have any command to forcefully disconnet each client in postgres .
> If we have please let me know.

In 8.4 there's pg_terminate_backend(). Prior versions don't have any
truly safe method, though sending a SIGTERM to a backend is supposed to
be somewhat safe.

--
Craig Ringer

pgsql-bugs by date:

Previous
From: Gaurav K Srivastav
Date:
Subject: Can we force fully disconnect all client connected to localhost:5432
Next
From: Gaurav K Srivastav
Date:
Subject: Fwd: Can we force fully disconnect all client connected to localhost:5432