Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3B72C2E003E for ; Tue, 19 Feb 2008 06:00:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66101-05 for ; Tue, 19 Feb 2008 06:00:33 -0400 (AST) Received: from vastu8.nic.in (unknown [164.100.10.14]) by postgresql.org (Postfix) with ESMTP id 3FF4E2E003B for ; Tue, 19 Feb 2008 06:00:31 -0400 (AST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnoUAL03ukfAqAFF/2dsb2JhbAAICYJgmxWPaw X-IronPort-AV: E=McAfee;i="5200,2160,5232"; a="792411" X-IronPort-AV: E=Sophos;i="4.25,375,1199644200"; d="scan'208,217";a="792411" Received: from unknown (HELO mail.nic.in) ([192.168.1.69]) by int.nic.in with ESMTP; 19 Feb 2008 15:27:37 +0530 MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_aDDPQCNoY1OAhxF/Y5p5Hg)" Received: from msgfe1.nic.in ([127.0.0.1]) by msgfe1.nic.in (Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug 3 2007; 32bit)) with ESMTP id <0JWH006BGCZLWY20@msgfe1.nic.in> for pgsql-admin@postgresql.org; Tue, 19 Feb 2008 15:27:21 +0530 (IST) Received: from nic.in ([10.1.150.17]) by msgfe1.nic.in (Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug 3 2007; 32bit)) with ESMTPA id <0JWH001GRCZLJ350@msgfe1.nic.in> for pgsql-admin@postgresql.org; Tue, 19 Feb 2008 15:27:21 +0530 (IST) Received: from [10.1.150.17] by msgfe1.nic.in (mshttpd); Tue, 19 Feb 2008 14:57:21 +0500 From: nalini To: "Mehlape, Makgati" Cc: Dan King , pgsql-admin@postgresql.org Message-id: <69994452a8d5057.47baee51@nic.in> Date: Tue, 19 Feb 2008 14:57:21 +0500 X-Mailer: Sun Java(tm) System Messenger Express 6.3-4.01 (built Aug 3 2007; 32bit) Content-language: en Subject: Re: Can't connect from computer on network. X-Accept-Language: en In-reply-to: <6A4EAA8FBBA19B4D840721B7A2419D4F44D177C6@fnbcolmx01.fnb.co.za> References: <6A4EAA8FBBA19B4D840721B7A2419D4F44D177C6@fnbcolmx01.fnb.co.za> X-TM-AS-Product-Ver: IMSS-7.0.0.3116-5.0.0.1023-15738.003 X-TM-AS-User-Approved-Sender: Yes X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.13 tagged_above=0 required=5 tests=AWL=-1.868, HTML_MESSAGE=0.001, HTTPS_IP_MISMATCH=2.896, NORMAL_HTTP_TO_IP=0.001, RDNS_NONE=0.1 X-Spam-Level: * X-Archive-Number: 200802/205 X-Sequence-Number: 28279 This is a multi-part message in MIME format. --Boundary_(ID_aDDPQCNoY1OAhxF/Y5p5Hg) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable Content-disposition: inline * in postgresql=2Econf actually denotes the network interfaces on the ma= chine on which the postgresql server is running=2E If you wish to limit access to certain IPs do it in pg=5Fhba=2Econf=2E ----- Original Message ----- From=3A =22Mehlape=2C Makgati=22 =3CMMehlape1=40fnb=2Eco=2Eza=3E Date=3A Tuesday=2C February 19=2C 2008 3=3A12 pm Subject=3A Re=3A =5BADMIN=5D Can=27t connect from computer on network=2E= To=3A Dan King =3Cdanking12=40gmail=2Ecom=3E=2C pgsql-admin=40postgresql= =2Eorg =3E = =3E = =3E = =3E = =3E = =3E = =3E =3Cbr=3E =3E =3C!-- /* Font Definitions */ =40font-face =7Bfont-family=3ATahoma=3B= panose-1=3A2 11 6 4 3 5 4 4 2 4=3B=7D /* Style Definitions */ p=2EMsoNo= rmal=2C li=2EMsoNormal=2C div=2EMsoNormal =7Bmargin=3A0in=3B margin-bott= om=3A=2E0001pt=3B font-size=3A12=2E0pt=3B font-family=3A=22Times New Rom= an=22=3B=7Da=3Alink=2C span=2EMsoHyperlink =7Bcolor=3Ablue=3B text-decor= ation=3Aunderline=3B=7Da=3Avisited=2C span=2EMsoHyperlinkFollowed =7Bcol= or=3Ablue=3B text-decoration=3Aunderline=3B=7Dspan=2EEmailStyle17 =7Bmso= -style-type=3Apersonal-reply=3B font-family=3AArial=3B color=3Anavy=3B=7D= =40page Section1 =7Bsize=3A8=2E5in 11=2E0in=3B margin=3A1=2E0in 1=2E25in= 1=2E0in 1=2E25in=3B=7Ddiv=2ESection1 =7Bpage=3ASection1=3B=7D--=3E=3Cbr= =3E =3E = =3E = =3E = =3E = =3E = =3E = =3E = =3E = =3E Hi=2E =3E = =3E =A0 =3E = =3E I think setting Listen=5Faddress to *=2C does =3E not necessary allows all connections but allows your PostgreSQL serv= er to =3E support TCP/IP connections=2E So=2C leave it as it is=2E =3E = =3E =A0 =3E = =3E In order to apply control over what =3E machine IP addresses should connect remotely to your server=3B speci= fy the IP =3E addresses in the pg=5Fhba=2Econf file=2E =3E = =3E =A0 =3E = =3E e=2Eg =3E = =3E =A0 =3E = =3E =23 TYPE=A0 DATABASE=A0=A0=A0 USER=A0=A0=A0=A0=A0=A0=A0 =3E CIDR-ADDRESS=A0=A0=A0=A0=A0=A0=A0=A0=A0 METHOD =3E = =3E =A0 =3E = =3E =A0Host =A0=A0=A0=A0=3CDBname=3E=A0=A0=A0 DKing=A0=A0=A0=A0=A0=A0=A0= =3E 192=2E168=2E2=2E102=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =3CSpecifies user Authentication=3E =3E = =3E =A0 =3E = =3E Make sure you restart your PostgreSQL =3E serve after performing the above=2E = =3E = =3E =A0 =3E = =3E Hope this helps=2E =3E = =3E =A0 =3E = =3E Makgati=2E =3E = =3E =A0 =3E = =3E = =3E = =3E = =3E = =3E = =3E = =3E = =3E = =3E From=3A =3E pgsql-admin-owner=40postgresql=2Eorg =5Bmailto=3Apgsql-admin-owner=40= postgresql=2Eorg=5D On Behalf Of Dan King =3E = =3E Sent=3A Tuesday=2C February 19=2C 2008 =3E 11=3A27 AM =3E = =3E To=3A pgsql-admin=40postgresql=2Eorg =3E = =3E Subject=3A =5BADMIN=5D Can=27t connect =3E from computer on network=2E =3E = =3E = =3E = =3E =A0 =3E = =3E Hi list=2C =3E = =3E = =3E = =3E I am using postgresql 8=2E2 on Ubuntu Gutsy=2E I am attempting to co= nnect to my =3E database on one computer from another computer on my network=2E I ca= n connect to =3E the database if I have=3A =3E = =3E = =3E = =3E listen=5Faddresses =3D =27*=27 =3E = =3E = =3E = =3E in my postgresql=2Econf file=2E But I can=27t connect if I have=3A =3E = =3E = =3E = =3E listen=5Faddresses =3D =27localhost=2C 192=2E168=2E2=2E102=27 =3E = =3E = =3E = =3E in my postgresql=2Econf file=2E The computer that is assigned 192=2E= 168=2E2=2E102 is the computer I am attempting =3E to connect from that works with the * but not with an assigned IP ad= dress=2E I =3E understand that having a * allows all connections but I am attemptin= g to =3E restrict this so only a certain computer can access the database=2E =3E = =3E = =3E = =3E Does anyone know why I can=27t connect to the database from another = computer when =3E specifying the IP address in =27listen=5Faddresses=27 and how to fix= my problem=3F =3E = =3E = =3E = =3E Thanks a lot for the help=2E =3E = =3E = =3E = =3E Dan =3E = =3E = =3E = =3E = =3E = =3E To read FirstRand = =3E Bank=27s Disclaimer for this email click on the following address or= copy into = =3E your Internet browser=3A = =3E https=3A//www=2Efnb=2Eco=2Eza/disclaimer=2Ehtml = =3E = =3E If you are unable to = =3E access the Disclaimer=2C send a blank e-mail to firstrandbankdisclai= mer=40fnb=2Eco=2Eza = =3E and we will send you a copy of the Disclaimer=2E =3E = =3E = =3E = =3E = =3E = Nalini S=2E Nautiyal System Software Division NIC HQ New Delhi Ph 24360324=2C24305121=2C24305131 --Boundary_(ID_aDDPQCNoY1OAhxF/Y5p5Hg) Content-type: text/html; charset=us-ascii Content-transfer-encoding: quoted-printable Content-disposition: inline * in postgresql=2Econf actually denotes the network interfaces on the ma= chine on which the postgresql server is running=2E=3Cbr=3E=3Cbr=3EIf you= wish to limit access to certain IPs do it in pg=5Fhba=2Econf=2E=3Cbr=3E= =3Cbr=3E=3Cbr=3E----- Original Message -----=3Cbr=3EFrom=3A =22Mehlape=2C= Makgati=22 =26lt=3BMMehlape1=40fnb=2Eco=2Eza=26gt=3B=3Cbr=3EDate=3A Tue= sday=2C February 19=2C 2008 3=3A12 pm=3Cbr=3ESubject=3A Re=3A =5BADMIN=5D= Can=27t connect from computer on network=2E=3Cbr=3ETo=3A Dan King =26lt= =3Bdanking12=40gmail=2Ecom=26gt=3B=2C pgsql-admin=40postgresql=2Eorg=3Cb= r=3E=3Cbr=3E=26gt=3B =3Cspan xmlns=3Av=3D=22urn=3Aschemas-microsoft-com=3A= vml=22 xmlns=3Ao=3D=22urn=3Aschemas-microsoft-com=3Aoffice=3Aoffice=22 x= mlns=3Aw=3D=22urn=3Aschemas-microsoft-com=3Aoffice=3Aword=22 xmlns=3D=22= http=3A//www=2Ew3=2Eorg/TR/REC-html40=22=3E=3Cp=3E=3Cbr=3E=26gt=3B =3Cbr= =3E=26gt=3B =3Cbr=3E=26gt=3B =3Cmeta http-equiv=3D=22Content-Type=22 con= tent=3D=22text/html=3B charset=3Dus-ascii=22=3E=3Cbr=3E=26gt=3B =3Cmeta = name=3D=22Generator=22 content=3D=22Microsoft Word 11 (filtered medium)=22= =3E=3Cbr=3E=26gt=3B =3C!--=5Bif !mso=5D=3E=3CBR=3E=3E =3Cstyle=3E=3CBR=3E= =3E v=5C=3A* =7Bbehavior=3Aurl(=23default=23VML)=3B=7D=3CBR=3E=3E o=5C=3A= * =7Bbehavior=3Aurl(=23default=23VML)=3B=7D=3CBR=3E=3E w=5C=3A* =7Bbehav= ior=3Aurl(=23default=23VML)=3B=7D=3CBR=3E=3E =2Eshape =7Bbehavior=3Aurl(= =23default=23VML)=3B=7D=3CBR=3E=3E =3C/style=3E=3CBR=3E=3E =3C!=5Bendif=5D= --=3E=3Cbr=3E=26gt=3B =3Cstyle=3E=3CBR=3E=3E =3C!-- /* Font Definitions = */ =40font-face =7Bfont-family=3ATahoma=3B panose-1=3A2 11 6 4 3 5 4 4 2= 4=3B=7D /* Style Definitions */ p=2EMsoNormal=2C li=2EMsoNormal=2C div=2E= MsoNormal =7Bmargin=3A0in=3B margin-bottom=3A=2E0001pt=3B font-size=3A12= =2E0pt=3B font-family=3A=22Times New Roman=22=3B=7Da=3Alink=2C span=2EMs= oHyperlink =7Bcolor=3Ablue=3B text-decoration=3Aunderline=3B=7Da=3Avisit= ed=2C span=2EMsoHyperlinkFollowed =7Bcolor=3Ablue=3B text-decoration=3Au= nderline=3B=7Dspan=2EEmailStyle17 =7Bmso-style-type=3Apersonal-reply=3B = font-family=3AArial=3B color=3Anavy=3B=7D=40page Section1 =7Bsize=3A8=2E= 5in 11=2E0in=3B margin=3A1=2E0in 1=2E25in 1=2E0in 1=2E25in=3B=7Ddiv=2ESe= ction1 =7Bpage=3ASection1=3B=7D--=3E=3CBR=3E=3E =3C/style=3E=3Cbr=3E=26g= t=3B =3C!--=5Bif gte mso 9=5D=3E=3Cxml=3E=3CBR=3E=3E =3Co=3Ashapedefault= s v=3Aext=3D=22edit=22 spidmax=3D=221026=22 /=3E=3CBR=3E=3E =3C/xml=3E=3C= !=5Bendif=5D--=3E=3C!--=5Bif gte mso 9=5D=3E=3Cxml=3E=3CBR=3E=3E =3Co=3A= shapelayout v=3Aext=3D=22edit=22=3E=3CBR=3E=3E =3Co=3Aidmap v=3Aext=3D=22= edit=22 data=3D=221=22 /=3E=3CBR=3E=3E =3C/o=3Ashapelayout=3E=3C/xml=3E=3C= !=5Bendif=5D--=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3C/= p=3E=3Cp=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3C/p=3E=3Cdiv class=3D=22S= ection1=22=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal= =22=3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3C= span style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B color=3A na= vy=3B=22=3EHi=2E=3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3C= br=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont co= lor=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22= font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E=3Co=3A= p=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B= =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy= =22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A = 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3EI think setting Li= sten=5Faddress to *=2C does=3Cbr=3E=26gt=3B not necessary allows all con= nections but allows your PostgreSQL server to=3Cbr=3E=26gt=3B support TC= P/IP connections=2E So=2C leave it as it is=2E=3Co=3Ap=3E=3C/o=3Ap=3E=3C= /span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D= =22MsoNormal=22=3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=22= 2=22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B c= olor=3A navy=3B=22=3E=3Co=3Ap=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/fon= t=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22= =3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspa= n style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B= =22=3EIn order to apply control over what=3Cbr=3E=26gt=3B machine IP add= resses should connect remotely to your server=3B specify the IP=3Cbr=3E=26= gt=3B addresses in the pg=5Fhba=2Econf file=2E=3Co=3Ap=3E=3C/o=3Ap=3E=3C= /span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D= =22MsoNormal=22=3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=22= 2=22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B c= olor=3A navy=3B=22=3E=3Co=3Ap=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/fon= t=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22= =3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspa= n style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B= =22=3Ee=2Eg=3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E= =26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D= =22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-s= ize=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E=3Co=3Ap=3E= =26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3C= br=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy=22 = face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A 10pt= =3B font-family=3A Arial=3B color=3A navy=3B=22=3E=23 TYPE=26nbsp=3B DAT= ABASE=26nbsp=3B=26nbsp=3B=26nbsp=3B USER=26nbsp=3B=26nbsp=3B=26nbsp=3B=26= nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=3Cbr=3E=26gt=3B CIDR-ADDRESS=26nbs= p=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B= =26nbsp=3B METHOD=3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3C= br=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont co= lor=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22= font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E=3Co=3A= p=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B= =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy= =22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A = 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E=26nbsp=3BHost =26= nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26lt=3BDBname=26gt=3B=26nbsp=3B=26= nbsp=3B=26nbsp=3B DKing=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B= =26nbsp=3B=26nbsp=3B=3Cbr=3E=26gt=3B 192=2E168=2E2=2E102=26nbsp=3B=26nbs= p=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B= =26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B=26nbsp=3B =26= lt=3BSpecifies user Authentication=26gt=3B=3Co=3Ap=3E=3C/o=3Ap=3E=3C/spa= n=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22= MsoNormal=22=3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=222= =22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B co= lor=3A navy=3B=22=3E=3Co=3Ap=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font= =3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22= =3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspa= n style=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B= =22=3EMake sure you restart your PostgreSQL=3Cbr=3E=26gt=3B serve after = performing the above=2E =3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C= /p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3C= font color=3D=22navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan styl= e=3D=22font-size=3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E= =3Co=3Ap=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26= gt=3B =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22= navy=22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size= =3A 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3EHope this help= s=2E=3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B= =3Cbr=3E=26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy= =22 face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A = 10pt=3B font-family=3A Arial=3B color=3A navy=3B=22=3E=3Co=3Ap=3E=26nbsp= =3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26= gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy=22 face=3D=22= Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-f= amily=3A Arial=3B color=3A navy=3B=22=3EMakgati=2E=3Co=3Ap=3E=3C/o=3Ap=3E= =3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cp cla= ss=3D=22MsoNormal=22=3E=3Cfont color=3D=22navy=22 face=3D=22Arial=22 siz= e=3D=222=22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-family=3A Ari= al=3B color=3A navy=3B=22=3E=3Co=3Ap=3E=26nbsp=3B=3C/o=3Ap=3E=3C/span=3E= =3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cdiv=3E=3Cbr=3E=26= gt=3B =3Cbr=3E=26gt=3B =3Cdiv class=3D=22MsoNormal=22 style=3D=22text-al= ign=3A center=3B=22 align=3D=22center=22=3E=3Cfont face=3D=22Times New R= oman=22 size=3D=223=22=3E=3Cspan style=3D=22font-size=3A 12pt=3B=22=3E=3C= br=3E=26gt=3B =3Cbr=3E=26gt=3B =3Chr tabindex=3D=22-1=22 align=3D=22cent= er=22 size=3D=222=22 width=3D=22100=25=22=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26= gt=3B =3C/span=3E=3C/font=3E=3C/div=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B = =3Cp class=3D=22MsoNormal=22=3E=3Cb=3E=3Cfont face=3D=22Tahoma=22 size=3D= =222=22=3E=3Cspan style=3D=22font-size=3A 10pt=3B font-family=3A Tahoma=3B= font-weight=3A bold=3B=22=3EFrom=3A=3C/span=3E=3C/font=3E=3C/b=3E=3Cfon= t face=3D=22Tahoma=22 size=3D=222=22=3E=3Cspan style=3D=22font-size=3A 1= 0pt=3B font-family=3A Tahoma=3B=22=3E=3Cbr=3E=26gt=3B pgsql-admin-owner=40= postgresql=2Eorg =5Bmailto=3Apgsql-admin-owner=40postgresql=2Eorg=5D =3C= b=3E=3Cspan style=3D=22font-weight=3A bold=3B=22=3EOn Behalf Of =3C/span= =3E=3C/b=3EDan King=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cb=3E=3Cspan styl= e=3D=22font-weight=3A bold=3B=22=3ESent=3A=3C/span=3E=3C/b=3E Tuesday=2C= February 19=2C 2008=3Cbr=3E=26gt=3B 11=3A27 AM=3Cbr=3E=26gt=3B =3Cbr=3E= =26gt=3B =3Cb=3E=3Cspan style=3D=22font-weight=3A bold=3B=22=3ETo=3A=3C/= span=3E=3C/b=3E pgsql-admin=40postgresql=2Eorg=3Cbr=3E=26gt=3B =3Cbr=3E=26= gt=3B =3Cb=3E=3Cspan style=3D=22font-weight=3A bold=3B=22=3ESubject=3A=3C= /span=3E=3C/b=3E =5BADMIN=5D Can=27t connect=3Cbr=3E=26gt=3B from comput= er on network=2E=3C/span=3E=3C/font=3E=3Co=3Ap=3E=3C/o=3Ap=3E=3C/p=3E=3C= br=3E=26gt=3B =3Cbr=3E=26gt=3B =3C/div=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B= =3Cp class=3D=22MsoNormal=22=3E=3Cfont face=3D=22Times New Roman=22 siz= e=3D=223=22=3E=3Cspan style=3D=22font-size=3A 12pt=3B=22=3E=3Co=3Ap=3E=26= nbsp=3B=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt=3B =3Cbr=3E= =26gt=3B =3Cp class=3D=22MsoNormal=22=3E=3Cfont face=3D=22Times New Roma= n=22 size=3D=223=22=3E=3Cspan style=3D=22font-size=3A 12pt=3B=22=3EHi li= st=2C=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B= I am using postgresql 8=2E2 on Ubuntu Gutsy=2E I am attempting to conne= ct to my=3Cbr=3E=26gt=3B database on one computer from another computer = on my network=2E I can connect to=3Cbr=3E=26gt=3B the database if I have= =3A=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B l= isten=5Faddresses =3D =27*=27=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26= gt=3B =3Cbr=3E=26gt=3B in my postgresql=2Econf file=2E But I can=27t con= nect if I have=3A=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cb= r=3E=26gt=3B listen=5Faddresses =3D =27localhost=2C 192=2E168=2E2=2E102=27= =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B in m= y postgresql=2Econf file=2E The computer that is assigned =3Ca href=3D=22= http=3A//192=2E168=2E2=2E102=22 target=3D=221=22=3E192=2E168=2E2=2E102 i= s the computer I am attempting=3Cbr=3E=26gt=3B to connect from that work= s with the * but not with an assigned IP address=2E I=3Cbr=3E=26gt=3B un= derstand that having a * allows all connections but I am attempting to=3C= br=3E=26gt=3B restrict this so only a certain computer can access the da= tabase=2E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26g= t=3B Does anyone know why I can=27t connect to the database from another= computer when=3Cbr=3E=26gt=3B specifying the IP address in =27listen=5F= addresses=27 and how to fix my problem=3F=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B= =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B Thanks a lot for the help=2E=3Cbr=3E=26= gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B Dan=3Co=3Ap=3E=3C= /o=3Ap=3E=3C/a=3E=3C/span=3E=3Ca href=3D=22http=3A//192=2E168=2E2=2E102=22= target=3D=221=22=3E=3C/a=3E=3C/font=3E=3C/p=3E=3Ca href=3D=22http=3A//1= 92=2E168=2E2=2E102=22 target=3D=221=22=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B= =3C/a=3E=3C/div=3E=3Ca href=3D=22http=3A//192=2E168=2E2=2E102=22 target= =3D=221=22=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cfont = face=3D=22Times New Roman=22 size=3D=223=22=3E=3Cspan style=3D=22font-si= ze=3A 12pt=3B=22 lang=3D=22EN-US=22=3E=3Cbr=3E=26gt=3B =3Cp class=3D=22M= soNormal=22 style=3D=22margin=3A 0cm 0cm 0pt 36pt=3B=22 align=3D=22left=22= =3E=3Cfont face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-s= ize=3A 10pt=3B font-family=3A Arial=3B=22=3ETo read FirstRand =3Cbr=3E=26= gt=3B Bank=27s Disclaimer for this email click on the following address = or copy into =3Cbr=3E=26gt=3B your Internet browser=3A =3Cbr=3E=26gt=3B = https=3A//www=2Efnb=2Eco=2Eza/disclaimer=2Ehtml =3Cbr=3E=26gt=3B =3Cbr s= tyle=3D=22=22=3E=3Cbr style=3D=22=22=3E=3C/span=3E=3C/font=3E=3C/p=3E=3C= O=3AP=3E=3C/O=3AP=3E=3C/span=3E=3Cfont face=3D=22Arial=22 size=3D=222=22= =3E=3C/font=3E=3Cfont face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D= =22font-size=3A 10pt=3B font-family=3A Arial=3B=22=3E=3Cbr=3E=26gt=3B =3C= p class=3D=22MsoNormal=22 style=3D=22margin=3A 0cm 0cm 0pt 36pt=3B=22=3E= =3Cfont face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-size= =3A 10pt=3B font-family=3A Arial=3B=22=3EIf you are unable to =3Cbr=3E=26= gt=3B access the Disclaimer=2C send a blank e-mail to =3C/span=3E=3C/fon= t=3E=3Cfont face=3D=22Arial=22 size=3D=222=22=3E=3Cspan style=3D=22font-= size=3A 10pt=3B font-family=3A Arial=3B=22=3Efirstrandbankdisclaimer=40f= nb=2Eco=2Eza =3Cbr=3E=26gt=3B and we will send you a copy of the Disclai= mer=2E=3Co=3Ap=3E=3C/o=3Ap=3E=3C/span=3E=3C/font=3E=3C/p=3E=3Cbr=3E=26gt= =3B =3Cp class=3D=22MsoNormal=22 style=3D=22margin=3A 0cm 0cm 0pt 36pt=3B= =22 align=3D=22left=22=3E=3C/p=3E=3C/span=3E=3C/font=3E=3C/font=3E=3C/a=3E= =3C/span=3E=3Cp=3E=3C/p=3E=3Ca href=3D=22http=3A//192=2E168=2E2=2E102=22= target=3D=221=22=3E=3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3Cbr=3E=26gt=3B =3C= br=3E=26gt=3B =3Cbr=3E=3Cbr=3ENalini S=2E Nautiyal=3Cbr=3ESystem Softwar= e Division=3Cbr=3ENIC HQ=3Cbr=3ENew Delhi=3Cbr=3EPh 24360324=2C24305121=2C= 24305131=3Cbr=3E=3Cbr=3E=3C/a=3E --Boundary_(ID_aDDPQCNoY1OAhxF/Y5p5Hg)--