This guide assumes you’re running Immich using the recommended installation method.

connect to the postgress database docker container

docker exec -it immich_postgres bash

connect to the postgress shell in the container and load the immich database

psql immich postgres

check which users are currently admin users

immich=# select email,"isAdmin" from users;

promote an existing user to the admin role

UPDATE users SET "isAdmin"='t' WHERE email='[email protected]';

And that’s it!