Skip site navigation (1) Skip section navigation (2)

Killing postgres processes.

From: Adam Bultman <adam(dot)bultman(at)iconideas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Killing postgres processes.
Date: 2002-07-23 14:11:37
Message-ID: 1027433527.17185.9.camel@twiki.iconideas.com (view raw or flat)
Thread:
Lists: pgsql-novice
Greetings.  I've got a postgres server that's being hit rather heavily. 
I have many processes inititated by users (they start scripts running). 
Because of user impatience and idiocy, despite my explanations, they
continue to re-run the script and not wait for the script to end the
first time (i.e. 'why isn't it finishing? <click click click>'). So, I
have about 9 postgres SELECTS going on right now that are pretty much
runaway and useless.  Can I safely kill these without fubaring things? 
I know killing the postmaster is Evil, but how about other processes? 
i'm going to get a call in a few moments now in complaint, and I'd like
to be able to curb this right away.

Adam

-- 

Adam Bultman
adam(dot)bultman(at)iconideas(dot)com
616-836-7213
http://www.iconideas.com


In response to

Responses

pgsql-novice by date

Next:From: Tuomas VanhanenDate: 2002-07-23 14:35:24
Subject: Security, IP and username restrictions
Previous:From: Andrew McMillanDate: 2002-07-23 08:49:04
Subject: Re: table move across databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group