Hi everyone,
I am setting up the local instance of Metabase.
I am performing migration from H2 to Postgres (local).
I set the env var for connection string.
export MB_DB_CONNECTION_URI="jdbc:postgresql://localhost:5432/metabase?user=postgres&password=P@ssw0rd"
After I started migration by command:
java --add-opens java.base/java.nio=ALL-UNNAMED -jar metabase.jar load-from-h2 /Users/username/Tools/Metabase/metabase.db
As you can see there is "@" in the connection string.
I am getting the following error:
2025-02-08 13:24:25,837 WARN postgresql.Driver :: JDBC URL must contain a / at the end of the host or port: jdbc:postgresql://ssw0rd
2025-02-08 13:24:25,837 WARN postgresql.Driver :: JDBC URL must contain a / at the end of the host or port: jdbc:postgresql://ssw0rd
2025-02-08 13:24:25,839 WARN postgresql.Driver :: JDBC URL must contain a / at the end of the host or port: jdbc:postgresql://ssw0rd
And Metabase loops a little bit and fails with error:
Unable to parse URL jdbc:postgresql://ssw0rd
I tried to escape "@" inthe connection string but getting the same result.
Am i doing something wrong?