Skip site navigation (1) Skip section navigation (2)

Re: Remote access

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Remote access
Date: 2008-12-05 08:53:52
Message-ID: 20081205085352.GF8219@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: AbubakerDate: 2008-12-05 09:21:59
Subject: Re: Remote access
Previous:From: AbubakerDate: 2008-12-05 08:43:25
Subject: Remote access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group