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

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

  2. Terrific work! This is the type of information that should be shared around the net. Shame on Google for not positioning this post higher! Come on over and visit my site . Thanks =)

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