Thursday, July 3, 2008

Re: [ADMIN] Who's attached to the database?

Carol Walter wrote:
> Thanks, guys,
>
> This told me that the user that has it open is the interface user called
> db_user. Is there a command to disconnect this user?
>
> Carol

select pg_cancel_backend(<procpid of connection>);

--
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: