you can try. 1) ps -ef | grep "postgres" see which users are connectioned and than. 2) pkill -f 'postgres: postgres <databasename>'; its more safer i suppose than kill -9 regards Gourish On 5/12/05, Ing. Jhon Carrillo <jdigital@xxxxxxxxx> 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). > > thanks. -- Best, Gourish Singbal