X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CA7299DCA7A for ; Wed, 4 Jan 2006 21:26:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45018-06 for ; Wed, 4 Jan 2006 21:26:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx-out-04.forthnet.gr (mx-out.forthnet.gr [193.92.150.6]) by postgresql.org (Postfix) with ESMTP id 288B09DC870 for ; Wed, 4 Jan 2006 21:26:45 -0400 (AST) Received: from mx-av-03.forthnet.gr (mx-av.forthnet.gr [193.92.150.27]) by mx-out-04.forthnet.gr (8.13.5/8.13.5) with ESMTP id k051QnPE026653 for ; Thu, 5 Jan 2006 03:26:49 +0200 Received: from mx-in-01.forthnet.gr (mx-in-01.forthnet.gr [193.92.150.23]) by mx-av-03.forthnet.gr (8.13.5/8.13.5) with ESMTP id k051Qnf9031044 for ; Thu, 5 Jan 2006 03:26:49 +0200 Received: from ppp1-172.cha.forthnet.gr (ppp1-172.cha.forthnet.gr [213.16.184.172]) by mx-in-01.forthnet.gr (8.13.5/8.13.5) with ESMTP id k051Qlco027639 for ; Thu, 5 Jan 2006 03:26:48 +0200 Authentication-Results: mx-in-01.forthnet.gr from=el96645@mail.ntua.gr; sender-id=neutral; spf=neutral Subject: Re: psql: could not connect to server: Network is From: markos To: pgsql-admin@postgresql.org In-Reply-To: <3962.1136397096@sss.pgh.pa.us> References: <1136376493.9304.15.camel@localhost> <5e744e3d0601040434h2853fdafvc0068beae18681c2@mail.gmail.com> <1136396049.8613.18.camel@localhost> <3962.1136397096@sss.pgh.pa.us> Content-Type: text/plain Date: Thu, 05 Jan 2006 03:26:58 +0200 Message-Id: <1136424419.10198.11.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.258 required=5 tests=[AWL=-0.018, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.258 X-Spam-Level: X-Archive-Number: 200601/61 X-Sequence-Number: 20149 On Wed, 2006-01-04 at 12:51 -0500, Tom Lane wrote: > markos writes: > > psql -h localhost -U markulis > > psql: could not connect to server: Network is unreachable > > Is the server running on host "localhost" and accepting > > TCP/IP connections on port 5432? > > Hm. "Network is unreachable" means that you have got a networking > problem not a database problem. You'll probably find that simple > commands like "ping localhost" don't work either. The problem could > be a DNS issue --- what does "nslookup localhost" say? If it comes > back with something reasonable, then you've got a kernel > misconfiguration issue, which I don't think I can help you with. > > regards, tom lane Thanks a lot. You were actually right, the network was down. I just had to give the command : "sudo ifup lo". I just couldn't narrow my search until you made sure that postgre is ok, so thanks again