PostgreSQL Stack Builder Installation Proxy Setting on Windows

My LAN server doesn't have internet access, I also find that StackBuilder from EDB doesn't respect proxy setting on Windows (am upgrading to 9.6.2), be it IE proxy setting or the proxy setting box in StackBuilder GUI.

But it turned out to indeed support proxy. Just not through the GUI.

If you have already set https_proxy and http_proxy variables for your account, just launch stackbuilder and ignore the proxy button.

If you don't, try launching stackbuilder.exe from commandline and it worked.

Before that, SET Environment Variables like you usually did on Linux for curl/wget.

 C:\> set HTTPS_PROXY=http://address:port
 C:\> set https_proxy=http://address:port
 C:\> path_to_stackbuilder\stackbuilder.exe

My guess is though the GUI screwed up, the underlying network library (should be libcurl in this case) somehow managed to pickup those parameter.

Maybe few people needs proxy support, but hope this workaround could help someone.

I'm not sure if the Stack Builder is honouring the system proxy settings ... and to make life more difficult, we have an authenticating proxy.

I got around the issue by using Fiddler

Run Fiddler, then on the menu Rules, enable Automatically Authenticate

Run the Stack Builder, and set its Proxy to localhost and port 8888. Do this for both HTTP and FTP (the list is retrieved using HTTP, but the packages come over FTP)