I would like to use a Postgres database hosted on Heroku as a datasource, but as stated in the Heroku documentation:
Heroku Postgres & SSL
Heroku Postgres databases created on the Common Runtime requires the use of SSL. Most clients will connect over SSL by default, but on occasion it is necessary to set the sslmode=require parameter on a Postgres connection.
Unfortunately, the re:dash postgres datasource does not provide any way to set this parameter. So I get an error when trying to connect to this database - and the error states that “SSL is off”.
How could I “force” this parameter sslmode to require?
As there is probably more people interested in creating dashboard using Heroku Postgres datasource, it would be great to have this setting in the datasource creation page.
Thank you for your help,