-
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 earthdistanceTo 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 thenalter 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!
-
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 earthdistanceTo 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 thenalter 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!
-
N nebulon marked this topic as a question on
-
G girish has marked this topic as solved on
-
G girish moved this topic from Immich on
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login