Search This Blog

Monday, August 2, 2021

Grafana Cloud - Connect to PostgreSQL in Heroku

Providing Hostname, Database, Username and Password was just not enough and it worked after some hit and trial changing other settings.

Grafana is a wonderful open-source Business Intelligence software that you can host on your premise or subscribe to the cloud offering. I had my Django app deployed on Heroku with a PostgreSQL database.

I tried to create a new connection in Grafana cloud to the PostgreSQL cloud with default settings but it was throwing an error 400, which is basically a bad request that the server would reject. The error did not specify details about the error. 

The default setting for TLS/SSL mode is 'verify-full'. I had to change it to 'require' and the connection was successful. Below is a screenshot with all the settings.

grafana postgresql connection

If you are in a same situation, just give it a try. Feel free to post any questions or comments.


1 comment:

danish said...

I Like to add one more important thing here, Healthcare Business Intelligence (BI) Market by Component (Platform, Software, Service), Function (OLAP, Performance Management), Application (RCM, Inventory, Strategy Analysis), Deployment Model (Cloud, Hybrid) & End User (Payer, Hospital) – Forecast to 2021-2026 -Executive Data Report.