Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I feel really dumb writing this, I wanted to have a mess around with databases so I just installed postgreSQL (9.1)

During the installation I am asked to provide a superuser password. I provide a password that it can use and everything gets installed.

I'm following the getting started documentation. getting started documentation and attempt to use the command createdb in cmd.exe. It asks for a password and responds with:

createuser: could not connect to database postgres: FATAL: password authentication failed for user "VanGOss"

I can access a database inside pgAdminIII with the password I originally provided at installation. So it's the command line tools not accepting the password.

I also run postgres and got this back:

Execution of PostgreSQL by a user with administrative permissions is not
The server must be started under an unprivileged user ID to prevent
possible system security compromises.  See the documentation for
more information on how to properly start the server.

I tried using createuser to make a user, again run from cmd.exe and it said its not accepting my password.

what i'm thinking is I must run my environment under a limited user, which I don't want to do. This is my home computer and I just want one account.

windows 7 64-bit 1 user account, me, admin can't past page 2 of a tutorial on running a database, kinda shameful :(

Any one know how I can make my own database? Please.

share|improve this question
up vote 2 down vote accepted

Try to add the option -U postgres to your createdb command. The error clearly states that PostgreSQL tried to execute it with the current Windows username, while you set superuser password (presumably) for user postgres.

share|improve this answer
Thanks dezso, this worked. I see what you mean, it used my windows account name, expecting it existed as a user. When the only user was postgres, and -U selects a new user for the command. Thanks so much. :) – Joseph Jun 13 '12 at 15:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.