Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id D84332E0073 for ; Tue, 1 Apr 2008 11:57:02 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66673-01 for ; Tue, 1 Apr 2008 11:56:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id 59A872E006D for ; Tue, 1 Apr 2008 11:56:54 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 3E1BA47000D for ; Tue, 1 Apr 2008 16:56:52 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dwvDQCNAnLM2 for ; Tue, 1 Apr 2008 16:56:52 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 2CA57470007; Tue, 1 Apr 2008 16:56:52 +0200 (CEST) Date: Tue, 1 Apr 2008 16:56:52 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: connection problems Message-ID: <20080401145652.GE28379@easy2.in-chemnitz.de> References: <00c901c89406$e497d710$0602a8c0@DREAM> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <00c901c89406$e497d710$0602a8c0@DREAM> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/8 X-Sequence-Number: 28772 On Tue, Apr 01, 2008 at 04:44:29PM +0200, Shavonne Marietta Wijesinghe wrote: > I have my postgresql(ver. 8 ) db on one computer (as localhost) and i'm trying to access it from another computer but i get the error > "could not connect to Server: Connection refused" > > I followed the guide and changed the listen_address in the postgresql.conf file > listen_addresses='*' > > and in the pg_hba.conf file I added the IP address of the pc i'm using > host all all 192.168.X.X/32 trust > > But i get the same error. What should i do?? Did you restart the postmaster after setting listen_addresses? Does netstat -tln display the appropiate port listening on *:5432 (or whatever your port number is)? Tino. -- „Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi) www.craniosacralzentrum.de www.forteego.de