Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3B9D46501C1; Tue, 26 Aug 2008 01:28:41 -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 80073-04; Tue, 26 Aug 2008 01:27:52 -0300 (ADT) Received: from mx2.hub.org (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id B7B2265012D; Tue, 26 Aug 2008 01:27:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from blu0-omc3-s1.blu0.hotmail.com (blu0-omc3-s1.blu0.hotmail.com [65.55.116.76]) by mx2.hub.org (Postfix) with ESMTP id 7A3101E814A9; Tue, 26 Aug 2008 01:24:30 -0300 (ADT) Received: from BLU149-W6 ([65.55.116.73]) by blu0-omc3-s1.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 25 Aug 2008 21:18:02 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_9b016a61-65fc-435f-8456-310c0140c4b8_" X-Originating-IP: [59.160.193.34] From: Vishal Arora To: Scott Marlowe , Shashwat_Nigam CC: "pgsql-admin@postgresql.org" , Kevin Grittner , "pgsql-general@postgresql.org" , "pgsql-sql@postgresql.org" Subject: Re: Regarding access to a user Date: Tue, 26 Aug 2008 09:48:02 +0530 Importance: Normal In-Reply-To: References: <48ABD192.EE98.0025.0@wicourts.gov> MIME-Version: 1.0 X-OriginalArrivalTime: 26 Aug 2008 04:18:02.0261 (UTC) FILETIME=[BAECCC50:01C90732] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/159 X-Sequence-Number: 30004 --_9b016a61-65fc-435f-8456-310c0140c4b8_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable > Date: Mon=2C 25 Aug 2008 11:08:14 -0600> From: scott.marlowe@gmail.com> T= o: Shashwat_Nigam@satyam.com> Subject: Re: [ADMIN] Regarding access to a us= er> CC: aroravishal22@hotmail.com=3B pgsql-admin@postgresql.org=3B Kevin.Gr= ittner@wicourts.gov=3B pgsql-general@postgresql.org=3B pgsql-sql@postgresql= .org> > On Thu=2C Aug 21=2C 2008 at 3:05 AM=2C Shashwat_Nigam> wrote:> > Dear Vishal> >> > Thanks for the help but by doin= g this an error is generated at the time when> > the user is trying to log = in with the following message:> >> > "> >> > Access to database denied> >> = > The server doesn't grant access to the database: the server reports> >> >= FATAL: no pg_hba.conf entry for host "127.0.0.1"=2C user "hmri"=2C databas= e> > "postgres"=2C SSL off> > Notice that it says database postgres??? User= hmri doesn't have> permission to connect to the the postgres database. you= need to> connect to the hmri database. He is using PgAdmin III to connect to the database. When you use pgAdminIII= =2C it has one text field as Maintainance DB - that is by default marked as= Postgres. Now when you make entries for specific user for specific databas= e=2C you get this above error=2C if you do not change the maintainence db t= o the same as the user wants to connect to.=20 =20 =20 >=20 > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)> To m= ake changes to your subscription:> http://www.postgresql.org/mailpref/pgsql= -admin _________________________________________________________________ From salsa lessons to filmy gossip=2C news to music concerts - watch it all= on MSN Video http://video.msn.com/?mkt=3Den-in= --_9b016a61-65fc-435f-8456-310c0140c4b8_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable





>=3B Date: Mon=2C 25 Aug 2008 11:08:14 -0600
>=3B From: scott.marlow= e@gmail.com
>=3B To: Shashwat_Nigam@satyam.com
>=3B Subject: Re: = [ADMIN] Regarding access to a user
>=3B CC: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.org=3B Kevin.Grittner@wicourts.gov=3B pgsql-gene= ral@postgresql.org=3B pgsql-sql@postgresql.org
>=3B
>=3B On Thu= =2C Aug 21=2C 2008 at 3:05 AM=2C Shashwat_Nigam
>=3B <=3BShashwat_Ni= gam@satyam.com>=3B wrote:
>=3B >=3B Dear Vishal
>=3B >=3B>=3B >=3B Thanks for the help but by doing this an error is generated= at the time when
>=3B >=3B the user is trying to log in with the fo= llowing message:
>=3B >=3B
>=3B >=3B "
>=3B >=3B
&g= t=3B >=3B Access to database denied
>=3B >=3B
>=3B >=3B The= server doesn't grant access to the database: the server reports
>=3B = >=3B
>=3B >=3B FATAL: no pg_hba.conf entry for host "127.0.0.1"=2C= user "hmri"=2C database
>=3B >=3B "postgres"=2C SSL off
>=3B <= BR>>=3B Notice that it says database postgres??? User hmri doesn't have>=3B permission to connect to the the postgres database. you need to>=3B connect to the hmri database.

He is using PgAdmin III to connect to the database. When you use pgAdminIII= =2C it has one text field as Maintainance DB - that is by default marked as= Postgres. Now when you make entries for specific user for specific databas= e=2C you get this above error=2C if you do not change the maintainence db t= o the same as the user wants to connect to.
 =3B
 =3B
>=3B
>=3B --
>=3B Sent via pgsql-admin mailing list (pgsql-admin@postgre= sql.org)
>=3B To make changes to your subscription:
>=3B http://w= ww.postgresql.org/mailpref/pgsql-admin


Search for videos= of Bollywood=2C Hollywood=2C Mollywood and every other wood=2C only on Liv= e.com Try it now! = --_9b016a61-65fc-435f-8456-310c0140c4b8_--