kubegres
postgres-operator
Our great sponsors
kubegres | postgres-operator | |
---|---|---|
17 | 33 | |
1,284 | 3,683 | |
1.6% | 1.9% | |
7.2 | 9.0 | |
2 days ago | 6 days ago | |
Go | Go | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
kubegres
- Homelab: Running Postgres on Kubernetes
-
Run PostgreSQL. The Kubernetes Way
A good comparison with other operators here [2022]: https://blog.palark.com/cloudnativepg-and-other-kubernetes-o...
Personally I've only used Kubegres (https://www.kubegres.io/), which didn't even make the above list. It's ok for a personal project.
All k8s solutions for postgres take subtly different approaches. It seems that they've all converged on the Operator pattern. The basics are easy: run a database process which persists data to a cloud disk of your choice. The hard parts are how to update, migrate, backup, restore, monitor, failover, replicate, etc. These kubernetes "operators" promise to fulfill the role of a DBA but, just like hiring a DBA, it requires buy-in to their approach.
-
[Kubernetes] Comment déployez-vous un cluster Postgres sur Kubernetes en 2022?
Reactive-Tech / Kubegres (opérateur)
-
What are you using to run Postgres?
I like https://www.kubegres.io, it takes a little getting used to how it works. I probably wouldn't use it for a huge database, but for things under a few TB it works great.
-
Any self hostable postgres, clustering, replication and fail over system?
I don't know if you're using Kubernetes, but Kubegres is great for self hosting postgres on a cluster.
-
Managing PostgreSQL databases as K8s resources
Any experience with https://www.kubegres.io/ ?
-
Pgo: The Postgres operator from crunchy data
How does this compare with something like kubegres?
-
PostgreSQL Upgrades Are Hard
https://www.kubegres.io/ has worked well for me. You can use custom images, provided they follow the conventions of the official postgres image. I haven't tried a major-version upgrade yet - my impression is that it will probably be a bit painful and involve some downtime and manual ops.
Some of the more advanced operators might better handle the upgrade problem? But in general, I've been happy with Kubegres for a ~10GB database with low traffic.
-
Been self-hosting close to half a year now. All running on a k3s cluster of raspberry pis. Thank you to this subreddit for all the help and great ideas!
There are some great operators out there that make deployment and management easy. I use kubegres managed with pgadmin and it has been working well for me.
postgres-operator
- Deploying Postgres on Kubernetes in production
-
Jolt v0.5.2 is available!
As for the Operators, I've been using Crunchy PGO, which is very high quality, and one of the most widely used. You can install it via Helm, or via OLM from OperatorHub. There are other good ones as well, but none that I have experience with. The only issue I've run into so far is I've had to disable TLS on the database cluster, as Prowlarr refused to connect with it for some reason (Radarr was fine). I still need to open an issue with the Prowlarr team about that, but I might switch to a service mesh for TLS anyway.
-
Can someone share experience configuring Highly Available PgSQL?
The Crunchy operator, seemingly like most (if not all) of the other Postgres operators (Zalando, KubeDB, and StackGres, etc.), is essentially a wrapper for Patroni. IMO if someone wanted a Patroni cluster, they would just build one. The point of an operator is to manage the cluster resources and node relationships, so why not have it take the role Patroni is filling here? It's already reaching into the nodes, obtaining status, managing the routing, etc., so why add the extra layer?
-
Questions about Kubernetes
On the topic of Postgres, you should look into an operator or Helm chart that can setup common things (like replication and auto-failover), such as Crunchy's Postgres operator, or consider using a "cloud-native" distributed database like CockroachDB (disclaimer: I am a Cockroach Labs employee) which has its own operator as well. Another word of warning, running stateful services, particularly mission critical databases, can require a lot of maintenance work (it's my full-time job), so unless this is for a hobby project, I would highly recommend you look into using a managed database offerring. Every major cloud provider and most database companies have one.
-
My girlfriend left me... I have a K8S cluster, argocd, longhorn, traefik, metallb, on 3 optiplex mff with proxmox... This is the start gentlemen, i'll post back in 1 year. This dashboard will be full my friends, I promise, see you in the rabbit hole o/
For postgres you can also have a look at PGO or bitnami helm chart
-
Databases on Kubernetes is fundamentally same as a database on a VM
Let's say a new Kubernetes version comes out in April. In November, as everything works perfectly well, you decide to install a Postgres operator on it. Bummer, it doesn't work. It's not a huge issue, you just wait until the bug is resolved (already done[0]), but it's just one of these tiny things that I don't get when running Postrges natively. And I'm saying this as a big fan of Crunchy Data running some production loads on it without a failure for quite some time now.
[0] https://github.com/CrunchyData/postgres-operator/issues/3476
- Do people use DBs as Pods?
- Is anyone using postgres on kubernetes?
-
Pgo: The Postgres operator from crunchy data
https://github.com/CrunchyData/postgres-operator/blob/master/LICENSE.md ???
What are some alternatives?
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
longhorn - Cloud-Native distributed storage built on and for Kubernetes
postgres-operator - Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
kubebuilder - Kubebuilder - SDK for building Kubernetes APIs using CRDs
cloudnative-pg - CloudNativePG is a Kubernetes operator that covers the full lifecycle of a PostgreSQL database cluster with a primary/standby architecture, using native streaming replication
k3s - Lightweight Kubernetes
QuestDB - An open source time-series database for fast ingest and SQL queries
postgres - Unmodified Postgres with some useful plugins
charts - Bitnami Helm Charts
cloudflare-ingress-controller - A Kubernetes ingress controller for Cloudflare's Argo Tunnels
charts - ⚠️ Deprecated : Helm charts for applications you run at home