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@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! Go to http://messenger.yahoo.com/invite/ -- "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
