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.
Categories: Administration, Installation, PostgreSQL, Uncategorized
Very useful blog .
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.
Thank you so much. Your solution helped
Thanks appreciate the feedback
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 =)
I couldn’t refrain from commenting. Very well written!
Saved as a favorite, I like your site!
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.
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!
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!
Greetings! Very useful advice within this post! It is the little changes which will make the most important changes. Many thanks for sharing!
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!
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.
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!
Keep on writing, great job!
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.
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
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.
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.
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.
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!
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!
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!
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!
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.
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.
Appreciate it for this marvellous post, I am glad I observed this internet site on yahoo.
how do you stop the anti virus? could you guide? ive got NPAV as well
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.
Thank You so much. It worked!
Thanks so much… Appreciate the feedback!!!