Grafana MySQL -> PostgreSQL migration

[yosiasz]

that would be brutal approach.

here is one

Migration from sqlite3 to postgres

What happened? I am trying to move data in tables from sqlite do postgres. The problem with when in table, for example dashboard is field in json format. In table dashboard column data describes dashboard which is written. In sqlite data in column named dats in written in diffrent way than in postgres. In sqlite column data starts with with “7B22…”. When I copy directly value of this column to postgres db grafana doesn’t read it and dashboard is not able to be opened. I have checked that in pos…

and this

Migrate Grafana SQLite DB to Postgresql for High Availability | by Yashraj Dighe | Medium.