By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,776 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,776 IT Pros & Developers. It's quick & easy.

Kill a postgres session

P: n/a
Hello !

To kill a session i used KILL -INT <PID>.

This command wasn't successfull. The processus is still here when an
'ps ax' or a 'select * from pg_stat_activity'

Is there an other way to kill this process only because a web server
24/7 use postgres and cannot stop postgresql now.

Thanks !


PS : To stop postgres i use 'pg_ctl -m immediate stop' to stop
postgresql because the '/etc/init.d/postgresql stop' fails when a
session is blocked.
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.