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 3FC7A9DC953 for ; Mon, 20 Mar 2006 04:58:49 -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 08668-09 for ; Mon, 20 Mar 2006 04:58:50 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 552B59DC812 for ; Mon, 20 Mar 2006 04:58:47 -0400 (AST) Received: from ranger.systems.pipex.net (ranger.systems.pipex.net [62.241.162.32]) by svr4.postgresql.org (Postfix) with ESMTP id 747735AF8F6 for ; Mon, 20 Mar 2006 08:58:49 +0000 (GMT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by ranger.systems.pipex.net (Postfix) with ESMTP id A4C1DE00036F; Mon, 20 Mar 2006 08:58:43 +0000 (GMT) Received: from visitor4.edesix.com ([192.168.1.154]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FLGDq-0006HO-M2; Mon, 20 Mar 2006 08:58:43 +0000 Message-ID: <441E6EC1.3070508@edesix.com> Date: Mon, 20 Mar 2006 08:58:41 +0000 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: sandhya Cc: Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> In-Reply-To: <01bd01c64bf7$553bb720$cd00000a@sandhyar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/157 X-Sequence-Number: 20914 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 > > > > > >