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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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