ImmichI
Immich•13mo ago
Deleted User

Restoring from Backup Question

I was uploading a huge set of Google Takeout files with Immich-Go and the next morning it looked like my database was corrupted. I am not sure what happened as I have done this 50 or so times before this. Either way, I would love some help restoring.

Background:
I am running Docker on Windows 11 with Immich in Portainer. The computer is a 10-Core i5 setup with 32GB of RAM.

Items I have attempted:
  • Updating to the latest version (twice)
  • Removing the Stack completely and re-adding Immich
Backup & Restore FAQ
I am following https://immich.app/docs/administration/backup-and-restore/

I have most of it except the last most important part and the part that asks you to mount the file.

The following gives this error: No such file or directory. I have tried both "/" and "" 

cat "P:\immichdbbackup\backups\immich-db-backup-1734141600005.sql\immich-db-backup-1734141600005.sql \
| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \
| psql --username=postgres


Any ideas? Thanks!
Was this page helpful?