Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 79B9464FCF2 for ; Fri, 5 Dec 2008 05:53:36 -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 68616-09 for ; Fri, 5 Dec 2008 05:53:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from n5a.bullet.tw1.yahoo.com (n5a.bullet.tw1.yahoo.com [119.160.244.192]) by mail.postgresql.org (Postfix) with SMTP id A57AA64FC6F for ; Fri, 5 Dec 2008 05:53:32 -0400 (AST) Received: from [119.160.244.77] by n5.bullet.tw1.yahoo.com with NNFMP; 05 Dec 2008 09:53:29 -0000 Received: from [203.212.168.61] by t2.bullet.tw1.yahoo.com with NNFMP; 05 Dec 2008 09:53:28 -0000 Received: from [203.104.17.87] by t2.bullet.kr1.yahoo.com with NNFMP; 05 Dec 2008 09:53:28 -0000 Received: from [127.0.0.1] by omp101.mail.in2.yahoo.com with NNFMP; 05 Dec 2008 09:53:26 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 921876.33632.bm@omp101.mail.in2.yahoo.com Received: (qmail 30294 invoked by uid 60001); 5 Dec 2008 09:53:26 -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:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=csD6aairLZqEEAYpuoug4QtnnQnY13ambga/s9qhTJRHBcgADzhNuorEkgvY5F7p2eZe94On6b+6alt7CZv/zGzG71HU63p3G8bILPWqDX214A6phkSueLFJ1/33/+UVQVZJzJ2mlRlqZlh1UTGmRjYnvIEZMEABCICYTBb/3AY=; X-YMail-OSG: t96GsvYVM1mGxxndhFU3WeEb1MLr1jo8k3HXTeWTXOihoKQtuSi_QaXh6osWMPKIRu4QkLluKnt2TL6oVUEnAGtSgPxrKnXiyIe2F7dMnFQMkd5AcTaOA4PtRzxwMLbm2dL7OVeA6oCmIm1uhxR7ReDaD4QjLK9BVNQ1_PtWOuXViDCBPhZs8moEB1EdUJS00btm0.1PWAPaz.shADTcjOo_sOt05UWi_NtKHEHL1Kqq37PM Received: from [59.96.20.115] by web95109.mail.in2.yahoo.com via HTTP; Fri, 05 Dec 2008 15:23:26 IST X-Mailer: YahooMailWebService/0.7.260.1 Date: Fri, 5 Dec 2008 15:23:26 +0530 (IST) From: Abubaker Subject: Re: Remote access To: pgsql-admin@postgresql.org, Tino Schwarze In-Reply-To: <20081205085352.GF8219@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1992795069-1228470806=:29714" Message-ID: <813882.29714.qm@web95109.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/75 X-Sequence-Number: 30908 --0-1992795069-1228470806=:29714 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 =0A=0A=0A Connect with friends all over the world. Get Yahoo! India Me= ssenger at http://in.messenger.yahoo.com/?wm=3Dn/ --0-1992795069-1228470806=:29714 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 
I restarted my service and the netstat n=
ow 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 in=
formation. But how do I change the listening ip
> address to 0.0.0.0<=
br>
Simply restart postgres.

Your
listen_addresses =3D '*'
=
in postgresql.conf should do it. I suppose, you forgot to restart
postgr=
esql (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 ano=
ther
> computer within the same network.
> > 
> > c=
ould 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 =
=3D '*'
> 
> correct.
> 
> > Netstat details:> > TCP    127.0.0.1:5432    &nbs=
p;   
> 0.0.0.0:0      &=
nbsp;       LISTENING
> 
> Not co=
rrect. 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?
&=
gt; 
> Connection timed out sounds like a firewall dropping packets, =
though. It
> should be "Connection refused". But try to make it liste=
n on 0.0.0.0
> first.
> 
> HTH,
> 
> Tino.> 
> -- 
> "What we nourish flourishes." - "Was wir n=C3=A4=
hren erbl=C3=BCht."
> 
> www.lichtkreis-chemnitz.de
> www=
..craniosacralzentrum.de
> 
> -- 
> Sent via pgsql-admin m=
ailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to =
your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin<=
/a>
> 
> 
> 
>       Add more friends to your messe=
nger and enjoy! Go to http://messenger.yahoo.com/inv=
ite/
-- 
"What we nourish flourishes." - "Was wir n=C3=A4hren erb=
l=C3=BCht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de=

mailpref/pgsql-admin

=0A
Add more = friends to your messenger and enjoy! Invite them now. --0-1992795069-1228470806=:29714--