PostgreSQL Windows Installation Problem running post-install step. Installation may not complete correctly.

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]

Categories: Uncategorized

Mohit Chandra 26-March-2015

Quick Links