I thought of a weekly thread to post about what you set up lately, what kind of problems you currently think about or are running into, what new device you added to your homelab or what interesting service or article you read.

So I decided to just try it. Maybe we find a format that works! It doesn’t have to be me, feel free to create this post on Sunday if it’s not up already.

  • SayCyberOnceMore@feddit.ukEnglish
    4·
    11 hours ago

    Updated my NAS recently and Immich’s database stopped working due to some PostgreSQL update that needs something changed manually, so I need to get my head around that.

    Also trying to get a tablet to run as a 2nd satellite for HomeAssistant voice commands and no matter what I do, only the 1st one responds to wakeword… but I tend to give up after everyone’s gone to bed as I’m literally in a room on my own talking to myself…

    • buedi@feddit.orgEnglish
      3·
      11 hours ago

      PostgreSQL Updates AFAIK require manual Backup / Restore of the Database. But better look that up. I think the last one I did was:

      1. Stop the Application Containers (here the Immich ones, so only PostgreSQL runs)
      2. Backup the Database
      3. Stop the PostgreSQL Container
      4. Change to the new PostgreSQL Version
      5. Start the PostgreSQL Container
      6. Restore the Database
      7. Start the Application Containers

      As I said, better look it up first, this is just how I remember the process (but not the backup / restore commands).

      • SayCyberOnceMore@feddit.ukEnglish
        1·
        3 hours ago

        Ok, thanks. Yeah, I don’t use PostgreSQL much, so I have to get my head into it.

        That said, it’s only for Immich, so I could just wipe it and start again which might be quicker… it only took 3 days to scan the photos, it might take me longer to update the database 😉