Re: [GENERAL]

2004-10-27 Thread f-f 
Thanks for your answer!

I would like to kill only a postgres session not postmaster.
The table pg_session indicates the pid of the wrong session but kill -INT  didn't 
stop this session.

pg_ctl works fine when i want to stop postmaster with the argument '-m immediate stop'


Message d'origine
>Date: Wed, 27 Oct 2004 10:11:16 +0100
>De: Richard Huxton <[EMAIL PROTECTED]>
>A: [EMAIL PROTECTED]
>Copie à: [EMAIL PROTECTED]
>Sujet: Re: [GENERAL]
>
>[EMAIL PROTECTED] wrote:
>> Hello !
>> 
>> To kill a session i used KILL -INT .
>> 
>> 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.
>
> From the manuals:
>To terminate the postmaster normally, the signals SIGTERM, SIGINT, or 
>SIGQUIT can be used. The first will wait for all clients to terminate 
>before quitting, the second will forcefully disconnect all clients, and 
>the third will quit immediately without proper shutdown, resulting in a 
>recovery run during restart.
>
>The utility command pg_ctl can be used to start and shut down the 
>postmaster safely and comfortably.
>
>Does pg_ctl do anything for you?
>
>-- 
>   Richard Huxton
>   Archonet Ltd
>
>---(end of broadcast)---
>TIP 6: Have you searched our list archives?
>
>   http://archives.postgresql.org
>
>


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[GENERAL]

2004-10-27 Thread f-f 
Hello !

To kill a session i used KILL -INT .

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.


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings