grafana.init: is not handling ssl_mode when database is postgres

[dverzolla]

What happened?

I'm configuring grafana helm chart and added the config below. Grafana should consider to set ssl_mode when using postgres, that's not happening.

  grafana.ini:
    database:
      type: postgres
      host: host:5432
      name: grafana
      user: grafana
      password: xxx
      ssl_model: require

Maybe there is something related with:

grafana/pkg/services/store/entity/db/dbimpl/dbEngine.go

Line 48 in 7d386dc

// TODO: support all postgres connection options

grafana/pkg/services/sqlstore/database_config.go

Line 167 in 14a814a

case migrator.Postgres:

If I set the env var GF_DATABASE_SSL_MODE, grafana works as expected.

What did you expect to happen?

Grafana parses the ssl_mode and set into postgres sql connection.

Did this work before?

Is the first time I am configuring it.

How do we reproduce it?

Install using helm chart and configure ssl_mode.
I am using aws rds postgres v16.

Is the bug inside a dashboard panel?

No

Environment (with versions)?

Helm Chart 58.5.2:

Grafana platform?

Kubernetes

Datasource(s)?

No response