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 http://www.patni.com World-Wide Partnerships. World-Class Solutions. _____________________________________________________________________ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _____________________________________________________________________