Re: [ADMIN] Regarding access to a user - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: [ADMIN] Regarding access to a user
Date
Msg-id dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com
Whole thread Raw
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: What is wrong with this PostgreSQL UPDATE statement??
Next
From: sub3
Date:
Subject: Data into an array