Error restoring Database

🚧Setup

Solved🗄️Server

Immich App Version: v2.5.6
Version: v1.11.17 (Hosted via TrueNAS Scale)

I'm trying to reinitialize a new Immich instance since my old one's DB corrupted when updating from v2.5.1 to v2.5.3. (see help-desk-supportError at very end of restoring DB backup)

Essentially have database backup files

immich-db-backup-20260204T020000-v2.3.1-pg15.14.sql

immich-db-backup-20260204T020000-v2.3.1-pg15.14.sql

, but when trying to restore using the onboarding UI option on v2.5.6, I keep running into the below error after several seconds/several percent of the restore process.

Error: /usr/lib/postgresql/15/bin/psql non-zero exit code (2)
ERROR:  current user cannot be dropped
ERROR:  role "immich" already exists
\connect: connection to server at "pgvecto" (fdd0:0:0:6::4), port 5432 failed: FATAL:  password authentication failed for user "immich"

Error: /usr/lib/postgresql/15/bin/psql non-zero exit code (2)
ERROR:  current user cannot be dropped
ERROR:  role "immich" already exists
\connect: connection to server at "pgvecto" (fdd0:0:0:6::4), port 5432 failed: FATAL:  password authentication failed for user "immich"

Immich•2mo ago•

173 replies

devalto

Error restoring Database

🚧Setup

Solved🗄️Server

immich-db-backup-20260204T020000-v2.3.1-pg15.14.sql

immich-db-backup-20260204T020000-v2.3.1-pg15.14.sql

, but when trying to restore using the onboarding UI option on v2.5.6, I keep running into the below error after several seconds/several percent of the restore process.

Error: /usr/lib/postgresql/15/bin/psql non-zero exit code (2)
ERROR:  current user cannot be dropped
ERROR:  role "immich" already exists
\connect: connection to server at "pgvecto" (fdd0:0:0:6::4), port 5432 failed: FATAL:  password authentication failed for user "immich"

Error: /usr/lib/postgresql/15/bin/psql non-zero exit code (2)
ERROR:  current user cannot be dropped
ERROR:  role "immich" already exists
\connect: connection to server at "pgvecto" (fdd0:0:0:6::4), port 5432 failed: FATAL:  password authentication failed for user "immich"

Error restoring Database

Similar Threads

Error restoring Database

Similar Threads

Similar Threads

Similar Threads