From: f-f(at)club-internet(dot)fr
To: pgsql-general(at)postgresql(dot)org
Subject:
Date: 2004-10-27 09:41:17
Message-ID: mnet3.1098862877.10543.f-f@club-internet.fr
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 a '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.

Responses

  • Re: at 2004-10-27 09:11:16 from Richard Huxton

Browse pgsql-general by date

  From Date Subject
Next Message Henriksen, Jonas F 2004-10-27 11:42:40 update data in different database
Previous Message Marco Ferretti 2004-10-27 09:19:17 Re: Comment on timezone and interval types