Skip to content

Instantly share code, notes, and snippets.

@wwerner

wwerner/grafana-postgres-datasource.yml

Created April 1, 2021 10:02
Show Gist options
  • Save wwerner/803a9569e3048fe8372d08f596c6da82 to your computer and use it in GitHub Desktop.
Save wwerner/803a9569e3048fe8372d08f596c6da82 to your computer and use it in GitHub Desktop.
Download ZIP
Example grafana datasource provisioning for postgreSQL
Raw
grafana-postgres-datasource.yml
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
@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