Dear community! Hope you all are doing great.
I’m self hosting my database in a hostinger server. My question is: what happens to my metabase configuration (users, dashboards, questions, etc) if this server is restarted? Will I lose everything that I’ve built?
Thanks in advance
Bye!
How did you install Metabase and where are you storing the app database?
If you’re running Metabase in the base OS (i.e., running java … -jar metabase.jar manually or with a start script), then it should be safe. If you didn’t set the environment variables to configure an app database, it’s using an H2 database on the filesystem. H2 has durability issues, so it’s recommended to migrate the app database to a supported RDBMS, such as PostgreSQL. Migration instructions are here.
If you are using the Docker image, it’s probably going to poof if you restart the container, unless you modify the Docker config to add persistent storage, configure an external app database, or rollback the container. More information about Metabase on Docker here.
If you’re using H2 (the default) to store your dashboards, it’s a case of when, not if, you lose all your work. That’s regardless of how you deploy Metabase.
First step of any install is to create a persistent Postgres database.