this post was submitted on 01 Feb 2025
46 points (96.0% liked)

Selfhosted

41638 readers
610 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 2 years ago
MODERATORS
 

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.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 4 points 1 day ago (1 children)

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...

[–] [email protected] 3 points 1 day ago (1 children)

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).

[–] [email protected] 1 points 1 day 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 😉