server won't shutdown

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: server won't shutdown
Date: 2003-02-11 20:58:02
Message-ID: Pine.LNX.4.44.0302111248570.30523-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Server won't shutdown:

Currently, we are running 7.3.2. However, we have had this problem since 7.1.

Our production server has dozens of connections from different persistent
applications (some web, some runnning on other systems).

When I do a shutdown:
$pgpath/bin/pg_ctl -D $datadir -m fast stop

the server will not completely shutdown.

I realize that the pg_ctl script will send a -QUIT to the postmaster
process, which will then also send some kind of quit signal to the outstanding
backends?, but, every time, some of the postgres backend processes will not
quit and the server "hangs" in shutdown mode.

To get around this, I send a -QUIT is sent to a backend process that is not
doing any activity and then the server comes down (and not in a good way I'm
sure).

Can anyone explain *why* the server won't shutdown as well as suggest the
*best* way to handle this situation?

Thanks,

--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"No man is wise enough by himself"
-- Titus Maccius Plautus
(254 Bc - 184 BC), Miles Gloriosus

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui Vilela 2003-02-11 21:08:55 Problem compiling with readline
Previous Message Kevin Tsang 2003-02-11 19:18:39 How to extend database to another disk space