From: | Abubaker <aabubakersiddiq(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Tino Schwarze <postgresql(at)tisc(dot)de> |
Subject: | Re: Remote access |
Date: | 2008-12-05 09:21:59 |
Message-ID: | 535129.88913.qm@web95105.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)tisc(dot)de> wrote:
From: Tino Schwarze <postgresql(at)tisc(dot)de>
Subject: Re: [ADMIN] Remote access
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Schwarze | 2008-12-05 09:28:34 | Re: Remote access |
Previous Message | Tino Schwarze | 2008-12-05 08:53:52 | Re: Remote access |