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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [ADMIN] 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: [ADMIN] Regarding access to a user
  • Date: Mon, 25 Aug 2008 11:08:14 -0600
  • Message-id: <dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com> <text/plain>

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.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group