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 13F289DC860 for ; Wed, 4 Jan 2006 13:34:05 -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 61934-02 for ; Wed, 4 Jan 2006 13:34:04 -0400 (AST) X-Greylist: delayed 05:22:53.717356 by SQLgrey- Received: from mx-out-02.forthnet.gr (mx-out.forthnet.gr [193.92.150.6]) by postgresql.org (Postfix) with ESMTP id 54D7B9DC802 for ; Wed, 4 Jan 2006 13:34:01 -0400 (AST) 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 k04HY0qd005277 for ; Wed, 4 Jan 2006 19:34:00 +0200 Received: from mx-in-03.forthnet.gr (mx-in-03.forthnet.gr [193.92.150.26]) by mx-av-03.forthnet.gr (8.13.5/8.13.5) with ESMTP id k04HY09M031375 for ; Wed, 4 Jan 2006 19:34:00 +0200 Received: from ppp1-217.cha.forthnet.gr (ppp1-217.cha.forthnet.gr [213.16.184.217]) by mx-in-03.forthnet.gr (8.13.5/8.13.5) with ESMTP id k04HXvnM006626 for ; Wed, 4 Jan 2006 19:33:58 +0200 Authentication-Results: mx-in-03.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: <5e744e3d0601040434h2853fdafvc0068beae18681c2@mail.gmail.com> References: <1136376493.9304.15.camel@localhost> <5e744e3d0601040434h2853fdafvc0068beae18681c2@mail.gmail.com> Content-Type: text/plain Date: Wed, 04 Jan 2006 19:34:09 +0200 Message-Id: <1136396049.8613.18.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.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/53 X-Sequence-Number: 20141 First of all, thanks for the swift replies. The whole error message is actually this : 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? the result of : ps -aef | grep postmaster is postgres 8702 1 0 19:08 pts/1 00:00:00 /usr/lib/postgresql/8.0/bin/postmaster -D /var/lib/postgresql/8.0/main -c unix_socket_directory=/var/run/postgresql -c config_file=/etc/postgresql/8.0/main/postgresql.conf -c hba_file=/etc/postgresql/8.0/main/pg_hba.conf -c ident_file=/etc/postgresql/8.0/main/pg_ident.conf root 8811 8560 0 19:17 pts/1 00:00:00 grep postmaster what I realized from this is that postmaster uses diferrent .conf files than what I thought. Yet, I changed them too and nothing happened. (The postgresql.conf on this directory had listen_addresses = 'localhost' commented out, but the default is localhost anyway) the result of : netstat -na | grep ':5432' is nothing I suppose that this suggests postmaster is not listening to port 5432. But both postgresql.conf that I have on my system have the line port = 5432