On 19/06/10 03:25, Christian Hansen wrote: > > The following bug has been logged online: > > Bug reference: 5512 > Logged by: Christian Hansen > Email address: chanse...@btinternet.com > PostgreSQL version: 8.4.4 > Operating system: Windows XP > Description: Password error message > Details: > > I need to set up a programme supported by Java and postgresql 8.4 > I chose Gr8Dane$23 as my database password and successfully installed > postgradsql 8.4 > When it came to launch the programme,I needed to type in the postrgadsql > password, and I got an error message "Fatal error..." I assume it was > because it did not like the $ in my password. So I uninstalled postgradsql > intending to use a password without any symbols, but now I cannot reinstall > it as I get an error message "Incorrect password". Could you reset your > database so I can reinstall postgradsql. And also advise me about what I can > use as a password, so I do not get these error messages again.
You need to change the password on the "postgres" system account in Windows using the administrative tools, THEN re-install. Alternately, just re-install with the old password then log in to PostgreSQL as the "postgres" user and change the postgres user's password. This confusion arises because there are two "postgres" users - a system user, and database user. More information can be found in the list archives and (hopefully) the manual. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs