How can we help?

New post
3

SSL Support for Postgres

Avatar
Brett Allred
None
Follow
Direct SQL connections currently support SSH tunneling but it doesn't support basic SSL connections. Add support for SSL mode allow prefer require
Date Votes

9 comments

  • 4
    Avatar
    Mark Vletter
    Guys, if you fix one thing. Fix this. Anybody using any Amazon / Heroku like services uses this and from a security standpoint it's a must.
  • 2
    Avatar
    Cristian M

    Same here. Need Heroku PG datasource or I will need to build an API only to fetch DB data. Thanks

  • 0
    Avatar
    Timothy Carbone

    +1 for Heroku PG. I'm in the trial period and this prevents from doing anything so ...

  • 0
    Avatar
    Stephen Yates

    Thank you all for the feedback. We are preparing a specification for developing this feature and would like your input on validation. Is it enough to connect to the database over SSL without validation, or would you require us to either perform validation of PostgreSQL server certificate or client-side validation?

  • 0
    Avatar
    CRISTIAN MOLINA

    That is a great news Stephen. I'm not sure about the SSL requirements. There is somethink here . I think, the best approach  is to check it with Heroku help support itself. 

    I'll be waiting for the completion of this feature.

    Kind regards

      Cristian M

     

  • 0
    Avatar
    Timothy Carbone

    Good news!

    I don't think you need any validation .... a simple connection over SSL would work. But don't take my word for it.

    Thank you! I'll be waiting the completion too :)

    Tim

  • 0
    Avatar
    CRISTIAN MOLINA

    As an alternative to fetch the data, can I use Heroku dataclips? https://devcenter.heroku.com/articles/dataclips 

     

    Thanks

  • 1
    Avatar
    Nikta Kanuka

    Hey guys,

    Good news! We now support SSL for PostgresSql (with no validation). You'll find a checkbox for SSL when you go to create you Postgres data source.

    Let us know if you have any questions or feedback, thanks!

    Nikta

  • 0
    Avatar
    Franck van der Sluis

    Where can the certificates be added for the SSL connection?

Please sign in to leave a comment.