PostgreSQL: Reset root password

Rational Pie

I had an old installation of postgreSQL on my Win32 XP box. I never really used it until today when I was forced to ditch MySQL in favor of postgreSQL. But the classical problem now:  I had forgotten the password for my default postgres account. Since I had no other user(role) created, this meant  had no choice but to forcefully reset my postgres password.

Unfortunately people at postgreSQL seem to be suffering from a widespread tendency of treating a windows user as someone who needs to be punished for committing the cardinal sin of opting windows. I remember several of my batchmates having had their brains fried trying to install postgreSQL on their windows machines (before I stepped in to save them, of course :D).

Anyway, enough digression! Here is how it worked out for me:

1. Get the server running:
   
2. Open the file

   Initial Content:

   Changed to:

3. reload the server…

View original post 104 more words