From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Remote access
Date: Fri, 5 Dec 2008 09:53:52 +0100
Message-ID: <20081205085352.GF8219@easy2.in-chemnitz.de> (raw)
In-Reply-To: <596123.67368.qm@web95113.mail.in2.yahoo.com>
References: <596123.67368.qm@web95113.mail.in2.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: Remote access
In-Reply-To: <20081205085352.GF8219@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox