Skip to content

Instantly share code, notes, and snippets.

@wwerner
Created April 1, 2021 10:02
Show Gist options
  • Star 11 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save wwerner/803a9569e3048fe8372d08f596c6da82 to your computer and use it in GitHub Desktop.
Save wwerner/803a9569e3048fe8372d08f596c6da82 to your computer and use it in GitHub Desktop.
Example grafana datasource provisioning for postgreSQL
apiVersion: 1
datasources:
- name: Postgres
type: postgres
url: localhost:5432
database: grafana
user: grafana
secureJsonData:
password: "Password!"
jsonData:
sslmode: "disable" # disable/require/verify-ca/verify-full
maxOpenConns: 0 # Grafana v5.4+
maxIdleConns: 2 # Grafana v5.4+
connMaxLifetime: 14400 # Grafana v5.4+
postgresVersion: 903 # 903=9.3, 904=9.4, 905=9.5, 906=9.6, 1000=10
timescaledb: false
@krtvelaz
Copy link

Many thanks

@abalhomaid
Copy link

Thank you for sharing

@2o1o0
Copy link

2o1o0 commented Jan 30, 2023

That definitly helped a lot! Thanks!

@danjamespearce
Copy link

Thank you!

@sva-mk
Copy link

sva-mk commented May 16, 2023

Thanks a lot!

@ddoice
Copy link

ddoice commented May 29, 2023

Thank you!, the documentation on this subject is really poor.

@wulfharth7
Copy link

thanks a lot

@hexvolt
Copy link

hexvolt commented Nov 22, 2023

For those who needs it editable - editable: true

@MiltiadisKoutsokeras
Copy link

Has anyone tried to connect to Google Cloud SQL Postgresql instances using the Google Cloud SQL Auth Proxy?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment