Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0F70A2E011A for ; Thu, 21 Feb 2008 13:03:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 18641-05 for ; Thu, 21 Feb 2008 13:03:06 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 0CFA42E00D4 for ; Thu, 21 Feb 2008 13:03:04 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JSEor-0000DD-Am for pgsql-admin@postgresql.org; Thu, 21 Feb 2008 12:02:49 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id F19BE50023; Thu, 21 Feb 2008 12:02:44 -0500 (EST) Date: Thu, 21 Feb 2008 12:02:44 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: pg_ctl reload query Message-ID: <20080221170244.GL17293@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <47BD0C94.7010208@internode.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47BD0C94.7010208@internode.com.au> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/242 X-Sequence-Number: 28316 On Thu, Feb 21, 2008 at 04:01:00PM +1030, Shilpa Sudhakar wrote: > Hi All, > > Wanted to know what does pg_ctl do in the background when we run *pg_ctl > -D datadir reload * It sends a SIGHUP to the back end. > command. Generally, it just reloads the files and everything works fine. > But strangely, last time when we ran the reload command and tried to > access *psql dbname, * > It gives a message *"database shutting down" * Are you sure you didn't issue "restart" instead? It's an easy enough mistake to make. A