Re: Remote access - Mailing list pgsql-admin

From Abubaker
Subject Re: Remote access
Date
Msg-id 535129.88913.qm@web95105.mail.in2.yahoo.com
Whole thread Raw
In response to Re: Remote access  (Tino Schwarze <postgresql@tisc.de>)
List pgsql-admin
Hi,
Thanks for the information. But how do I change the listening ip address to 0.0.0.0

Thanks again,
Abubaker

--- On Fri, 5/12/08, Tino Schwarze <postgresql@tisc.de> wrote:
From: Tino Schwarze <postgresql@tisc.de>
Subject: Re: [ADMIN] Remote access
To: pgsql-admin@postgresql.org
Date: Friday, 5 December, 2008, 12:53 AM

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to yoursubscription:
http://www.postgresql.org/mailpref/pgsql-admin


Add more friends to your messenger and enjoy! Invite them now.

pgsql-admin by date:

Previous
From: Abubaker
Date:
Subject: Re: Remote access
Next
From: Abubaker
Date:
Subject: Re: Remote access