Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C0AD1650279
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 25 Aug 2008 14:09:09 -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 44354-03-6 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 25 Aug 2008 14:08:59 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.237])
	by postgresql.org (Postfix) with ESMTP id 2FE256501F6
	for <pgsql-admin@postgresql.org>; Mon, 25 Aug 2008 14:08:16 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so2686835rvf.43
	for <pgsql-admin@postgresql.org>; Mon, 25 Aug 2008 10:08:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=Ysishdm/ijVDxZjBtzLzoRf4u5TCPz2q41C8NXka6ys=;
	b=VMT5QFexHaiF968uOqQihd57niMgwig7m4O1GxPnE65cACJb+oG700FfzgGw1l++TG
	IYbMm0XS7PnwIUaPappanymZlquwxdltwSj174NPfadycs2a2NJAe3MnIYLku58fiCru
	6kwAXa83F9y01lGLUMeAgEplvYd2Vc+S2aEBk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=PMC68mGUOY9wyKRKlMSCGKw1UDNhhfEAFV/rwYV6o5GIynqaIEHALqLPghKAkZeXZf
	z1J7mFOwMEa9b372nAAPpUKmI19mfYzih4NnQmblZlJY2ag4n2OEAz5v5U8LllK7XAni
	3vrPdzs5A6r74OOxcQ4YcdvsiDEz9/HCoB/b8=
Received: by 10.140.147.5 with SMTP id u5mr2255409rvd.274.1219684094915;
	Mon, 25 Aug 2008 10:08:14 -0700 (PDT)
Received: by 10.141.197.1 with HTTP; Mon, 25 Aug 2008 10:08:14 -0700 (PDT)
Message-ID: <dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com>
Date: Mon, 25 Aug 2008 11:08:14 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: Shashwat_Nigam <Shashwat_Nigam@satyam.com>
Subject: Re: Regarding access to a user
Cc: "Vishal Arora" <aroravishal22@hotmail.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"Kevin Grittner" <Kevin.Grittner@wicourts.gov>,
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
In-Reply-To: <B3F7216EEA3D5D49A0841DFC6843C33AB9BF01@HSTMBX004.corp.satyam.ad>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
	<48ABD192.EE98.0025.0@wicourts.gov>
	<B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad>
	<BLU149-W43C021FC87E127F8C66252A96B0@phx.gbl>
	<B3F7216EEA3D5D49A0841DFC6843C33AB9BF01@HSTMBX004.corp.satyam.ad>
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/150
X-Sequence-Number: 29995

On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam
<Shashwat_Nigam@satyam.com> wrote:
> Dear Vishal
>
> Thanks for the help but by doing 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", user "hmri", database
> "postgres", 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.