Re: Who's attached to the database?

>>> Bricklen Anderson <banderson@[EMAIL PROTECTED]
> wrote:
 
>> Is there a command to disconnect this user?
> 
> select pg_cancel_backend(<procpid of connection>);
 
I thought that just canceled the currently active statement (if any). 
Don't you need to use pg_ctl kill (or the OS kill command) to actually
close the connection?
 
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
 
http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin