Installation of postgresql-13.1-1 fails on windows fails with “Failed to load SQL modules into the database cluster” & “Problem running the post-install step. Installation may not complete correctly.”

Dear Readers,

Happy new year 2021!!!

This is my first day of learning PostgreSQL and I faced issue while installing version 13.1 on windows. After almost spending 3 hours of troubleshooting I was able to identify the issue & fix it.

In this post will explain basic steps to install Postgresql 13.1 on windows 10 & possible resolution in case you face similar issue.

First step is to download required software from required software from enterprisedb website. I downloaded version 13.1 for Windows x86-64.

Once the intended software is downloaded, you can run it as administrator. This will open setup screen. Click on next

You can choose to use default location & click next:

I wanted to install complete pg setup so checked all options & clicked next:

You can choose default location and click next:

You need to remember this password to connect to you postgresql cluster. Click next:

5432 is default port. You can keep it & click next:

Choose default option & click next:

You will see pre installation summary here:

Now we are ready to begin installation:

Installation in progress:

And it failed with below error:

I saw one more error after pressing OK button:

Though it shown me below screen at the end showing setup completion:

As expected installation was incomplete. DATA folder was empty.

I tried connecting to postgresql cluster using psql CLI. It failed connecting with below error:

I tried googling about all 3 errors, tried different solutions, but nothing worked. So though of trying lower version 12 but it ended with same story.

After lot of investigation, I found some movement in antivirus software whenever the setup was about to finish. After checking antivirus scan report, I was able to find the issue. Every time setup was about to complete, antivirus tried to clean possible threats it was identifying.

This time I decided to stop antivirus services during setup install & it worked without any issue :-). This time after setup completion, I was able to see number of files in DATA folder.

I tried connecting to postgresql cluster & it was working as expected;

Hope u will find this post very useful.

Cheers

Regards,
Adityanath

3 replies

  1. I have learn several just right stuff here. Definitely worth bookmarking for revisiting. I wonder how much attempt you place to make this sort of magnificent informative website.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s