>>> Bricklen Anderson <banderson(at)presinet(dot)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