dbTalk Databases Forums  

Kill a postgres session

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Kill a postgres session in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
HM
 
Posts: n/a

Default Kill a postgres session - 10-26-2004 , 03:26 AM






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 !

HM

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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.