X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 23F5C9DC9DF for ; Mon, 20 Mar 2006 05:42:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15865-06 for ; Mon, 20 Mar 2006 05:42:23 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 24F589DC942 for ; Mon, 20 Mar 2006 05:42:20 -0400 (AST) Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by svr4.postgresql.org (Postfix) with ESMTP id 34DB55AF94A for ; Mon, 20 Mar 2006 09:42:16 +0000 (GMT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k2K9ac4X018148; Mon, 20 Mar 2006 15:06:38 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id CE66933266C; Mon, 20 Mar 2006 15:06:38 +0530 (IST) Message-ID: <01e301c64c03$73922bd0$cd00000a@sandhyar> From: "sandhya" To: "Robin Iddon" Cc: "Postgres" References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 15:18:33 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.139 required=5 tests=[AWL=0.138, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.139 X-Spam-Level: X-Archive-Number: 200603/158 X-Sequence-Number: 20915 Thanks Robin. What u said is right! But my problem is i am not trying connecting from any remote client. In my ConnectionInfo if i mention the host as, host=localhost.The connection is successful. But the same if i give my localsystem IP where my server is running.. host = 10.0.2.56(my localhost IP). The Connection is failed. Why is this so?Whether i need to give only localhost in my application (or) why it is not accepting when i gave IP of the same system(When the entry of this IP is already present in pg_hba.conf file)? ----- Original Message ----- From: "Robin Iddon" To: "sandhya" Cc: "Postgres" Sent: Monday, March 20, 2006 2:28 PM Subject: Re: [ADMIN] reg:conninfo > Try looking at the manual for the postmaster process ... > > A simple way of achieving what you want is adding the -i option to the > postmaster command line which allows TCP/IP connections. Otherwise only > localhost can connect. > > There are possibly other ways of configuring this same option, but we > use the -i on the command line to the postmaster process. > > Hope this helps, > > Robin > > sandhya wrote: > > >hi, > > > > I am using postgres8.0.3 on windows.When i am compiling a small sample i am facing problem in connection information. > > > >I have given entry in my pg_hba.conf file: > >host all all 10.0.3.67/32 md5 > > > >And in my application when i pass host in conninfo as, > >host=10.0.3.67...It is not connecting..and throwing error like, > >Is server running on 10.0.0.205..etc > >But when i give as, > >host=localhost..It is running fine. > >After each change i am doing pg_reload. > >What i need to do inorder to mention the IP in my application instead of localhost? > >Please tell me. > > > >Thank you, > >Sandhya > > > > > > > > > > > > >