Skip site navigation (1) Skip section navigation (2)


From: f-f(at)club-internet(dot)fr
To: dev(at)archonet(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2004-10-27 16:07:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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'

----Message d'origine----
>Date: Wed, 27 Oct 2004 10:11:16 +0100
>De: Richard Huxton <dev(at)archonet(dot)com>
>A: f-f(at)club-internet(dot)fr
>Copie à: pgsql-general(at)postgresql(dot)org
>Sujet: Re: [GENERAL]
>f-f(at)club-internet(dot)fr wrote:
>> 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 McNaughtDate: 2004-10-27 16:12:06
Subject: Re: Reasoning behind process instead of thread based
Previous:From: Pierre-Frédéric CaillaudDate: 2004-10-27 15:59:46
Subject: Re: Array values and foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group