Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C277364FCD8 for ; Fri, 5 Dec 2008 06:59:14 -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 79745-02 for ; Fri, 5 Dec 2008 06:59:11 -0400 (AST) X-Greylist: delayed 00:38:02.082165 by SQLgrey-1.7.6 Received: from n2a.bullet.in.yahoo.com (n2a.bullet.in.yahoo.com [202.43.219.19]) by mail.postgresql.org (Postfix) with SMTP id CFB9964FC6F for ; Fri, 5 Dec 2008 06:57:56 -0400 (AST) Received: from [202.86.4.170] by n2.bullet.in.yahoo.com with NNFMP; 05 Dec 2008 10:19:54 -0000 Received: from [203.104.17.88] by t1.bullet.in.yahoo.com with NNFMP; 05 Dec 2008 10:09:42 -0000 Received: from [127.0.0.1] by omp102.mail.in2.yahoo.com with NNFMP; 05 Dec 2008 10:09:42 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 176022.34332.bm@omp102.mail.in2.yahoo.com Received: (qmail 1652 invoked by uid 60001); 5 Dec 2008 10:09:42 -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:MIME-Version:Content-Type:Message-ID; b=Sea8ePUbe5OpxGzdAQc6HwDzKpZtiybGnVQUgW2rQVqsOH4QFVS/XS2ZgKBnK016hYwwasP7kXH5EkeX1sLNMof0NCS8bIgn6Zb0FwLnKqwuXHUeD2FVPCQIMKVNvHZ7Lg78rK8tL+t2+Bot3Zh4rFIcd5nam9XTxTfrfUup5YQ=; X-YMail-OSG: YZCoxqAVM1nY.0gs1kS30j0DLxVKGARSKh74.IL3dh1fqPLByv.uUTKNsNMJS1I77wb6Rjyw7mNPgChd_eCZBqopkomVEVw2qrouT2vpIAHRjTfp5PqLqfwdTLExXazdC_4yaWwZYn9vZKsVWUuOsD3f3HfmGdHZgnsjbxhK6v_2ua9uiWfDkS0F0b.B6o9hx4PQ2Ok5.Uft1koqmgU3bgWqEAWqHQEBpeLQq8Vei652UGss Received: from [59.96.20.115] by web95105.mail.in2.yahoo.com via HTTP; Fri, 05 Dec 2008 15:39:41 IST X-Mailer: YahooMailWebService/0.7.260.1 Date: Fri, 5 Dec 2008 15:39:41 +0530 (IST) From: Abubaker Subject: Re: Remote access To: pgsql-admin@postgresql.org, Tino Schwarze MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1547384379-1228471781=:97495" Message-ID: <953133.97495.qm@web95105.mail.in2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.82 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=1.819 X-Spam-Level: * X-Archive-Number: 200812/73 X-Sequence-Number: 30906 --0-1547384379-1228471781=:97495 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Its working now..=20 Thanks :) --- On Fri, 5/12/08, Abubaker wrote: From: Abubaker Subject: Re: [ADMIN] Remote access To: pgsql-admin@postgresql.org, "Tino Schwarze" 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 =3D '*' 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 wrote: > From: Tino Schwarze > Subject: Re: [ADMIN] Remote access > To: pgsql-admin(at)postgresql(dot)org > Date: Friday, 5 December, 2008, 12:53 AM >=20 > Hi, >=20 > > 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). I= s > the server running on host "XX.XX.XX.XX" and accepting TCP/IP > connections on port 5432? > >=20 > [...] >=20 > > My postgresql.conf file line: > >=20 > > listen_addresses =3D '*' >=20 > correct. >=20 > > 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 >=20 > Not correct. It should display 0.0.0.0:5432. Did you restart postgres > after you changed postgresql.conf? >=20 > > I have disabled all the firewall. Can someone help me with this error? >=20 > 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. >=20 > HTH, >=20 > Tino. >=20 > --=20 > "What we nourish flourishes." - "Was wir n=C3=A4hren erbl=C3=BCht." >=20 > www.lichtkreis-chemnitz.de > www.craniosacralzentrum.de >=20 > --=20 > 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 >=20 >=20 >=20 > Add more friends to your messenger and enjoy! Go to http://messenge= r.yahoo.com/invite/ --=20 "What we nourish flourishes." - "Was wir n=C3=A4hren erbl=C3=BCht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de mailpref/pgsql-admin Add more friends to your messenger and enjoy! Invite them now.=0A= =0A=0A Add more friends to your messenger and enjoy! Go to http://mess= enger.yahoo.com/invite/ --0-1547384379-1228471781=:97495 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Its working now..

Thanks :)

--= - On Fri, 5/12/08, Abubaker <aabubakersiddiq@yahoo.com>= wrote:
From: Abubaker <aabubakersiddiq@yaho= o.com>
Subject: Re: [ADMIN] Remote access
To: pgsql-admin@postgres= ql.org, "Tino Schwarze" <postgresql@tisc.de>
Date: Friday, 5 Decem= ber, 2008, 1:53 AM

I restarted my servi=
ce and the netstat now shows the correct details.

  TCP    0.0.0.0:5=
432         =20
 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 Fr=
i, 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 =3D =
'*'
in postgresql.conf should do it. I suppose, you forgot to restartpostgresql (reload might not be enough).

HTH,

Tino.

&=
gt; --- On Fri, 5/12/08, Tino Schwarze <postgresql(at)tisc(dot)de> wr=
ote:
> From: Tino Schwarze <postgresql(at)tisc(dot)de>
> =
Subject: Re:
 [ADMIN] Remote access
> To: pgsql-admin(at)postgresq=
l(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" an=
d accepting TCP/IP
> connections on port 5432?
> > 
> =
[...]
> 
> > My postgresql.conf file line:
> > 
=
> > listen_addresses =3D '*'
> 
> correct.
> 
&g=
t; > Netstat details:
> > TCP    127.0.0.1:5432&=
nbsp;       
> 0.0.0.0:0 &nbs=
p;            LISTEN=
ING
> 
> Not correct. It should display 0.0.0.0:5432. Did you r=
estart
 postgres
> after you changed postgresql.conf?
> 
=
> > I have disabled all the firewall. Can someone help me with this e=
rror?
> 
> Connection timed out sounds like a firewall
 dropping packets, though. It
> should be "Connection refused". But t=
ry to make it listen on 0.0.0.0
> first.
> 
> HTH,
>=
; 
> Tino.
> 
> -- 
> "What we nourish flourishes."=
 - "Was wir n=C3=A4hren erbl=C3=BCht."
> 
> www.lichtkreis-chem=
nitz.de
> www.craniosacralzentrum.de
> 
> -- 
> Sen=
t 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://me=
ssenger.yahoo.com/invite/
-- 
"What we nourish flourishes." - "Wa=
s wir n=C3=A4hren
 erbl=C3=BCht."

www.lichtkreis-chemnitz.de
www.craniosacralzentru=
m.de
mailpref/pgsql-admin
<= /blockquote>

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

=0A
Add mor= e friends to your messenger and enjoy! Invite them now. --0-1547384379-1228471781=:97495--