A completely fresh install of Cloudron v7.7.0 and Immich v1.55.0-1 moments ago resulted in the following error preventing Immich from starting up:
2024-03-12 04:51:08.767 UTC [104] usere...@dbe... ERROR: permission denied to create extension "earthdistance"
2024-03-12 04:51:08.767 UTC [104] usere...@dbe... HINT: Must be superuser to create this extension.
2024-03-12 04:51:08.767 UTC [104] usere...@dbe... STATEMENT: CREATE EXTENSION IF NOT EXISTS earthdistance
To resolve, I used the info for Postgres recovery from the other recent Immich update issue thread to drop in to the service's container in recovery mode, and ./start.sh &
Per the discussion on Immich Github, I temporarily elevated the username from the logs above (obfuscated) with alter user usere... with superuser;
, started Immich, and then alter user usere... with nosuperuser;
.
Cleaned up by exiting the Postgres shell, disabling recovery mode for the service, and systemctl restart box
.
Install appears fine now!