How to connect my Aiven PG database to Grafana Cloud?

Aiven Community
1

Hello to everyone.

When trying to connect my PG Aiven database to Grafana Cloud/ Grafana requires a TLS/SSL Client key. If I go to overview of my Aiven service, it only shows the Client certificate.

And when trying to “Save & test” in Grafana Cloud, it says: TLS/SSL client certificate and key must both be specified

2

Hi Daniel,

I’m not super familiar with Grafana Cloud, but I tried the following with a free account and an Aiven for Postgres and it Worked On My Machine ™:

Navigate to Connections > Data Sources and Add new Data source. Select PostgreSQL from the list.

Use the following:

  • Host URL: Aiven ‘Host’ field:Aiven ‘Port’ field, i.e. pg-SomeRandomNumber-ProjectName-username.c.aivencloud.com:19508 or similar.
  • Database name: defaultdb
  • Username: avnadmin
  • Password: The password field
  • TLS/SSL mode: verify-ca → This is the important one, I think!
  • TLS/SSL method: Certificate content
  • TLS/SSL Auth details → TLS/SSL Root Certificate: Copy and paste the contents of the CA certificate here.

You shouldn’t need to fill out any of the other fields in the TLS/SSL Auth details section and it should connect. :slight_smile:

1 Like
3

Thanks! It worked. I was adding the cert file in the wrong place.

1 Like