Postgres issue v7.7.0

[contactlight11]

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!

[girish]

@contactlight11 thanks for reporting. that seems like a bug, investigating.

[girish]

@contactlight11 this is fixed now. 7.7.1 coming.