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 <pid> didn't stop this session.
pg_ctl works fine when i want to stop postmaster with the argument '-m immediate stop'
>Date: Wed, 27 Oct 2004 10:11:16 +0100
>De: Richard Huxton <dev(at)archonet(dot)com>
>Copie à: pgsql-general(at)postgresql(dot)org
>Sujet: Re: [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.
> 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?
pgsql-general by date
|Next:||From: Doug McNaught||Date: 2004-10-27 16:12:06|
|Subject: Re: Reasoning behind process instead of thread based|
|Previous:||From: Pierre-Frédéric Caillaud||Date: 2004-10-27 15:59:46|
|Subject: Re: Array values and foreign keys|