Kill a postgres session

From: f-f(at)club-internet(dot)fr (HM)
To: pgsql-general(at)postgresql(dot)org
Subject: Kill a postgres session
Date: 2004-10-26 08:26:04
Message-ID: 78f4a563.0410260026.51210e0e@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-10-26 08:36:56 Re: [Fwd: Abrupt close of pgsql backend]
Previous Message Henk Ernst Blok 2004-10-26 08:16:56 Strange count(*) implementation?