Postgres Pro
Downloads
Home   >   mailing lists

Re: How to disconnect a single user in Postgresql 8.2.5 from a database - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to disconnect a single user in Postgresql 8.2.5 from a database
Date
Msg-id 25670.1271770280@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to disconnect a single user in Postgresql 8.2.5 from a database  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: How to disconnect a single user in Postgresql 8.2.5 from a database  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view 
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Apr 19, 2010 at 8:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The reason the function isn't there before 8.4 is that that's not
>> promised to work before 8.4 ... most of the time it will work, but
>> once in awhile you could get nasty side-effects.

> So, pg_cancel_backend(pid) is the 8.3 version, that may or may not
> always work then, right?

No, I didn't say that.

            regards, tom lane

pgsql-admin by date:

Previous
From: Scott Mead
Date:
Subject: Re: Tail -f or watch for postgres
Next
From: Lewis Kapell
Date:
Subject: Re: How to disconnect a single user in Postgresql 8.2.5 from a database