Thanks for your response, but it didn't work.
It goes like this,
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?
--- 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
> > 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
> If you edit pg_hba.conf to "trust", it should work also
> (but watch your security).
pgsql-novice by date
|Next:||From: Ms swati chande||Date: 2009-06-30 07:56:36|
|Subject: Re: Problems using psql--Fatal password authentication failed |
|Previous:||From: Ms swati chande||Date: 2009-06-30 03:48:55|
|Subject: Problem while using createdb for the first time|