Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DA6579FB6D7 for ; Mon, 26 Feb 2007 09:32:27 -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 67712-09 for ; Mon, 26 Feb 2007 09:32:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 7DE6D9FB7C3 for ; Mon, 26 Feb 2007 09:32:15 -0400 (AST) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 75D7275EFD; Mon, 26 Feb 2007 13:29:06 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 4C829274090; Mon, 26 Feb 2007 13:29:06 +0000 (GMT) Message-ID: <45E2E0A2.4070900@archonet.com> Date: Mon, 26 Feb 2007 13:29:06 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: Gauri Kanekar Cc: pgsql-performance@postgresql.org Subject: Re: Server Startup Error References: <7e4ba9550702260522t3e2815em8136be53da6aa3ec@mail.gmail.com> In-Reply-To: <7e4ba9550702260522t3e2815em8136be53da6aa3ec@mail.gmail.com> 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=0.207 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/289 X-Sequence-Number: 23343 Gauri Kanekar wrote: > Hi List, > > Machine was down due to some hardware problem. > > After then when i issue this command /usr/local/pgsql/bin/psql -l > its giving me the following error > > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > Can anybody tell me what going wrong?? Well, it's either looking in the wrong place or the server isn't actually running. 1. Do your startup scripts start PG? 2. Is there a server process? "ps auxw | grep postgres" 3. What do your logfiles say? -- Richard Huxton Archonet Ltd