Hi community,
I have Kubernetes deployment with the following configuration yaml.
kind: Deployment
apiVersion: apps/v1
metadata:
name: grafana-test-deployment
spec:
replicas: 1
selector:
matchLabels:
app: grafana-test-deployment
template:
metadata:
labels:
app: grafana-test-deployment
spec:
containers:
- name: grafana
image: ‘grafana/grafana:latest’
ports:
- containerPort: 3000
protocol: TCP
env:
- name: GF_DATABASE_TYPE
value: postgres
- name: GF_DATABASE_HOST
value: “host_name:5432”
- name: GF_DATABASE_NAME
value: “testdb”
- name: GF_DATABASE_USER
value: “postgres1”
- name: GF_DATABASE_PASSWORD
value: “postgres1”
- name: GF_SECURITY_ADMIN_USER
value: “test”
- name: GF_SECURITY_ADMIN_PASSWORD
value: “test”
I have overridden few env variables. Here I am trying to use postgresdb which is running in the cluster to store all my data instead of the default sqlite. I am able to connect to the database as in the logs I do not see any issues. But after I create dashboards, users from the Grafana UI, where will my data be stored in the postgresdb? I mean in which table this data will be stored. I tried deleting the Pod to test whether the dashboards, users I created are retained or not. Ideally if we try to delete the Pod without any backup of the database, the data stored in the database gets deleted. But here everything is getting retained. But in the postgresdb, I am not able to see anything. No tables are visible. Have I done anything wrong with the configuration? Where has my data gone? I cross checked the sqlitedb to check whether my data still is getting stored in sqlite. But I am not able to find the “grafana.db” file which has all the tables and data.