Re: Problem while using createdb for the first time

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@gmail.com> wrote:

> From: Patrick <flymooney@gmail.com>
> Subject: Re: [NOVICE] Problem while using createdb for the first time
> To: "Ms swati chande" <swativc@yahoo.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
>
>
>
>
>
>