• 2 Posts
  • 8 Comments
Joined 2 years ago
cake
Cake day: August 14th, 2023

help-circle




  • witx@lemmy.sdf.orgOPtoSelfhosted@lemmy.worldImmich restore postgresql
    link
    fedilink
    English
    arrow-up
    13
    ·
    edit-2
    10 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





  • And do you think all these new companies (RFA, PLD and Isar) will thrive? Is it the case that Europe cannot let any of them fail and thus will try to “keep them afloat”? I personally see it very risky to have just one, or two, companies with a newer mentally (as opposed to Ariane et al which I see as more conservative and unable to even try to keep up with American companies)