Skip site navigation (1) Skip section navigation (2)

Re: Can we force fully disconnect all client connected to localhost:5432

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Gaurav K Srivastav <gauravgkp(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Can we force fully disconnect all client connected to localhost:5432
Date: 2009-12-30 11:59:50
Message-ID: 4B3B40B6.5020609@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Gaurav K SrivastavDate: 2009-12-30 12:36:12
Subject: Fwd: Can we force fully disconnect all client connected to localhost:5432
Previous:From: tomasDate: 2009-12-30 06:27:20
Subject: Re: BUG #5256: Error al abrir postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group