PostgreSQL as a data source

[mohan-nagandlla]

Hi team in standalone grafana we have a direct option to add grafana as a data source . In operator we have a CRD grafanadatasource I just want to add postgres add as a data source by using that CRD . Isn't possible to do like that

[david-martin]

Hi @mohan-nagandlla

Do you mean using postgres for persistent storage and HA capabilities with grafana? (https://github.com/grafana-operator/grafana-operator/tree/master/deploy/examples/ha may be of use then)

Or do you mean pulling in metrics from postgres? (in which case you may be able to figure it out from the example data sources in https://github.com/grafana-operator/grafana-operator/tree/master/deploy/examples/datasources, in conjunction with the Grafana docs https://grafana.com/docs/grafana/latest/datasources/postgres/). However I'm not familiar with postgres as a data source or if anything is missing in the GrafanaDatasource CRD to allow using it.

[mohan-nagandlla]

Yes I just want you collect the data from postgres in the metrics formate but I don't found any exam. Yaml file in that link to add postgres as a data source

[david-martin]

Thanks @mohan-nagandlla
On further inspection, it looks like what's needed is an update to the CRD to add a 'postgres' type and the corresponding field mappings,
akin to what was done for Azure #293 and Stackdriver #225

Marking this as accepted, and as a good-first-issue.
I don't see any issue with this being added.

[Voigtus]

Wanted to grab that selfishly @david-martin
Just looked through the fields, and I can not find a single one, that is missing. Or am I missing something?

Maybe just an example is needed here

[yardenshoham]

Seeing as the code and CRDs are already in place, only the example was missing. Therefore #588 fixes this issue.

[NissesSenap]

Thanks for pointing that out @yardenshoham , I'm closing the issue