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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
