I am not being able to restore a backup
Hello.
I had to backup my previous database as my hard disk failed, so i dumped it into "backup.sql"
and copied the library folder as well.
The problem occurs right now as I have to restore It, I have been trying everything but still can't stort this out.
I haven't modified anything (.env and docker-compose.yml) they're brand new from github.
These are the commands i'm executing on Windows (I have Immich on D: )
docker compose down -v docker compose pull docker compose create docker start immich_postgresThen i copy the backup file to immich_postgress
docker cp backup.sql immich_postgres:/tmp/backup.sqlI get into it
docker exec -it immich_postgres bash cat "backup.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=postgresEverything looks fine so far, It starts to copy rows, alter tables, create others etc... Eventually, these errors show up (I attached the whole log) I tried everything I could, but there's no way to get those foreign key errors out of the way. I seriously hope you can help me, I've been using Immich for a month and It has been amazing, I would lose 150gb of media.. Thank you
3 Replies
:wave: Hey @Lews,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Checklist
I have...
1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: read applicable release notes.
3. :ballot_box_with_check: reviewed the FAQs for known issues.
4. :ballot_box_with_check: reviewed Github for known issues.
5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: uploaded the relevant information (see below).
7. :ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:I did something manually which appears to be working, I've created a new account and then changed the new id with the previous one stated in the logs, this way I am now able to see all of my pictures again. However there is still an issue with that reported asset
I am sorry for opening this ticket, I did everything but read the errors. Indeed the id was always the same, and a simple query did the job. Thanks anyway!
This thread has been closed. To re-open, use the button below.