From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Christian Hansen <chansen23(at)btinternet(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5512: Password error message |
Date: | 2010-06-20 17:36:20 |
Message-ID: | 4C1E5194.5080703@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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: chansen23(at)btinternet(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Marcos Castedo | 2010-06-20 22:02:41 | BUG #5514: no relation entry for relid X |
Previous Message | Elior | 2010-06-20 16:42:51 | BUG #5513: High availability with Postgres |