PDA

View Full Version : Can't upgrade postgres 4.4.4.1 due to incorrect password



ProsperousOne
08-13-2010, 12:11 AM
Pat instructed me due to a corrupt db to try upgrading to 4.4.4.1 and then reimporting all my hands.

I'm running Windows 7 x64.

Unfortunatly, when I try the postgres 4.4.4.1 installer, it asks me for the Postgres Super user account password. I tried all the standard, as well as my own possibilities. (My comptuer doens't even have one) and I keep getting incorrect pw error.

SO I deleted the postgres profile (according to the install, it says a new profile will be recreated if I delete it).

I rebooted, and retried to install... still no joy, keeps telling me bad pw....

ugh...

Patvs
08-13-2010, 01:10 AM
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /del' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.




If you do this.. it should accept EVERY password you choose upon the next installation. Pick: postgrespass

sprstoner
08-13-2010, 02:21 AM
i had the same prob a while back, because we have no clue what the HEM installer uses as the postgres user pass... seems like they should know.

anyways i followed similar instruction given to you here and i had to re-import my whole db (which wasnt something i wasnt planning on doing at the time).

ProsperousOne
08-13-2010, 09:58 AM
Worked like a charm!

Thanks!