X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AAEC5476317
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 01:23:01 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id E7E6447630B
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 01:22:56 -0500 (EST)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 2925674; Wed, 26 Mar 2003 22:22:46 -0800
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: "Stefan Berg" <svb1@ananzi.co.za>
Subject: Re: Database not restarting
Date: Wed, 26 Mar 2003 22:22:32 -0800
User-Agent: KMail/1.4.3
References: <redirect-67329425@mail01.infosat.net>
In-Reply-To: <redirect-67329425@mail01.infosat.net>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Message-Id: <200303262222.32821.josh@agliodbs.com>
Content-Transfer-Encoding: quoted-printable
X-Spam-Status: No, hits=-21.9 required=5.0
	tests=BAYES_10,IN_REP_TO,REFERENCES,USER_AGENT_KMAIL
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/608
X-Sequence-Number: 12646

Stef,

> Can anyone give some advise on an elegant way to shut down
> the database properly. In my case, I don't worry or care
> if someone was still busy on the database, because nobody
> updates stuff.

$PGHOME/bin/pg_ctl -m fast stop

There was a bug with "fast" shutdown in pg_ctl in some versions of Postgres=
;=20
I'm not sure whether or not it's fixed in 7.3.1 but it certainly is fixed i=
n=20
7.3.3.

--=20
Josh Berkus
Aglio Database Solutions
San Francisco