On Fri, Jul 04, 2008 at 06:50:43AM -0700, Lennin Caro wrote: > try this > > select pg_cancel_backend(<processid_db>); > > if the command not work kill the process in os > > kill -9 proccessid_os *NO*! Never kill -9 a postgres backend!!! This is like a headshot, no chance to clean up. You will make your whole pg server shut down! A simple kill should suffice. Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.craniosacralzentrum.de www.forteego.de