13
submitted 1 year ago* (last edited 1 year ago) by Hercules@lemmy.world to c/selfhosted@lemmy.world

Hello,

Im planning on running a postgresql server on my k3s cluster using the bitnami/postgresql helmchart & container image. I already set it up for testing and it works really well.

But since newer versions of immich are moving to VectorChord I would like to install this extention so i can move my immich database to this postgresql server.

I already tried to search how i should/could install an extention in the bitnami/postgresql image but I haven't found something usefull to me. Im not a postgresql expert so maybe i missed some stuff :).

Does someone have experience with this or know in which direction i should like i would greatly appreciate it.

Thanks for your time and have a wonderfull day!

EDIT: Could someone explain me why im getting downvotes for this post? Is the way i wrote it not good? Is it a bad question? Is the software i mentioned unpopular?

you are viewing a single comment's thread
view the rest of the comments
[-] seang96@spgrn.com 2 points 1 year ago

Some operators for postgres is free for non commercial use, so its not truly open source even though its source available, one is crunchydata.

pgvecto.rs v0.4.0 I assumed was just not renamed. They have one for vectorchord too

Operators are good ways to support applications in CLI that aren't easy to setup in a cluster by default. You can make these databases redundant by setting replica higher than 1 and applying it, operator copies the db data and makes a new replica. It also helps with backups and restoring too.

[-] Hercules@lemmy.world 3 points 1 year ago

Oh alright, thanks a lot for your explanation. I learned a lot, im going with the operator route!

Thank you for your help!

[-] seang96@spgrn.com 3 points 1 year ago

Yeah operators are extremely nice. I used bitnami images before operator in HA setup and it would fail all the time. Using operators I have like 12 postgres DBs and 0 issues for well over a year.

Btw, self hosting communities tend to shy away from k8s due to complexity and generally enterprises use it so less selfhosters use it. I wanted redundancy and to keep me learning tech, less crazy people tend to go with proxmox for clustering in these communities.

this post was submitted on 19 Jun 2025
13 points (81.0% liked)

Selfhosted

60734 readers
199 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:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

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

Questions? DM the mods!

founded 3 years ago
MODERATORS