Skip to main content
Gabriele Bartolini

Gabriele Bartolini

VP of CloudNative at EDB | PostgreSQL contributor | DoK Ambassador | CloudNativePG Maintainer

Navigating the uncharted waters of PostgreSQL within Kubernetes using open-source technologies, I bring a wealth of expertise to the table as a KubeCon speaker, Data on Kubernetes Community Ambassador, maintainer of the CloudNativePG Operator, and author of Postgres books. My passions are DevOps, High Availability, Disaster Recovery, Very Large Databases (VLDB) and data warehousing with PostgreSQL. I’m VP of CloudNative at EDB. Opinions are my own.

Recent

CNPG Recipe 14 - Useful Command-Line Tools

·4 mins

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.

CNPG Playground: A New Learning Environment for Postgres in Kubernetes

·3 mins

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.

CNPG Recipe 13 - Configuring PostgreSQL Synchronous Replication

·7 mins

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.

How to test a PostgreSQL Commitfest patch in Kubernetes

·7 mins

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.

CNPG Recipe 12 - Exposing Postgres outside Kubernetes with Service Templates

·7 mins

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.