Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0F4272E00A7 for ; Thu, 21 Feb 2008 01:31:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20606-05-2 for ; Thu, 21 Feb 2008 01:31:08 -0400 (AST) Received: from mail.internode.com.au (mail.internode.com.au [192.83.231.27]) by postgresql.org (Postfix) with ESMTP id F3BDC2E0085 for ; Thu, 21 Feb 2008 01:31:03 -0400 (AST) Received: from [172.16.0.221] (staffnet.internode.com.au [203.26.95.65]) by mail.internode.com.au (8.13.7/8.12.1) with ESMTP id m1L5V0BX014897 for ; Thu, 21 Feb 2008 16:01:00 +1030 (CST) Message-ID: <47BD0C94.7010208@internode.com.au> Date: Thu, 21 Feb 2008 16:01:00 +1030 From: Shilpa Sudhakar User-Agent: Thunderbird 1.5.0.14 (Windows/20071210) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_ctl reload query Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.91.2, clamav-milter version 0.91.2 on mail X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.063 tagged_above=0 required=5 tests=AWL=1.063, RCVD_IN_DNSWL_LOW=-1 X-Spam-Level: X-Archive-Number: 200802/236 X-Sequence-Number: 28310 Hi All, Wanted to know what does pg_ctl do in the background when we run *pg_ctl -D datadir reload * After modifying the entries in pg_hba.conf file we ran the reload 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" * As far as i know, this msg appears only when a restart command is given. Please let me know if my understanding is right and what could have gone wrong for the db to shutdown. Thanks and Regards, Shilpa * *