Thursday, July 3, 2008

Re: [ADMIN] 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

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

No comments: