Lists: | pgsql-admin |
---|
From: | Abubaker <aabubakersiddiq(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Remote access |
Date: | 2008-12-05 08:43:25 |
Message-ID: | 596123.67368.qm@web95113.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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! Go to http://messenger.yahoo.com/invite/
From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Remote access |
Date: | 2008-12-05 08:53:52 |
Message-ID: | 20081205085352.GF8219@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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."
From: | Abubaker <aabubakersiddiq(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Tino Schwarze <postgresql(at)tisc(dot)de> |
Subject: | Re: Remote access |
Date: | 2008-12-05 09:21:59 |
Message-ID: | 535129.88913.qm@web95105.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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(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/
From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Remote access |
Date: | 2008-12-05 09:28:34 |
Message-ID: | 20081205092834.GG8219@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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."
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 09:53:26 |
Message-ID: | 813882.29714.qm@web95109.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/
From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Remote access |
Date: | 2008-12-05 10:24:14 |
Message-ID: | 20081205102414.GH8219@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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."