... - Mailing list pgsql-general

From f-f@club-internet.fr
Subject ...
Date
Msg-id mnet3.1098862877.10543.f-f@club-internet.fr
Whole thread Raw
Responses Re:  (Richard Huxton <dev@archonet.com>)
List 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.


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Bug: 8.0 beta1 either view optimization or pgdump/pgrestore
Next
From: Thomas Hallgren
Date:
Subject: Re: Theory