Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A85D36321D5 for ; Mon, 16 Aug 2010 02:30:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 54995-07 for ; Mon, 16 Aug 2010 05:30:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kka003.ashisuto.co.jp (kka003.ashisuto.co.jp [202.32.38.142]) by mail.postgresql.org (Postfix) with ESMTP id 6EA766324D6 for ; Mon, 16 Aug 2010 02:30:26 -0300 (ADT) Received: from kka003.ashisuto.co.jp (localhost [127.0.0.1]) by kka003.ashisuto.co.jp (xx.xx.xx/3.7W) with ESMTP id o7G5UOdx018526 for ; Mon, 16 Aug 2010 14:30:24 +0900 (JST) Received: from ashisuto.co.jp (maildlv [192.168.1.242]) by kka003.ashisuto.co.jp (xx.xx.xx/3.7W) with ESMTP id o7G5UOsT018523 for ; Mon, 16 Aug 2010 14:30:24 +0900 (JST) Received: from maildlv.ashisuto.co.jp (localhost [127.0.0.1]) by ashisuto.co.jp (8.14.3/8.11.6) with ESMTP id o7G5UNxd024705 for ; Mon, 16 Aug 2010 14:30:23 +0900 (JST) Received: from localhost [127.0.0.1] by maildlv.ashisuto.co.jp with ESMTP id QAA24704; Mon, 16 Aug 2010 14:30:23 +0900 Received: from mailtora.ashisuto.co.jp (mailtora [192.168.1.241]) by ashisuto.co.jp (8.14.3/8.11.6) with ESMTP id o7G5UMcf024700 for ; Mon, 16 Aug 2010 14:30:23 +0900 (JST) Received: from [192.168.23.193] ([192.168.23.193]) (authenticated) by mailtora.ashisuto.co.jp (xx.xx.xx./8.11.6) with ESMTP id o7G5UMn25866 for ; Mon, 16 Aug 2010 14:30:22 +0900 (JST) Message-ID: <4C68CCE9.5050608@ashisuto.co.jp> Date: Mon, 16 Aug 2010 14:30:17 +0900 From: Kenichiro Tanaka User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Can't start server References: 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.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/113 X-Sequence-Number: 35362 Hello Did you try to remove postmaster.pid? I can reproduce this error to fill null postmaster.pid. 2010-08-16 05:15:36 GMT FATAL: bogus data in lock file "postmaster.pid": "" And I could also start PostgreSQL to remove postmaster.pid. (2010/08/14 12:34), Sivaroj Limvipuwat wrote: > My server isn't starting anymore, it used to work fine. > > When I try to start it, it says starting.... done. But it still isn't > started. If I try connect it gives me this error > > could not connect to server: Connection refused (0x0000274D/10061) Is > the server running on host "127.0.0.1" and accepting TCP/IP > connections on port 5432? > > When I checked my event viewer it showed this error > > 2010-08-14 03:26:08 GMTFATAL: bogus data in lock file > "postmaster.pid": "" > > Any idea whats going on?