What's the Deal with Cloud Native PG and PostgreSQL Versions?
Asked by
LearningK8sNinja89
I've been diving into Kubernetes recently and trying to understand the database landscape, especially around StatefulSets, PVCs, and distributed storage. I keep hearing about Cloud Native PostgreSQL (CNPG) being recommended over traditional PostgreSQL. Since I'm already familiar with PostgreSQL version 18, I'm curious about why CNPG seems to be tied to version 16. When I look up CNPG, I see information suggesting it only supports older versions. Is it really the case that I would need to settle for PostgreSQL 16 if I choose not to migrate my database endeavors to a cloud provider? What's the complexity they're talking about, and how does that impact someone learning about the ecosystem like me? Any insights would be appreciated!
Answers
It's tough to give tailored advice without knowing what you're aiming to do with PostgreSQL. But don't let outdated info fool you—CNPG certainly supports PostgreSQL 18. Running your own clusters for production can get complex, but practicing with Kubernetes can really help build your skills. I personally love using CNPG!
Reply to this answer
You're not alone in this confusion! I've got multiple CNPG clusters running on PostgreSQL version 18 myself. CNPG does a great job with backups, failover, and clustering, making it super easy to manage. If I had to set up a Kubernetes cluster just to run a database, I'd totally do it!
Reply to this answer
Sounds like you stumbled upon old documentation that showed support for versions up to 16, which was from a few years back. Just check out the latest docs for what you're looking for now. And yeah, definitely take caution when trusting AI suggestions; they can be misleading sometimes.
LearningK8sNinja89: Right? It's frustrating when the top search links are outdated. Thanks for the insight!
Reply to this answer
What’s your cluster specification like? Typically, the DB image will come from a set of established images in the CNPG repository. Might be worth checking what’s available!
LearningK8sNinja89: I don’t have a cluster spec yet; I'm still figuring everything out! Planning to use tech like Cilium and GitOps with FluxCD. It’s a work in progress!
Reply to this answer
All supported versions of CNPG actually support PostgreSQL 18, so you're looking at the wrong documentation. Check this link for the latest supported releases—it's all there!
QueryMaster94: Thanks for the heads up! I was stuck on the outdated docs, glad to have clarity now.
Reply to this answer
Add your answer
Answers are reviewed before publication.
CloudyDataReader: I hear you! I was reading similar docs and couldn’t understand why they kept sending me to outdated pages. Glad to see others are getting it right!