PostgreSQL Stack Builder Installation Proxy Setting on Windows

I have downloaded and installed PostgreSQL 9.3 (64 bit) on a developer machine running Windows 8.1 (64 bit). This developer machine requires use of a proxy server for accessing hosts external to the LAN.

The StackBuilder 3.1.1 Wizard / Installer pulls the proxy settings from IE, and they appear to be correct, but when clicking the "Next" button, I receive a "Stack Builder Error" dialog indicating:

Failed to open the application list:
http://www.postgresql.org/applications-v2.xml

Error: The URL specified could not be opened.

I have been able to successfully download the application list using IE and Chrome with the same proxy settings the installer initially pulled from IE.

Other things I have tried:

  • Pre-pending the proxy server hostname with the protocol 'http://'
  • Used the proxy server's IP address instead of the hostname
  • Removed the proxy settings entirely

In the first two cases, the installer responds almost immediately with the error message above. In the last, there is about a 5 second delay before it responds with the error message above.

A similar problem seems to be documented as a bug on the PostgreSQL bug tracker but there has been no response to the initial report.

Is anybody familiar with this problem, and if so, what work arounds have been found to be effective in using the Stack Builder installer?


Solution 1:

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.

Solution 2:

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)

Solution 3:

If your proxy needs authentication, open command prompt as administrator

Set proxy for the current session in CMD

set HTTPS_PROXY=http://username:[email protected]:port

change directory to stackbuilder installation

cd path_to_stackbuilder

Then execute stackbuilder binary as below

.\stackbuilder.exe

I Hope this helps you, Thanks.