Fellow self hosting friends, I screwed up. Not only have I deleted Immich’s PostgreSQL folder but I also didn’t have backups (of the database, of the photos I do).

I’ve tried to recover the deleted folder but there’s not much left even with proper tools. I’ve checked and the photos are still there, so my question is: Is there a way for immich to rebuild the database with the photos there? Should I start from scratch and re-upload?

  • witx@lemmy.sdf.orgOPEnglish
    14·
    3 days ago

    I also wanted to mention that normally Immich dumps its own db into a file backup file somewhere. I forgot where. Check the database dump backup cron job in the settings

    Hi, thank you. This was the solution. Immich was storing its backup files to DB_UPLOAD (as defined on the .env) file. There will be a backup folder with a bunch of .sql.gz files) Picked one and ran the following command

    gunzip --stdout “/path/to/backup/dump.sql.gz”
    | sed “s/SELECT pg_catalog.set_config(‘search_path’, ‘’, false);/SELECT pg_catalog.set_config(‘search_path’, ‘public, pg_catalog’, true);/g”
    | docker exec -i immich_postgres psql --dbname=postgres --username=<DB_USERNAME>

    As documented on immich’ s website