When trying to connect to Heroku PostgresSQL DB using pgAdmin3 I'm getting the following error:
Error connecting to the server: SSL error: certificate verify failed
The connection is based on pg:credentials output and defined as below:
[Properties]:
- Host: <host>
- Port: 5432
- Service: [blank]
- Maintenance DB: <database>
- Username: <user>
[SSL]:
- SSL:
require - Server Root Certificate File: [blank]
- Server Certificate Revocation List: [blank]
- Client Certificate File: [blank]
- Client Key File: [blank]
- SSL compression: on
[SSH Tunnel] and [Advanced] left default
so as per Heroku guidelines SSL is enabled (set to: [**require**]).
Any ideas how to provide/fix the certificate referred by the error message?
