Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E4ED264FC5E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  5 Dec 2008 04:53:57 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 59290-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  5 Dec 2008 04:53:54 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232])
	by mail.postgresql.org (Postfix) with ESMTP id 92B5E64FC18
	for <pgsql-admin@postgresql.org>; Fri,  5 Dec 2008 04:53:54 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by easy2.in-chemnitz.de (Postfix) with ESMTP id 7E112470009
	for <pgsql-admin@postgresql.org>; Fri,  5 Dec 2008 09:53:52 +0100 (CET)
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 xhf9VcWVNaXn for <pgsql-admin@postgresql.org>;
	Fri,  5 Dec 2008 09:53:52 +0100 (CET)
Received: by easy2.in-chemnitz.de (Postfix, from userid 1013)
	id 6D8FE470005; Fri,  5 Dec 2008 09:53:52 +0100 (CET)
Date: Fri, 5 Dec 2008 09:53:52 +0100
From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Remote access
Message-ID: <20081205085352.GF8219@easy2.in-chemnitz.de>
References: <596123.67368.qm@web95113.mail.in2.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <596123.67368.qm@web95113.mail.in2.yahoo.com>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200812/30
X-Sequence-Number: 30863

Hi,

> I am getting this error when I try to access the database in another computer within the same network.
> 
> could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "XX.XX.XX.XX" and accepting TCP/IP connections on port 5432?
> 
[...]

> My postgresql.conf file line:
> 
> listen_addresses = '*'

correct.

> Netstat details:
> TCP    127.0.0.1:5432         0.0.0.0:0              LISTENING

Not correct. It should display 0.0.0.0:5432. Did you restart postgres
after you changed postgresql.conf?

> I have disabled all the firewall. Can someone help me with this error?

Connection timed out sounds like a firewall dropping packets, though. It
should be "Connection refused". But try to make it listen on 0.0.0.0
first.

HTH,

Tino.

-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de