Poostgresql in Windows Platform installation failed to resolve

First, the question

Recently, the test department reflected the failure of the Windows platform to install PostgreSQL 9.4, the pop-up message box error message is roughly:

"Problem running post-install step.  Installation may isn't complete correctly. ...”

The information that follows is slightly different depending on the installation version.

After gathering data and experimenting repeatedly, a solution is found that can be applied to most environments (already validated in Win7, WIN10, Win server 2012, and win server 2016).

The following is an example of the Postgresql-9.4.14-1-win64-bigsql.exe installer, and the other versions of the installation program are similar.

Ii. key points of Success 2.1 create the installation directory beforehand and assign permissions

For example, if you plan to install in the D:\PostgreSQL directory, create it beforehand.

Then, in the file Manager, right-click the directory, properties, security, edit, add Full Control and modify permissions, and so on for user users.

With respect to permissions, at a minimum, the "modify" permission is given to the user, and we give the "Full Control" to the insurance.

2.2 Installing PostgreSQL with non-administrator users

Do not use the administrator user to install, if there is only administrator a user, in the control Panel to create another (name arbitrary), give it administrator rights.

Log in with the user you just created, and run Setup directly without using "Run as Administrator."

In addition, it is best to temporarily turn off anti-virus software, security guards, firewalls, etc. during the installation period to prevent interference with the installation process, especially in the Windows Server platform.

2.3 If an error occurs, uninstall and reinstall immediately

In general, the installer has been installed correctly, the criteria for judging are:

• During the installation process, there are "database initialization", "Create user", "Configure 5432 Port", "registration service" and other prompts;
• After the installation is complete, "PostgreSQL 94 Server" appears in the system service.

If this is not the case, the "problem running Post-Install step" will appear. Installation may not complete correctly. " A prompt box stating that the installation failed.

Do not worry at this time, uninstall the "PostgreSQL" in the control Panel, do not delete the installation directory, and then reinstall, basically will be installed successfully.

Sometimes there is a "problem running post-install step ..." Prompt box, but you can ignore it as long as the PostgreSQL 94 Server service has been added.

2.4 Final remedial action: execution of Pgservice.exe

If there is a mistake in the above process, try to execute Pgservice.exe (directory D:\PostgreSQL\pg94) in the cmd window, if you can add a service named Pgservice, and the service can start and close normally, it can be considered as "99.9% success".

However, this method is only valid in some cases, and may cause some legacy problems, only as the ultimate lifeline, can or do not be good.

Poostgresql in Windows Platform installation failed to resolve