abernuzzi/metabase repository overview

<1.0.0> METABASE/METABASE + POSTGRESQL

a) metabase/metabase (ver. 040x)

b) PostgreSQL as application DB: leveraging an existing (dedicated) PostgreSQL server running in a dedicated container Needed to address to issues:

b1) issue nr 1: Metabase not finding a DB named "metabase" in PostgreSQL solution --> manually create a DB named "metabase" within postgres server via psql (postgres command-line interface)

b2) issue nr 2: After addressing issues nr 1, Metabase was connecting to PostgreSQL and finding DB "metabase" but couldn't migrate from internal H2 DB to postgres Analyzing container log, I discovered it was a setting issues:: "Metabase Initialization FAILED java.lang.Exception: Database has migration lock; cannot run migrations. You can force-release these locks by running java -jar metabase.jar migrate release-locks." solution --> manually executed multiple times (because metabase server was continuosly stopping-restarting) the command indicated in the error message from a terminal windows on localhost because wasn't able to access the container:

                  sudo docker exec -it -u 0  mvd_metabase java -jar /app/metabase.jar migrate release-locks

I had to re-execute many times it untill (with a little of luck) I found the "right moment to execute" among a stop and restart of the container. Note: I think it was fundamental the use of the flag "-u 0" which execute the command within the container as user with privileges!!!