Re: Who's attached to the database?

>>> Bricklen Anderson <banderson@presinet.com> 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