Why can't my third-party utility connect to Heroku Postgres with SSL?

Issue

  • You are attempting to connect to your Heroku Postgres database with a third-party tool, such as Amazon Quicksight. This tool is trying to use SSL verification but the connection is failing.
  • You are trying to find the CA files or certificate for your Heroku Postgres server.

Resolution

Amazon Quicksight and similar tools require that SSL connections be negotiated with CA-verifiable certificates. Heroku Postgres does not currently support verifiable certificates. Our certificates will change when the underlying hardware has issues and we move your database away from it. As such, these tools cannot be used with Heroku Postgres unless you can configure them to use traditional username/password authentication.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2018 Salesforce.com