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 A560D9DCC14 for ; Mon, 20 Mar 2006 06:31:52 -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 45031-02 for ; Mon, 20 Mar 2006 06:31:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from blaster.systems.pipex.net (blaster.systems.pipex.net [62.241.163.7]) by postgresql.org (Postfix) with ESMTP id 667639DCC2E for ; Mon, 20 Mar 2006 06:31:50 -0400 (AST) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by blaster.systems.pipex.net (Postfix) with ESMTP id EC201E000099 for ; Mon, 20 Mar 2006 10:31:51 +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 1FLHfy-0004Lb-OU for pgsql-admin@postgresql.org; Mon, 20 Mar 2006 10:31:50 +0000 Message-ID: <441E8498.1050902@edesix.com> Date: Mon, 20 Mar 2006 10:31:52 +0000 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> <01e301c64c03$73922bd0$cd00000a@sandhyar> In-Reply-To: <01e301c64c03$73922bd0$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.214 required=5 tests=[AWL=0.025, MISSING_HEADERS=0.189] X-Spam-Score: 0.214 X-Spam-Level: X-Archive-Number: 200603/163 X-Sequence-Number: 20920 Sandhya, If you use localhost you will be creating a UNIX domain socket. If you use the IP address you will create a TCP/IP socket. Did you try running with -i yet? It doesn't mean accept remote connections, it means accept TCP/IP connection. Without it, you cannot connect to an IP address ... Robin sandhya wrote: >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 >>> >>> >>> >>> >>> >>> >>> >>> > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: Don't 'kill -9' the postmaster > > > >