Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4422F64FCF2 for ; Fri, 5 Dec 2008 06:03:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70878-08 for ; Fri, 5 Dec 2008 06:03:01 -0400 (AST) X-Greylist: delayed 00:05:21.454935 by SQLgrey-1.7.6 Received: from n4-vm0.bullet.mail.in.yahoo.com (n4-vm0.bullet.mail.in.yahoo.com [202.86.5.189]) by mail.postgresql.org (Postfix) with SMTP id 59B0264FC6F for ; Fri, 5 Dec 2008 06:02:59 -0400 (AST) Received: from [202.86.4.171] by n4.bullet.mail.in.yahoo.com with NNFMP; 05 Dec 2008 09:57:34 -0000 Received: from [203.104.18.51] by t2.bullet.in.yahoo.com with NNFMP; 05 Dec 2008 09:48:39 -0000 Received: from [127.0.0.1] by omp112.mail.in2.yahoo.com with NNFMP; 05 Dec 2008 09:48:39 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 150641.83401.bm@omp112.mail.in2.yahoo.com Received: (qmail 90812 invoked by uid 60001); 5 Dec 2008 09:21:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=vpOt59zUgVYJ2pYdKPMbsLhkTx5XuqTzWGASySXSkKfAkNVZBj1EjRPv/XkG+kCgK8rv9OiOmOjVI2xqvBD6yUMac0wBcwb8nnkZgDAvx1ioNhnQzl186R5O2vS2Jh/6XZXlAG+7N6h6SL+nHEaGGt0Jw4YeMF/MVcQr0TY1iGQ=; X-YMail-OSG: Jp0WjTAVM1m4l42raYNd4zHYFhcyOzgm.R74na9RtuwjoBX9HVLsmNITSWz6lrnZkYxIMSLPHAAxrXfeRaut1NgyCQnHvJet0f462kJcLMKxlEuHNIeinlUKWwtDKg89kpvhV0gOLThm8tvWcazQ1oFzM73Ib2UwRcljGe2XYRGMKMLLL99P22_pBkqi8kaNXAfEpNuVDgr9q5meag69vM4cMWfEJHUB0CVLcLzWXHi5eL66 Received: from [59.96.20.115] by web95105.mail.in2.yahoo.com via HTTP; Fri, 05 Dec 2008 14:51:59 IST X-Mailer: YahooMailWebService/0.7.260.1 Date: Fri, 5 Dec 2008 14:51:59 +0530 (IST) From: Abubaker Subject: Re: Remote access To: pgsql-admin@postgresql.org Cc: Tino Schwarze In-Reply-To: <20081205085352.GF8219@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-389650843-1228468919=:88913" Message-ID: <535129.88913.qm@web95105.mail.in2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200812/74 X-Sequence-Number: 30907 --0-389650843-1228468919=:88913 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 wrote: From: Tino Schwarze 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. >=20 > 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? >=20 [...] > My postgresql.conf file line: >=20 > listen_addresses =3D '*' correct. > Netstat details: > TCP=C2=A0=C2=A0=C2=A0 127.0.0.1:5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 0.0.0.0:0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 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. --=20 "What we nourish flourishes." - "Was wir n=C3=A4hren erbl=C3=BCht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin =0A=0A=0A Add more friends to your messenger and enjoy! Go to http://m= essenger.yahoo.com/invite/ --0-389650843-1228468919=:88913 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi,
Thanks for the information. But how do= I change the listening ip address to 0.0.0.0

Thanks again,
Abuba= ker

--- On Fri, 5/12/08, Tino Schwarze <postgresql@tisc.de&= gt; wrote:
From: Tino Schwarze <post= gresql@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 a=
nother
computer within the same network.
> 
> could not conn=
ect to server: Connection timed out (0x0000274C/10060). Is
the server ru=
nning on host "XX.XX.XX.XX" and accepting TCP/IP
connections on port 543=
2?
> 
[...]

> My postgresql.conf file line:
> 
=
>
 listen_addresses =3D '*'

correct.

> Netstat details:
&=
gt; TCP    127.0.0.1:5432      =
;  
0.0.0.0:0        &=
nbsp;     LISTENING

Not correct. It should displ=
ay 0.0.0.0:5432. Did you restart postgres
after you changed postgresql.c=
onf?

> I have disabled all the firewall. Can someone help me with=
 this error?

Connection timed out sounds like a firewall dropping pa=
ckets, though. It
should be "Connection refused". But try to make it lis=
ten on 0.0.0.0
first.

HTH,

Tino.

-- 
"What we no=
urish flourishes." - "Was wir n=C3=A4hren erbl=C3=BCht."

www.lichtkr=
eis-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
<= /blockquote>

=0A
Add m= ore friends to your messenger and enjoy! Invite them now.<= /a> --0-389650843-1228468919=:88913--