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_postgres

Then i copy the backup file to immich_postgress

docker cp backup.sql immich_postgres:/tmp/backup.sql

I 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=postgres

Everything 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

message.txt6.74KB

Immich•14mo ago•

6 replies

Lews

I am not being able to restore a backup

docker compose down -v
docker compose pull
docker compose create
docker start immich_postgres

Then i copy the backup file to immich_postgress

docker cp backup.sql immich_postgres:/tmp/backup.sql

I 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=postgres

message.txt6.74KB

I am not being able to restore a backup

Similar Threads

I am not being able to restore a backup

Similar Threads

Similar Threads

Similar Threads