Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 26FE1650295; Thu, 21 Aug 2008 06:24:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68810-04-3; Thu, 21 Aug 2008 06:24:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from batyskaf.batory.org.pl (mail.batory.org.pl [62.89.72.199]) by postgresql.org (Postfix) with ESMTP id 2651C6502F3; Thu, 21 Aug 2008 06:20:12 -0300 (ADT) Received: from pancernik.batory.org.pl (pancernik.batory.lan [192.168.30.210]) (authenticated bits=0) by batyskaf.batory.org.pl (8.13.8/8.13.8) with ESMTP id m7L9K3vd009103 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 21 Aug 2008 11:20:03 +0200 Message-ID: <48AD3343.5020008@batory.org.pl> Date: Thu, 21 Aug 2008 11:20:03 +0200 From: Tomasz Ostrowski User-Agent: Thunderbird 2.0.0.16 (X11/20080723) MIME-Version: 1.0 To: Shashwat_Nigam CC: "pgsql-general@postgresql.org" , "pgsql-admin@postgresql.org" Subject: Re: Regarding access to a user References: <48ABD192.EE98.0025.0@wicourts.gov> <48AD3037.6060700@batory.org.pl> In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.64 on 192.168.30.2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/104 X-Sequence-Number: 29949 On 2008-08-21 11:12, Shashwat_Nigam wrote: > I had done the same but still the problem is like that the user is > able to access all the databases in the current server. Even the > order is like same and if I comment the second line(all access) then > the error is there. You did issue "pg_ctl reload" or restart postgresql after making changes to pg_hba.conf? http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file. > Please provide solution for the same. Please read the fine manual. Regards Tometzky -- ...although Eating Honey was a very good thing to do, there was a moment just before you began to eat it which was better than when you were... Winnie the Pooh