Thread: terminate a coonextion within pg

Hi list,

Is there a possibility for a dbA to immediately terminate a working user
connection?

JY
--

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
> owner@postgresql.org] On Behalf Of Jean-Yves F. Barbier
> Sent: Tuesday, June 28, 2011 12:16 PM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] terminate a coonextion within pg
>
> Hi list,
>
> Is there a possibility for a dbA to immediately terminate a working
> user
> connection?
>
> JY

SELECT pg_termindate_backend(process_id);


> --
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice

On Tue, 28 Jun 2011 19:39:57 -0600, "mark" <dvlhntr@gmail.com> wrote:

> > Is there a possibility for a dbA to immediately terminate a working
> > user
> > connection?
> >
> > JY
>
> SELECT pg_termindate_backend(process_id);

Perfect, thanks.

--

Jean-Yves F. Barbier wrote:
> "mark"<dvlhntr@gmail.com>  wrote:
>> Jean-Yves F. Barbier wrote:
>>> Is there a possibility for a dbA to immediately terminate a working
>>> user connection?

>> SELECT pg_termindate_backend(process_id);1

> Perfect, thanks.

That should be "pg_terminate_backend(pid int)".

--
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg