Managing extensions is one of the biggest challenges in running PostgreSQL on
Kubernetes. In this article, I explain why I believe
CloudNativePG
—now a CNCF Sandbox project—is on the verge of a breakthrough.
Two important new features for both PostgreSQL and Kubernetes—the
extension_control_path option and image volumes—will guarantee immutability
to extension container images.
CloudNativePG has surpassed 5,000 stars on GitHub! More than just a number, this achievement reflects the trust, enthusiasm, and collaboration of the Postgres and Kubernetes open-source community. I look back at the journey, acknowledge the incredible contributions from users and maintainers, and invite everyone to join us in shaping the future of cloud-native PostgreSQL.
2024 was a transformative year for CloudNativePG, marked by significant contributions to the Kubernetes ecosystem, increased adoption, and a growing community. This article reflects on key milestones, including the integration of advanced Kubernetes features, conference highlights, and personal insights, while looking ahead to the opportunities awaiting PostgreSQL in the cloud-native era.
CloudNativePG 1.25 enhances control of PostgreSQL synchronous replication with a new dataDurability option, allowing you to choose between prioritising data consistency or self-healing capabilities. This article explains the feature, contrasts it with previous approaches, and provides guidance on migrating to the new API format.
This recipe shows how to perform an online major PostgreSQL upgrade using the
new declarative approach to logical replication introduced in CloudNativePG
1.25. By leveraging the Publication and Subscription CRDs, users can set up
logical replication between PostgreSQL clusters with ease. I will walk you
through configuring a PostgreSQL 15 publisher, importing schemas into a
PostgreSQL 17 subscriber, and verifying data synchronisation, with the broader
goal of highlighting the benefits of a repeatable and testable upgrade process.
In this CNPG recipe, we explore three essential command-line tools that
simplify working with CloudNativePG in Kubernetes: view-secret, view-cert,
and stern. These tools enhance tasks such as inspecting secrets, verifying
certificates, and tailing logs across multiple pods, streamlining your
PostgreSQL management experience in a cloud-native environment. Whether you’re
troubleshooting or optimising workflows, these utilities will help you boost
productivity and gain better control over your Kubernetes-based PostgreSQL
deployments.
Welcome CNPG Playground, a local learning environment for exploring CloudNativePG and PostgreSQL in Kubernetes. Using Docker and Kind, it simulates real-world scenarios, enabling developers and DBAs to experiment with PostgreSQL replication across two clusters. Designed for hands-on learning, CNPG Playground provides an accessible entry point for testing configurations and features, with plans for future enhancements and community collaboration.
CloudNativePG 1.24 introduces a highly customisable approach to managing
PostgreSQL synchronous replication through the new .spec.postgresql.synchronous
stanza. In this article, I’ll guide you through configuring synchronous
replication within a single Kubernetes cluster and across multiple clusters.
I’ll explore quorum-based and priority-based replication methods, highlighting
their benefits and trade-offs. Additionally, I’ll explain how to adjust the
synchronous_commit setting to strike the right balance between data
durability and performance.
In this article, I’ll explore how Kubernetes and CloudNativePG can be leveraged to streamline the testing of PostgreSQL patches, especially during a Commitfest. By automating the creation of PostgreSQL container images from any public Git repository, developers and reviewers can quickly and efficiently test patches within a Kubernetes environment. This approach not only saves time but also enhances the reliability of patches before integration into the main codebase.
In this article, I’ll introduce you to the new service template feature in
CloudNativePG 1.24, which greatly simplifies the creation of services such as
LoadBalancer to expose PostgreSQL outside of your Kubernetes cluster -
particularly useful for streamlining Database-as-a-Service (DBaaS) deployments.
I’ll walk you through setting up this feature on your laptop using kind and
cloud-provider-kind, ensuring you can easily test and implement these
capabilities in your own environment.