Skip site navigation (1) Skip section navigation (2)

Re: Remote access

From: Abubaker <aabubakersiddiq(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org, Tino Schwarze <postgresql(at)tisc(dot)de>
Subject: Re: Remote access
Date: 2008-12-05 10:09:41
Message-ID: 953133.97495.qm@web95105.mail.in2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Its working now.. 

Thanks :)

--- On Fri, 5/12/08, Abubaker <aabubakersiddiq(at)yahoo(dot)com> wrote:
From: Abubaker <aabubakersiddiq(at)yahoo(dot)com>
Subject: Re: [ADMIN] Remote access
To: pgsql-admin(at)postgresql(dot)org, "Tino Schwarze" <postgresql(at)tisc(dot)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 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/
-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de
mailpref/pgsql-admin


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


      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

pgsql-admin by date

Next:From: Tino SchwarzeDate: 2008-12-05 10:24:14
Subject: Re: Remote access
Previous:From: AbubakerDate: 2008-12-05 09:53:26
Subject: Re: Remote access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group