Re: Remote access - Mailing list pgsql-admin

From: Abubaker <aabubakersiddiq@yahoo.com>
Subject: Re: [ADMIN] Remote access
To: pgsql-admin@postgresql.org, "Tino Schwarze" <postgresql@tisc.de>
Date: Friday, 5 December, 2008, 1:53 AM

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 toaccess 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 firewalldropping 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ährenerblüht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de mailpref/pgsql-admin

---

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