I restarted my service and the netstat now shows the correct details.
TCP 0.0.0.0:5432 0.0.0.0:0 LISTENING
But its still showing the same error. I am trying to connect with the "Add Server" method in pgAdmin III. I am using postgresql in windows.
Thanks, Abubaker
On Fri, Dec 05, 2008 at 02:51:59PM +0530, Abubaker wrote:
> Thanks for the information. But how do I change the listening ip > address to 0.0.0.0
Simply restart postgres.
Your listen_addresses = '*' in postgresql.conf should do it. I suppose, you forgot to restart postgresql (reload might not be enough).
HTH,
Tino.
> --- 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 restartpostgres > 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/ -- "What we nourish flourishes." - "Was wir nähren erblüht."