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

21 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 =)

  3. I do consider all of the ideas you have presented in your post.
    They’re really convincing and will definitely
    work. Still, the posts are very quick for novices. Could
    you please extend them a little from next time?

    Thanks for the post.

  4. Pretty nice post. I just stumbled upon your blog and wished to say that I’ve really enjoyed browsing your blog posts. After all I抣l be subscribing to your feed and I hope you write again soon!

  5. Fantastic web site. Plenty of helpful information here. I am sending it to some buddies ans also sharing in delicious. And naturally, thank you to your sweat!

  6. Greetings! Very useful advice within this post! It is the little changes which will make the most important changes. Many thanks for sharing!

  7. Heya! I’m at work browsing your blog from my new iphone 4! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the excellent work!

  8. Hmm it appears like your website ate my first comment (it was extremely long) so I guess I’ll just sum it up what I wrote and say, I’m thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to the whole thing. Do you have any tips and hints for inexperienced blog writers? I’d genuinely appreciate it.

  9. Spot on with this write-up, I truly think this site needs far
    more attention. I’ll probably be returning to read more, thanks for the information!

  10. I’ve been browsing online more than three hours today, yet I never found any interesting article like yours. It抯 pretty worth enough for me. In my view, if all website owners and bloggers made good content as you did, the net will be much more useful than ever before.

  11. Oh my goodness! an incredible article dude. Thanks However I’m experiencing problem with ur rss . Don’t know why Unable to subscribe to it. Is there anybody getting similar rss drawback? Anyone who is aware of kindly respond. Thnkx

  12. I wanted to construct a simple note so as to appreciate you for all of the amazing guidelines you are showing at this website. My considerable internet look up has finally been paid with extremely good strategies to talk about with my friends. I ‘d tell you that most of us site visitors actually are very endowed to be in a great website with so many perfect individuals with helpful plans. I feel very blessed to have discovered your site and look forward to really more fabulous moments reading here. Thanks a lot again for all the details.

  13. Hey there, You’ve done a great job. I抣l definitely digg it and personally suggest to my friends. I’m confident they’ll be benefited from this website.

  14. I抳e recently started a web site, the info you offer on this website has helped me tremendously. Thank you for all of your time & work.

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