Migrate H2 Database to PostgreSQL

Get Help
1

Hello,

I'm trying to migrate my H2 database to my PostgreSQL using this command

export MB_DB_TYPE=postgres
export MB_DB_CONNECTION_URI="jdbc:postgresql://<host>:5432/metabase?user=<username>&password=<password>"
java -jar metabase.jar load-from-h2 /path/to/metabase.db

but im getting stuck on the "Copying instances of ViewLog..."

Captura de ecrã 2024-10-17, às 21.29.40
Captura de ecrã 2024-10-17, às 21.29.401920×706 170 KB

2

it's probably taking a lot of time or simply it's struggling with memory

3

Probably, it's normal even if the migration is stuck on View Log that i dont have any data on core_user schema (email,password etc..)?

4

Clear the log and query tables before migrating.
That said, your original question was 13 hours ago - has it finished yet?