Skip site navigation (1) Skip section navigation (2)

Re: Regarding access to a user

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Shashwat_Nigam <Shashwat_Nigam(at)satyam(dot)com>
Cc: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Regarding access to a user
Date: 2008-08-25 17:08:14
Message-ID: dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-sql
On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam
<Shashwat_Nigam(at)satyam(dot)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.

In response to

Responses

pgsql-sql by date

Next:From: Vishal AroraDate: 2008-08-26 04:18:02
Subject: Re: Regarding access to a user
Previous:From: Tom LaneDate: 2008-08-23 02:50:10
Subject: Re: What is wrong with this PostgreSQL UPDATE statement??

pgsql-admin by date

Next:From: Rommel the iCeMAnDate: 2008-08-25 17:32:54
Subject: Re: Problem with reinstall of PostgreSQL 8.3
Previous:From: Marcelo MartinsDate: 2008-08-25 14:06:30
Subject: Re: restoring from dump

pgsql-general by date

Next:From: John T. DowDate: 2008-08-25 17:37:13
Subject: Re: Dump/restore with bad data and large objects
Previous:From: Joshua DrakeDate: 2008-08-25 17:04:13
Subject: Re: Dump/restore with bad data and large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group