[SOLVED] How to install psql extention (VectorChord) in bitnami/postgresql
-
wrote last edited by [email protected]
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?
-
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?
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.
-
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.
wrote last edited by [email protected]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.
-
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.
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.
-
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.
Oh alright, thanks a lot for your explanation. I learned a lot, im going with the operator route!
Thank you for your help!
-
Oh alright, thanks a lot for your explanation. I learned a lot, im going with the operator route!
Thank you for your help!
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.
-
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.
Just to clarify, VectorChord is actually the company that makes pgvecto.rs (the postgres vector extension), so you're both talking about the same thing lol.