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@xxxxxxx> wrote:
From: Tino Schwarze <postgresql@xxxxxxx> Subject: Re: Remote access To: pgsql-admin@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your
subscription: http://www.postgresql.org/mailpref/pgsql-admin
|
Add more friends to your messenger and enjoy!
Invite them now.