PDA

View Full Version : postgress forgot password



locky
09-30-2010, 05:20 PM
hey guys another one

i manually uninstalled my last postgres SQL v 8.4 and when i try to install v9 on my external hard drive it needs a password..

i tried postgres/ postgrespass to no avail

unfortunately i cant even manually correct path lines etc because i deleted it all

HELP!

thanks

Patvs
10-01-2010, 12:36 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.

This will delete the postgres user, after which it will accept any password during installation (use: postgrespass)

locky
10-01-2010, 02:59 AM
Thanks so much Patvs

easy instructions every time!

cheers,
locky :)