13
[SOLVED] How to install psql extention (VectorChord) in bitnami/postgresql (lemmy.world)
submitted 1 year ago by to c/selfhosted@lemmy.world
6 comments fedilink hide all child comments
 

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
[–] 4 points 1 year ago (5 children)

If you are using Kubernetes, I highly recommend investing time into installing an operator. The best open source one with less restrictive licensing is cloudnative pg. VectorChord builds official images for CNPG that includes the extension.

  • permalink
  • fedilink
  • source
  • hideshow 5 child comments
    •
  • [–] [S] 1 point 1 year ago* (last edited 1 year ago) (4 children)

    Thanks for your response, could you explain what the advantages of an operator are in this example?

    And what is the matter with the licensing? I never heard this issue before.

    The link that you attached looks like it is for the pgvecto.rs extention instead of vectorchord.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 2 points 1 year ago (2 children)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] [S] 3 points 1 year ago (1 child)

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

    Thank you for your help!

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 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.

  • permalink
  • fedilink
  • source
  • parent