Though I can list the users (i.e. accounts) of my Metabase Application Database (MAD) in PostgreSQL (v14) environment by means of metabase API (https://mydomain/api/user?status=active), I can't see those users in the core_user table in the public schema of the MAD (namely "metabase") using pgAdmin connected to the ubuntu server at , as shown below.
Regards,
I searched for "metabase.db.mv.db" using the linux command "find / -name metabase.db.mv.db" and got the message " ‘metabase.db.mv.db’: No such file or directory" which means that I have been successful to migrate initital MAD in H2 into PostgreSQL as explaned at https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html as well as at Redirecting…
Attached is the screenshot of my commands at Ubuntu server which I ınstalled metabase at.
Regards, Dr. Hayati TASTAN
@haytastan Just because you have migrated from H2 to Postgres doesn't mean that the H2 file has been removed, since that is not done via the migration automatically, nor does it tell how you are running Metabase, or if you have called the H2 database something differently.
Post "Diagnostic Info" from Admin > Troubleshooting.
the content of my my envirenment file:
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin"
JAVA_HOME=“/usr/lib/jvm/java-11-openjdk-amd64/bin/java”
MB_DB_TYPE=postgres
MB_DB_DBNAME=metabase
MB_DB_PORT=5432
MB_DB_USER=metabase
MB_DB_PASS=metabase
MB_DB_HOST=localhost
I selected /usr/lib/jvm/java-11-openjdk-amd64/bin/java using the command sudo update-alternatives --config java
And I reactivated the envirenment variables using the command: source /etc/environment