Adityanath's Database & Cloud Blog

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

Published on

5,318 hits

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

Advertisements

32 responses to “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.””

  1. Sonali Avatar
    Sonali

    Very useful blog .

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      Thanks Sonali!!!

      Reply
  2. Avatar
    Anonymous

    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.

    Reply
  3. jenny Avatar
    jenny

    Thank you so much. Your solution helped

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      Thanks appreciate the feedback

      Regards,
      Adi

      Reply
  4. Avatar
    Anonymous

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

    Reply
  5. Cesar Magraw Avatar
    Cesar Magraw

    I couldn’t refrain from commenting. Very well written!

    Reply
  6. Malcolm Bellanger Avatar
    Malcolm Bellanger

    Saved as a favorite, I like your site!

    Reply
  7. Tatiana Avatar
    Tatiana

    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.

    Reply
  8. Hairstyles Avatar
    Hairstyles

    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!

    Reply
  9. Hairstyles Avatar
    Hairstyles

    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!

    Reply
  10. Dewayne Phoubandith Avatar
    Dewayne Phoubandith

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

    Reply
  11. Harrison Benito Avatar
    Harrison Benito

    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!

    Reply
  12. Catrice Montagna Avatar
    Catrice Montagna

    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.

    Reply
  13. Vernita Avatar
    Vernita

    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!

    Reply
  14. Rena Avatar
    Rena

    Keep on writing, great job!

    Reply
  15. Fashion Styles Avatar
    Fashion Styles

    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.

    Reply
  16. zovre lioptor Avatar
    zovre lioptor

    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

    Reply
  17. Fashion Styles Avatar
    Fashion Styles

    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.

    Reply
  18. Beauty Fashion Avatar
    Beauty Fashion

    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.

    Reply
  19. Fashion Styles Avatar
    Fashion Styles

    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.

    Reply
  20. Beauty Fashion Avatar
    Beauty Fashion

    This is really interesting, You’re an excessively professional blogger. I have joined your rss feed and look ahead to seeking extra of your fantastic post. Additionally, I’ve shared your website in my social networks!

    Reply
  21. Fashion Styles Avatar
    Fashion Styles

    Hello! I could have sworn I’ve been to this website before but after reading through some of the post I realized it’s new to me. Anyhow, I’m definitely glad I found it and I’ll be book-marking and checking back frequently!

    Reply
  22. Beauty Fashion Avatar
    Beauty Fashion

    Wow, wonderful weblog structure! How lengthy have you been blogging for? you make running a blog glance easy. The entire glance of your site is wonderful, let alone the content material!

    Reply
  23. Hairstyles Avatar
    Hairstyles

    This is really interesting, You’re a very skilled blogger. I have joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

    Reply
  24. Beauty Fashion Avatar
    Beauty Fashion

    Thank you for sharing excellent informations. Your website is very cool. I am impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for extra articles. You, my pal, ROCK! I found just the information I already searched all over the place and just couldn’t come across. What an ideal web-site.

    Reply
  25. Fashion Styles Avatar
    Fashion Styles

    I was just searching for this information for a while. After 6 hours of continuous Googleing, at last I got it in your web site. I wonder what is the lack of Google strategy that do not rank this type of informative web sites in top of the list. Usually the top sites are full of garbage.

    Reply
  26. Tanner Zell Avatar
    Tanner Zell

    Appreciate it for this marvellous post, I am glad I observed this internet site on yahoo.

    Reply
  27. Rohan Shinde Avatar
    Rohan Shinde

    how do you stop the anti virus? could you guide? ive got NPAV as well

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      You can stop following services from services.msc

      Zero-V AntiVirus Protection
      NPAV Antivirus Protection
      NPAV Application Control
      Net Protector Web Prototection

      Do not forget to start it once installation is complete.

      Regards,
      Adi

      Reply
  28. Queen B (@charmingbrenda) Avatar
    Queen B (@charmingbrenda)

    Thank You so much. It worked!

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      Thanks so much… Appreciate the feedback!!!

      Regards,
      Adi

      Reply

Leave a reply to Adityanath Dewoolkar Cancel reply

Advertisements
Blog Stats

560,272 hits

Advertisements
Advertisements