Query

Hi 

I have just installed PostgreSQL 8.1 on a Windows XP system with a 

NTFS filesystem. Everything seemed to work fine until I executed the 

command promt option from the PostgreSQL start button. 

I wanted to create my first database by typing "createdb mydb" and 

was asked for my password. Everytime I type it in I get the error message

"createdb: could not connect to database postgres: FATAL: password 

authentication failed for user "xxxxx" ". 

Another problem is that the user xxxxx in the error message is not the 

user specified in the installation (I used the default user "postgres" 

given in the installation) but my  username on my computer and it has

administrative rights.

I dont really know why PostgreSQL asks for my username and not the one specified 

in the installation.   

If anybody can tell me why I get this error everytime I would greatly 

appreciate it. 

---------------------------------------------

Thanks & Regards

V.Eswar

Senior Software Engineer

Patni Computer Systems Ltd.
Level 0, Tower III
Cyber City, Magarpatta City Hadapsar
Pune 411 028.
Tel: +91 20 39842000, x 2057

Link : 9-621-402