Skip Navigation
Immich restore postgresql
  • 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

  • Immich restore postgresql

    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?

    11
    European Spaceflight
  • 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)

  • European Spaceflight

    So what is your opinion on the European companies? Which ones do you think will thrive and why?

    It might be a bit early but I've been going over the companies and I cannot form a solid opinion.

    5
    Caddy and forgejo

    Hi, how do you run forgejo under a reverse proxy while using an ssh channel to pull/push commits?

    From what I understand caddy is only able to proxy http traffic.

    22
    SFF machines for simple server

    Hi there,

    What SFF machines do you recommend for a server to basically run opnsense (with a 4 port expansion NIC) and a bunch of extra disks to serve as a NAS? I was looking through Thinkcentre m720, m800 et al. I believe these allow for up to 3 disks

    I know usually you'd run opnsense on a dedicated machine, but I'm a bit constrained on space so am trying to fit all in one. I don't want to stream Linux ISOs on this NAS just to store my own files.

    18
    Tailscale and two NICs

    Hi all,

    Anyone with a similar setup to this:

    I have a machine with 2 NICs one for default gateway and other a "private" subnet with a service I need to access remotely for a few days (basically its a wifi router where a wifi-only device connects).

    Will tailscale work for this case plug'n'play or will I need setup any routing?

    3
    Opnsense and one ethernet port

    Hi,

    I believe with just one port for opnsense (on a min-pc) we can still do vlans (with tagging I believe?) but how effective is that for segregating and isolating proxmox machines?

    Say I want to keep a VPN machine isolated, from other virtual machines? How would you do that? Do you have any tips for running such a system?

    4
    opnsense: Lenovo thinkcentre M600

    Hi all,

    anyone has any experience with this machine for running opnsense? I'm expecting to do mostly vlan, vpn, ad blocking, and general experimentation with opnsense. Do you advise other machines of the same or other brands? I don't expect to spend much money for now as this is mostly to get my feet wet with custom routers

    I've been looking into the Futro S920 and even though it seems a great fit, it's a bit too big. I was looking something of a smaller form factor.

    6
    InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)WI
    witx @lemmy.sdf.org
    Posts 7
    Comments 232