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

Re: Problem while using createdb for the first time

From: Ms swati chande <swativc(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org, flymooney(at)gmail(dot)com
Subject: Re: Problem while using createdb for the first time
Date: 2009-06-30 07:48:20
Message-ID: 413682.70258.qm@web112601.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks for your response, but it didn't work.

It goes like this,

c:\>createdb demo
Password:
createdb: couldnot connect to database postgres: FATAL: Password authentication failed for user 'prof'.

I made the following change in pg_hba.conf and it still did not work.
local     all      all      127.0.0.1     trust

I haven't set any password anywhere.

But, just in case I have forgotten, what do I do?

Thanks
Regards,
Swati


--- On Tue, 6/30/09, Patrick <flymooney(at)gmail(dot)com> wrote:

> From: Patrick <flymooney(at)gmail(dot)com>
> Subject: Re: [NOVICE] Problem while using createdb for the first time
> To: "Ms swati chande" <swativc(at)yahoo(dot)com>
> Date: Tuesday, June 30, 2009, 9:33 AM
> Ms swati chande wrote:
> > Hi,
> > 
> > I built postgresql from source using Windows 2005.
> > 
> > After installation, I am trying to create a database
> using
> > 
> > createdb.
> > 
> > It then asks for a password. What password is it?
> There are now passwords set on my system. Also tried editing
> pg_hba.conf. But could not solve the problem.
> > 
> > How do I move ahead.
> > 
> > Thanks
> > 
> > Regards
> 
> Try "postgres" (works on Linux but I'm not sure about
> Windows).
> 
> If you edit pg_hba.conf to "trust", it should work also
> (but watch your security).
> 
> Patrick
> 
> 
> 
> 
> 
> 


      

Responses

pgsql-novice by date

Next:From: Ms swati chandeDate: 2009-06-30 07:56:36
Subject: Re: Problems using psql--Fatal password authentication failed
Previous:From: Ms swati chandeDate: 2009-06-30 03:48:55
Subject: Problem while using createdb for the first time

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