PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15673
PG Version11.2
OSWindows 10
Opened2019-03-06 17:28:27+00
Reported byJacob Stevens-Haas
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15673
Logged by:          Jacob Stevens-Haas
Email address:      (redacted)
PostgreSQL version: 11.2
Operating system:   Windows 10
Description:        

I installed PostgreSQL 11.2 on my work PC on my work network for a DB
management project (all default settings).  Following the project
instructions, I ran stackbuilder, selected the PostgreSQL installation on
port 5432, and hit 'next'.  

Error:
A certificate verification problem was encountered whilst accessing
https://www.postgresql.org/applications-v2.html schannel: next
InitializeSecurityContext failed: Unknown error (0x80092012) - The
revocation function was unable to check revocation for the certificate. 
This means that the source of the download cannot be verified (description
of what revocation failure means, risks)... Do you wish to continue?

I hit yes, but then a new dialog box appears with the same error, this time
fatal "Couldn't access the URL
https://www.postgresql.org/applications-v2.html.  Error: next
InitializeSecurityContext failed: Unknown error (0x80092012) - The
revocation function was unable to check revocation for the certificate.  

I believe my work network has some strong security settings, such as SSL
interception and re-signing, but I'm no expert.  https://www.postgresql.org
appears trusted in browsers, but if I open a python session and
`requests.get('https://www.postgresql.org', verify = True)`, then I get an
SSL error.  Getting off the work network solves both the requests.get and
the stackbuilder issue.

Messages

DateAuthorSubject
2019-03-06 17:28:27+00PG Bug reporting formBUG #15673: Stackbuilder SSL error on corporate network that uses SSL interdiction/resigning