Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 22DE69FA344 for ; Fri, 2 Feb 2007 16:33:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 22222-09 for ; Fri, 2 Feb 2007 16:33:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net [203.16.214.141]) by postgresql.org (Postfix) with ESMTP id AD8649FA2BB for ; Fri, 2 Feb 2007 16:33:29 -0400 (AST) Received: from ppp247-71.static.internode.on.net (HELO [192.168.8.200]) ([203.122.247.71]) by ipmail02.adl2.internode.on.net with ESMTP; 03 Feb 2007 07:03:26 +1030 X-IronPort-AV: i="4.13,273,1167571800"; d="scan'208"; a="79670702:sNHT20662474" Message-ID: <45C3A015.5080808@007Marketing.com> Date: Sat, 03 Feb 2007 07:03:25 +1030 From: Shane Ambler User-Agent: Thunderbird 1.5.0.8 (Macintosh/20061025) MIME-Version: 1.0 To: Shoaib Mir CC: Manish Pillai , pgsql-admin@postgresql.org Subject: Re: Postgres is not starting or stopping References: <878936.26029.qm@web52313.mail.yahoo.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.256 tagged_above=0 required=5 tests=AWL, BAYES_40, BIZ_TLD, SPF_HELO_PASS X-Spam-Level: * X-Archive-Number: 200702/28 X-Sequence-Number: 24493 >> I am getting only this much... >> >> [root@KLC2 init.d]# ./postgresql restart >> Stopping postgresql service: [FAILED] >> Starting postgresql service: [FAILED] >> [root@KLC2 init.d]# >> How to enable log in postgres...Please help >> Unless you have turned it off logging is on by default (with minimum setting) Your prob may be knowing where the log is. By default you will find it in your data directory along with postgresql.conf and it will be called serverlog tail that file (as root) and see what shows up there -- Shane Ambler pgSQL@007Marketing.com Get Sheeky @ http://Sheeky.Biz