On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam <Shashwat_Nigam@xxxxxxxxxx> 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.