Or, Kill -s SIGINT <pid of offending statement> Thanks, Anjan -----Original Message----- From: Gourish Singbal [mailto:gourish@xxxxxxxxx] Sent: Friday, May 13, 2005 9:27 AM To: Ing. Jhon Carrillo Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] how do i kill user sessions? 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
