2007/10/24, Stefan Schwarzer <[EMAIL PROTECTED]>: > Hi there, > > I read dozens of times the "TIP 2: Don't 'kill -9' the postmaster"... > > Now, what am I supposed to do if I launched a query which takes ages, and > which I want to interrupt? > > Thanks for any advice, > > Stef >
Hello you have to use more gently way select pg_cancel_backend() http://www.postgresql.org/docs/current/interactive/functions-admin.html Pavel > ____________________________________________________________________ > > > Stefan Schwarzer > > Lean Back and Relax - Enjoy some Nature Photography: > http://photoblog.la-famille-schwarzer.de > > Appetite for Global Data? UNEP GEO Data Portal: > http://geodata.grid.unep.ch > > ____________________________________________________________________ > > > > > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
