Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 642BF9FB88A for ; Tue, 13 Feb 2007 18:05:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 34775-05 for ; Tue, 13 Feb 2007 18:05:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id 1F9749FB883 for ; Tue, 13 Feb 2007 18:05:36 -0400 (AST) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 989311D48444; Wed, 14 Feb 2007 09:05:33 +1100 (EST) Received: from [172.17.2.14] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 93A6E1D48439; Wed, 14 Feb 2007 09:05:31 +1100 (EST) Message-ID: <45D235ED.6020904@autoledgers.com.au> Date: Wed, 14 Feb 2007 07:04:29 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: gpio Oxxce CC: pgsql-admin@postgresql.org Subject: Re: possible Bug in windows version ? References: <20070213171928.72969.qmail@web27908.mail.ukl.yahoo.com> In-Reply-To: <20070213171928.72969.qmail@web27908.mail.ukl.yahoo.com> Content-Type: text/plain; charset=ISO-8859-7; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.154 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200702/183 X-Sequence-Number: 24648 gpio Oxxce wrote: > Hi all, > > After downloading and installing the latest Postgresql server > (postgresql-8.2.3-1.zip > ) > I can not make it accept local IP connections! > I edit the |pg_hba.conf |file with > > host all all 192.168.100.1/32 trust > > but still I can't connect from 192.168.100.1 to the DB. > Also during the installation I checked the option "Accept TCP > connections.." (or something like that) > > Am I missing something or it is a possible bug ? > > Thanks > George > In putting in the above line did you replace the host line with address "127.0.0.1/32"? If so, that's probably your problem - it needs the 127* line. Is postmaster listening on the default port (5432) or did you change that during install? (Can check that in the postgresql.conf file in the same place as pg_hba.conf) How are you trying to connect? (pgAdminIII, some other program using the ODBC driver?) What error are you getting? NB: I get access denied if I put my servers IP address into the pg_hba.conf file and comment out the existing 127 address line. Local connections would not go out through the network and would thus not be seen by PG as coming from your 192/168 address. P. -- Paul Lambert Database Administrator AutoLedgers