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?

  • gezero@lemmy.bowyerhub.ukEnglish
    16·
    3 days ago

    I am only a solo user that tried similar recovery.

    There are several jobs in the admin section, one of them is “migrate the storage template” or something like this. I think that thing might do what you want. I would check that it is set properly depending on what you were using previously and rerun in. https://immich.app/docs/administration/storage-template/

    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.

    • 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