>>> Bricklen Anderson <banderson@xxxxxxxxxxxx> 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
