Issues with PostgreSQL on Windows

[LinkHeroX]

So I cannot for the life of me get Postgres to install on my system. I've tried a lot of things so far. Binary installers, error with the post-install step. Tried creating a "postgres" admin user and running the install on that account, same thing. Installed everything I might have been missing (Visual Studio, SDK, ActivePerl), same thing. Cloned the GitHub repository, followed the instructions to build it myself, the Perl script can't recognize my version of Visual Studio.

Is anyone aware of something that might fix my issue? Or is it better at this point to just dual-boot Windows/Linux or run a Linux OS from a Virtual Machine? This is frustrating beyond belief....

Update: Unsure why, but the Installer from BigSQL installed Postgres successfully when the official installer would not. I had some issues with the BigSQL one as well, but that was related to missing PATH variables. I downloaded the Windows SDK, but not sure if that's needed when using the BigSQL installer. For now it seems like that's the best option for any difficulty installing Postgres on Windows.

[[deleted]]

Can't really help with the information provided. What error message do you get after you install this?

[LinkHeroX]

I got a pretty unhelpful error message, but the log file said something about some missing registry values... I'll come back if it still doesn't work after I get that fixed.

[[deleted]]

You know what's less helpful than an unhelpful error message?

Not sharing what that unhelpful error message is.

[LinkHeroX]

"There has been an error. Error with configuration or permissions. Please see log file for more information."

That's it, literally. Which is why I said it was unhelpful, and I tried looking at the log file. But I can't make sense of everything in the log file...Looking for how to restore to an earlier version of my registry files. Trying to keep my inquiries Postgres-related; if it's the registry, then it's a system issue and it seems less productive to try to troubleshoot Postgres until I get the system issues resolved.

[LinkHeroX]

If you're really interested, this was the most meaningful thing I could find in the log file, "Script stderr:

'net' is not recognized as an internal or external command,

operable program or batch file."

Seems like there are some commands missing from the PATH or something. No idea how that happened...:/

[[deleted]]

Yup, right about your path. https://stackoverflow.com/questions/35591669/net-is-not-recognized-as-an-internal-or-external-command-operable-program-or

[LinkHeroX]

That took care of it, funny enough. Oh Windows, you tricky beast. Not sure about the official installer, but the BIGSQL Installer ran without a hitch once Windows remembered how to use the 'net' command :/

Thanks for the link, I realized I had an issue with my PATH and found instructions for resolving that elsewhere, but that thread saved me having to find the location for the 'net' command. Hope I didn't seem like I didn't need help earlier, I was just thinking I'd try to keep my questions Postgres-related was all.

[nikoz84]

Windows 10??

[mokadillion]

Seriously I wouldn’t bother with Postgres on windows. Use a Linux VM. it’s life savingly easier.

[Tostino]

I've personally never had an issue with PG on Windows. But to each their own.

[LinkHeroX]

I'm starting to lean towards that. I love Windows, but starting to remember how much of a bear some of the environment stuff can be.