Migration from sqllite to Postgres using windows

Grafana Configuration
1

Hello There, today i’m work on project that I need use the windows server with grafana, but the for policy I can’t use the sqllite, so I will need migrate to postgres, I was try some times but my service not start.

I used also the “Full convert software”, to convert sqllite on postgres.
There another way to migrate?

image

image
image1855×343 31.5 KB

2

is this a fresh grafana install or an existing one? if an existing one how many dashboards does it have?

3

There is an existent, I have only two dashboard

4

If nothing else other than those 2 dashboards keep it simple

Export the dashboards’ JSON

Spin the new grafana pointing to postgres

Import the dashboards’ JSON

Or even simpler just recreate the dashboards on new server

Or stop current grafana service, change ini file to point to postgres. Then start service then on same grafana recreate dashboards

5

My question is, I need just appoint the ini file to Postgres and the database Will be created automatically? Or I need to do something to recreate the grafana structure on db

1 Like
6

You first need to manually create the database with proper permission for the grafana user

Then when you restart the grafana service it should recreate all the tables

7

Thanks!! Its work for me!

1 Like