| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rommel the iCeMAn | 2008-08-25 17:32:54 | Re: Problem with reinstall of PostgreSQL 8.3 |
| Previous Message | Marcelo Martins | 2008-08-25 14:06:30 | Re: restoring from dump |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John T. Dow | 2008-08-25 17:37:13 | Re: Dump/restore with bad data and large objects |
| Previous Message | Joshua Drake | 2008-08-25 17:04:13 | Re: Dump/restore with bad data and large objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishal Arora | 2008-08-26 04:18:02 | Re: Regarding access to a user |
| Previous Message | Tom Lane | 2008-08-23 02:50:10 | Re: What is wrong with this PostgreSQL UPDATE statement?? |