469,081 Members | 1,871 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

(NONE)

f-f
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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
1 3713
f-*@club-internet.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?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by M-a-S | last post: by
28 posts views Thread by The Eternal Squire | last post: by
6 posts views Thread by Leif K-Brooks | last post: by
35 posts views Thread by Steven Bethard | last post: by
16 posts views Thread by gaudetteje | last post: by
2 posts views Thread by spifster | last post: by
8 posts views Thread by micklee74 | last post: by
18 posts views Thread by Alan G Isaac | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.