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.
- 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]