On Wed, 2005-05-11 at 15:08, Ing. Jhon Carrillo wrote:
> I have a problem with the users administration. When I want to erase
> (drop) some databases there's an error: ** database "name_db" is being
> accessed by other users.** I want to kill the user sessions conected
> but i don't know how to do it (Kill the user sessions).
First, use ps to find the pid of the offending users. for instance:
ps ax|grep postgres|grep test
18925 pts/1 S 0:00 postgres: postgres test [local] idle
then, as the postgres superuser, kill the backend:
kill 18925