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 ACD6F9DC941 for ; Wed, 4 Jan 2006 08:11:10 -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 00240-05 for ; Wed, 4 Jan 2006 08:11:13 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A245D9DC93B for ; Wed, 4 Jan 2006 08:11:08 -0400 (AST) Received: from mx-out-02.forthnet.gr (mx-out.forthnet.gr [193.92.150.6]) by svr4.postgresql.org (Postfix) with ESMTP id 02DA45AF07B for ; Wed, 4 Jan 2006 12:11:11 +0000 (GMT) Received: from mx-av-03.forthnet.gr (mx-av.forthnet.gr [193.92.150.27]) by mx-out-02.forthnet.gr (8.13.5/8.13.5) with ESMTP id k04CB6bD012248 for ; Wed, 4 Jan 2006 14:11:06 +0200 Received: from mx-in-04.forthnet.gr (mx-in-04.forthnet.gr [193.92.150.163]) by mx-av-03.forthnet.gr (8.13.5/8.13.5) with ESMTP id k04CB6kw006142 for ; Wed, 4 Jan 2006 14:11:06 +0200 Received: from ppp1-197.cha.forthnet.gr (ppp1-197.cha.forthnet.gr [213.16.184.197]) by mx-in-04.forthnet.gr (8.13.5/8.13.5) with ESMTP id k04ABctF006727 for ; Wed, 4 Jan 2006 12:11:39 +0200 Authentication-Results: mx-in-04.forthnet.gr from=el96645@mail.ntua.gr; sender-id=neutral; spf=neutral Subject: psql: could not connect to server: Network is unreachable From: markos To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Wed, 04 Jan 2006 14:08:13 +0200 Message-Id: <1136376493.9304.15.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 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/41 X-Sequence-Number: 20129 Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? Now, I'm really confused because I used to have postgre 7 installed on my Debian without any serious problems with the configuration. Right now, I'm using Ubuntu Breezy and postgre 8. I have used the sample .conf files to set my own at /var/lib/postgres/data the only two un-commented lines at the postgresql.conf are : listen_addresses = 'localhost' # what IP interface(s) to listen on; # defaults to localhost, '*' = any port = 5432 And my pg_hba.conf is : # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust # The same using local loopback TCP/IP connections. # # TYPE DATABASE USER CIDR-ADDRESS METHOD host all all 127.0.0.1/32 trust host all all ::1/128 trust The command I issue to get this reply is : psql -h localhost -U markulis Also, I don't know if it is of any importance, but if I issue the command while online, it simply hangs. I have also experienced the same problem while trying to connect from pgadmin3. I really need some help on this, because I have to present my diploma work in short time and the system doesn't work.