I'm looking for advice on what PostgreSQL solution to use for running a production workload in 2025. We're onboarding a critical application that needs to avoid any data loss, and due to server provisioning constraints, we're moving to Kubernetes. We want to create a production-grade setup quickly without needing all server resources right away.
Here's what we're working with:
- Servers with dense CPU and memory
- Raw HDDs and SSDs
- Kubernetes
Our goals include having an easy-to-setup and maintain solution, scalability, robust backups, true persistence, read replicas, and monitoring via dashboards. Given these requirements, what would you recommend for running PostgreSQL 18? Is Kubernetes still a challenging landscape for managing database workloads?
5 Answers
A lot of folks find Kubernetes tricky for stateful workloads, but I think it depends on the context and configuration. We're currently running our PostgreSQL workloads in Kubernetes as a stateful set, managing replication and failover with persistent volume claims to ensure reliability.
Using dedicated bare metal really only makes sense if you have special performance tuning needs. Otherwise, I believe CloudNative-PG hits the sweet spot, particularly with its Grafana dashboard for monitoring. Just make sure your storage setup is well-thought-out.
I love working with Cloud Native PostgreSQL! We use it for a high-profile project and haven’t faced any issues. The built-in S3 backups are a game changer, offering great recovery options if needed.
I'd recommend CloudNative-PG for your needs; it's pretty comprehensive and meets all your requirements. I'm not entirely sure what "true" persistence means in this context, but it lets you use PVCs, which should cover that. Plus, it's stable and easy to get started with.
If you’re looking for a bit of flair, StackGres offers a nice UI along with solid functionality. It's quite user-friendly and has been stable for us.
Related Questions
How to Build a Custom GPT Journalist That Posts Directly to WordPress
Fix Not Being Able To Add New Categories With Intuitive Category Checklist For Wordpress
Get Real User IP Without Installing Cloudflare Apache Module
How to Get Total Line Count In Visual Studio 2013 Without Addons
Install and Configure PhpMyAdmin on Centos 7
How To Setup PostfixAdmin With Dovecot and Postfix Virtual Mailbox