Обсуждение: Remote access
| 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? pg_hba.conf changes: host all all 10.30.10.152/32 trust host all all 127.0.0.1/32 md5 host all all 0.0.0.0/0 trust ********************************************************************************** My postgresql.conf file line: listen_addresses = '*' Netstat details: TCP 127.0.0.1:5432 0.0.0.0:0 LISTENING I have disabled all the firewall. Can someone help me with this error? Thanks, Abubaker |
Add more friends to your messenger and enjoy! Invite them now.
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 acceptingTCP/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
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@tisc.de> wrote: > From: Tino Schwarze <postgresql@tisc.de> > Subject: Re: [ADMIN] Remote access > To: pgsql-admin@postgresql.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@postgresql.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
On Fri, Dec 05, 2008 at 03:23:26PM +0530, Abubaker wrote: > I restarted my service and the netstat now shows the correct details. > > TCP 0.0.0.0:5432 0.0.0.0:0 LISTENING Looks good. > 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. Sounds like some firewall inbetween. Open a command line and try the following to check basic network connectivity: 1. ping your_server and if that works 2. telnet your_server 5432 Are you sure you don't have a firewall on the client or inbetween? HTH, Tino. > 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
| Its working now.. Thanks :) --- On Fri, 5/12/08, Abubaker <aabubakersiddiq@yahoo.com> wrote: From: Abubaker <aabubakersiddiq@yahoo.com> |
Add more friends to your messenger and enjoy! Invite them now.
| 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@tisc.de> wrote: From: Tino Schwarze <postgresql@tisc.de> |
Add more friends to your messenger and enjoy! Invite them now.
I restarted my service and the netstat now shows the correct details. mailpref/pgsql-admin |
Add more friends to your messenger and enjoy! Invite them now.