Forgotten PostgreSQL Windows password

internet

This morning I’ve been upgrading the Postgres database on my Windows XP laptop to version 8.3.

During the installation it asks for the password of the service account of previous PostgreSQL version. The default value is ‘postgres’, but sure enough I forgot what password I used when I originally installed it.

I found this useful post on how to change the password for any Windows user. From the Windows command line execute the following to reset the password to ‘postgres’.

net user postgres postgres

That worked, so now I’m ready to complete the installation and be able to use the new Ruby pg gem that was recently release for Windows.

Re: Forgotten PostgreSQL Windows password

Kan je het mij duidelijk uitleggen hoe ik mijn wachtwoord verander want het lukt mij niet.

Re: Forgotten PostgreSQL Windows password

You just saved me from sure dead. Thanks!!!

Re: Forgotten PostgreSQL Windows password

LEGEND! Saved me too.

Thanks.

:)

Re: Forgotten PostgreSQL Windows password

thnx from the bottom of my heart

Re: Forgotten PostgreSQL Windows password

Waouw !! Thank you so much ! After hours of troubles, I couldn’t believe it would work so easily with your tips !

Re: Forgotten PostgreSQL Windows password

You saved me from reformatting my pc, to make it a clean slate ….stupidly spent half an hour on google ..until saw your page. thanks loads.

PostgreSQL Windows password

It was very useful. I my case it happened at first install: when the installer prompted me for a password for the postgres user, I’ve tried to put “postgrespw” in the fields, but I misspelled the verification; tried again but somehow the postgres user was added but the password was neither “postgres”, nor blank. I canceled the instalation process and tried from the begining, but cannot figure what is the correct password. At this point you saved me!
Thank you.

Re: Forgotten PostgreSQL Windows password

yes, thanks a lot…

you saved me out of hell….

Re: Forgotten PostgreSQL Windows password

Finally someone that could explain how to change or reset the password to a newbie postgresql user thanks a whole bunch, you saved me.

Re: Forgotten PostgreSQL Windows password

Thanks alot!!

Re: Forgotten PostgreSQL Windows password

THX so much!! been lookin everywhere for that

Re: Forgotten PostgreSQL Windows password

WOW, THANK YOU!!!

Re: Forgotten PostgreSQL Windows password

Thank You

Re: Forgotten PostgreSQL Windows password

wow..thx a lot..this makes my day..been searching for the whole day to solve this problem~~
 thx

Re: Forgotten PostgreSQL Windows password

i tried it but the particular pc im working on won’t do it
it has some form of policy for lengths etc…….

Re: Forgotten PostgreSQL Windows password

Dammit! THANK YOU!! :-)

Re: Forgotten PostgreSQL Windows password

damn thx! altijd problemen met dat postgresql

Re: Forgotten PostgreSQL Windows password

Thanx a ton

Re: Forgotten PostgreSQL Windows password

what do I do when I get “system error 5 has occurred. Acess is denied?”

Re: Forgotten PostgreSQL Windows password

OMG!!
Thanx man!

Post new comment

The content of this field is kept private and will not be shown publicly.

Popular content