Configure Default Database for Grafana

• Added postgres as the default db for grafana instead of the default sqlite database
  • Started postgres with docker
    • docker run -d -p 5432:5432 --name=postgres -e POSTGRES_PASSWORD=hehe -v postgres-data:/var/lib/postgresql/data postgres
  • created a new user grafana in it
    • launch psql inside the container
      • docker exec -it postgres bash
    • launch psql as user postgres and db postgres
      • psql -U postgres
    • create new user for grafana
      • create user grafana with password 'grafana';
      • Assign it createdb permissions: alter user grafana createdb;
    • quit from postgres db
      • \q
    • launch psql as user grafana and db postgres
      • psql -U grafana
        • this will throw an error as it tries to find a database with the same name as the user, ie, grafana in our case
      • so run psql -U grafana -d postgres
    • now create a new grafana database
      • create database grafana;
    • quit
      • \q
    • test launching it with grafana
      • psql -U grafana
  • test it's connection in dbeaver
  • now create new grafana container with grafana database in postgres
    • docker run -d -p 3010:3000 --name=grafana --volume grafana-storage:/var/lib/grafana -e "GF_DATABASE_TYPE=postgres" -e "GF_DATABASE_HOST=13.53.54.198:5432" -e "GF_DATABASE_NAME=grafana" -e "GF_DATABASE_USER=grafana" -e "GF_DATABASE_PASSWORD=grafana" grafana/grafana-enterprise
    • these are the environment variables needed to configure the default database in grafana. all the environment variables can be found here: https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/
    • the environment variables are formatted as: GF_<SectionName>_<KeyName>
    • eg:
      • 
  • login and create admin user (username: admin, password: admin). everything will be reset as the database is changed.
  • after adding the user and setting up new password, in our case, admin. check the users table in the db.
    • we see we have the grafana database along with the default postgres database:
      • 
    • we have all these tables in it:
    • let's open the users table. we see we indeed have the admin user we created in the db:
• that's all for today mainly. next let's setup some datasources.