Re: Postgres under Windows

John,

The command you gave createdb.exe -h 127.0.0.1 -U
postgres mydb is working.

The system gives me the result CREATE DATABASE.

Looking into pgadminiii shows the database is created.

Doing the same with my user account is not working.

Thanks anyway it is making me understand postgres
better.

regards,
Danny

--- John DeSoi <desoi(at)pgedit(dot)com> wrote:
> Danny,
>
> On May 30, 2005, at 10:13 AM, Danny Gaethofs wrote:
>
> > Now I try to create a database as explained in the
> > documentation:
> >
> > createdb mydb
> >
> > The systems asks for a password and when I enter
> the
> > password it comes back with:
> >
> > could not connect to database template1: FATAL:
> > password authentication failed for user "xxx"
>
>
> If you just entered "createdb mydb" that is not
> going to work unless
> you are logged into a Windows account which has the
> same name as a
> PostgreSQL user account that can create databases.
> If you really called
> createdb with more options, please show us exactly
> what you typed and
> exactly what the error output is.
>
> You probably want something more like:
>
> createdb.exe -h 127.0.0.1 -U postgres mydb
>
> If you can do things OK with pgAdmin, then it is
> most likely there is
> just some incorrect option in the command line.
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com