In our last post, we talked about the solutions to Oracle Database installation failure. Today, let’s talk about PostgresSQL installation failure.
PostgreSQL Installation Failed
When attempting to install PostgreSQL, you might encounter the error: “Problem running post-install step. Installation may not complete correctly. The database cluster initialization failed.”
How to Fix PostgreSQL Installation Failure?
1. Check for PostgreSQL User:
Open a Command Prompt and use the command “net user” to see if a “postgres” user exists.
If the “postgres” user does not exist, create one with the command: “net user postgres 123456 /add”.
2. Clean Registry Entries:
Press Ctrl+R, type “regedit”, and press Enter to open the Registry Editor.
Navigate to “HKEY_CURRENT_USER” and “HKEY_LOCAL_MACHINE” under “Software”, and delete all PostgreSQL-related entries.
3. Reinstall PostgreSQL:
If PostgreSQL was previously installed, ensure it is fully uninstalled.
Create a new directory on a different drive for this installation, such as “E:\postgresql”.
4. Run Installer as Administrator:
Right-click the installer and select “Run as administrator” to complete the installation successfully.
If you have Issue during troubleshooting like “xxx is not recognized as an internal or external command,” it’s likely due to an incorrect “PATH” environment variable, add “%SystemRoot%\system32;” to the existing PATH environment variable to resolve this issue.
