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.

  • 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 😉