i recently installed PostgreSQL on windows 7, each time i try to use CMD to execute SQL command, i get this error
createdb: could not connect to database template1: FATAL: password authentication failed for user "R-61"
Where R-61 is my windows machine username.
Here is how i use CMD with pgSQL
- first i cd to the pgSQL bin folder
$ cd C:\xampp\pgsql\9.1\bin
- i try creating a database
$ createdb NEWDATABASE
i get a prompt to enter a password. this is where am confuse as i do not know what password. I have tried my window user password, password for the
postgres
super user, none seem to work. this is the error message i getcreatedb: could not connect to database template1: FATAL: password authentication failed for user "R-61"
Anybody know the solution to this? am thinking changing the user form R-61 to
postgres
superuser would work but i do not know how to do it.
Your help is greatly needed.