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

help-circle




  • Are you out of your mind? SpaceX didn’t buy a single thing, they developed and tested existing ideas (the reusability at least). I mean the guy is a total douche and Nazi but why spread these lies about SpaceX? I agree though that America’s future in space shouldn’t rely on SpaceX due to their affinity to a Nazi, and more funding should be given to NASA and other commercial endeavours

    This forum seems like Reddit sometimes but on the other end of the political spectrum












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