Is CloudNativePG Ready for Production Use in a Multi-Site Setup?

I recently transitioned part of my setup from Bitnami PostgreSQL-HA to CloudNativePG, and it was surprisingly smooth! The migration was easy, and the upgrades have gone without a hitch. I'm now experimenting with a multi-cluster, multi-region setup, and so far, the results are looking good. I even simulated node failures, and the application continued to operate in read-only mode. When the primary node went down, a new primary was quickly elected, and the system handled everything seamlessly on its own. Also, the backup system has been fantastic, with WAL files being streamed directly to my storage without any manual intervention.

We have several PostgreSQL clusters with CNPG, and while earlier versions had their quirks, the current version works well overall. It’s been stable for us.

Just to clear things up, CNPG is definitely production-grade. It’s been adopted by several big names, including Microsoft, and the enterprise-grade ElephantDB service is built on top of it. So you can feel confident about using it!

We've had CNPG running for 1.5 years through our hosting service provider, and so far, it hasn’t let us down. We’re planning to take over the DB cluster once we’re ready. It's a smaller database scenario (roughly 500 gigs), and while we haven't tested failover or backups yet, it’s been operating smoothly. Just a heads up, it runs on VMware vCloud storage with Tanzu.

We've been using CNPG across different clusters and cloud providers for various database needs, from lightweight applications to mission-critical setups. It's been reliable overall.