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

Re: it refuses to go down...

From: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: it refuses to go down...
Date: 2008-03-25 17:59:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
>  > did you try pg_ctl -m immediate stop   ???
>  I just did, and it worked.
>    $ pg_ctl stop -m immediate
>    waiting for server to shut down.... done
>    server stopped

I'd be careful about shutting down using "immediate" mode. It forces
the database into recovery mode.

Your problem could be that one or two connections are in a weird state
and even "fast" stopping can't kill them. Next time you have to
restart the server, you should check on the status of connections and
see if any are in a weird state. I had to deal with this recently
where the status was "notify interrupt" and I couldn't even stop fast.
I had to change some application code, but not much.

Just run "ps ax | grep post" (or whatever options you like to give ps
to show all processes) to filter out postgres processes. A connection
entry will look like like.

[pid] ?        Ss      0:00 postgres: [user] [database] [client] [status]


In response to


pgsql-admin by date

Next:From: Tena SakaiDate: 2008-03-25 18:25:14
Subject: Re: it refuses to go down...
Previous:From: Uwe C. SchroederDate: 2008-03-25 17:55:28
Subject: Re: postgresql is slow with larger table even it is in RAM

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