Yesterday, when I install PostgreSQL on Windows 7, it always report the following error:
[stextbox id=”alert”]Problem running the post-install step. Installation may not complete correctly.[/stextbox]
… when the installation progress bar reached the end.
After doing a bit searching, I found the solution.
Solution:
- Uninstall PostgreSQL
- Run command: net user postgres /delete
- Click: Control Panel -> User Accounts -> Configure advanced user profile properties -> delete all “Unknown User” instances that seem to be left from PostgreSQL installation.
- Run command: net user postgres dbpass /add
- Run: compmgmt.msc -> Click Local Users and Groups -> Users -> postgres ->Member of -> Add… -> Administrators -> OK
- Run: runas /user:postgres cmd.exe -> cd \ -> postgresql-8.4.9-1-windows.exe -> installed successfully without errors. Checked data folder and confirmed files created successfully.
- Run: compmgmt.msc -> Local Users and Groups -> Users -> postgres -> Member of -> Administrators -> Remove
- Run: compmgmt.msc -> Local Users and Groups -> Users -> postgres -> Member of -> Add… -> Power Users -> OK
Installation completed successfully! Enjoy
[stextbox id=”warning”]Your opinions, comments and suggestions are important to keep the page updated and interesting. [/stextbox]
28 comments
Hello Karthik,
Thanks for your Valuable words! Stay tuned…
Regards
Anisha Bahukhandi
Thanks for your valuable feedback! Stay tuned for more blogs…
Regards
Anisha Bahukhandi
Enter the password for postgres:
what should I write for the password
Thanks
But, thank you so much. I spent hours trying to work this out. Do you mind if I write an article on this. I will refer your article as the main source.