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
