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

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!

Immich•14mo ago•

11 replies

Deleted User

Restoring from Backup Question

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

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!

Restoring from Backup Question

Similar Threads

Restoring from Backup Question

Similar Threads

Similar Threads

Similar Threads