Blog
"Everything is a process until you leave this world."
Creating a Debian 12 Cloud-Init Template in Proxmox
This guide will walk you through creating a Debian 12 (Bookworm) cloud-init template in Proxmox using BIOS boot (seabios) and Q35 machine type. We’ll start from downloading the ...
Creating an Ubuntu 24.04 Cloud-Init Template in Proxmox
This guide will walk you through creating an Ubuntu 24.04 cloud-init template in Proxmox. We'll start from downloading the image and end with a reusable template that you can us...
Configuration Documentation for Potential Configuration Changes for Faster Availability
This document explains two specific configuration changes made to the Patroni Configuration and the PodDisruptionBudget (PDB) in the Kubernetes and PGO Crunchy setup. These sett...
Explanation Document: Pod Anti-Affinity Configuration for PostgreSQL Cluster
This document explains the pod anti-affinity configuration used in the PostgresCluster resource to ensure that the master and replica pods are scheduled on different nodes. It a...
Using S3 for Backups in Postgres Operator
To set up backups in S3 for your PostgreSQL cluster, you need to make a few modifications to your custom resource (CR) spec. Additionally, you will need to either:
Understanding and Mitigating Replica Lag in Patroni Clusters
In a Patroni-managed PostgreSQL cluster, the transaction log (TL) can differ between replicas, leading to replication lag. This document explains the reasons behind varying TL v...
Switchover Guide for Crunchy PGO's PostgreSQL Streaming Standby Replication (Master ↔ Standby)
This guide explains how to perform a switchover between a PostgreSQL Master Cluster (primary) and Standby Cluster (replica). The switchover involves making the current Standby t...
Simple Guide to Resize and Expand a QCOW2 Disk Image for CentOS Stream 9
This guide will walk you through the steps to resize a QCOW2 disk image on CentOS Stream 9. By following these instructions, you'll be able to create a new, larger disk image an...
Readiness Probe Failure in Kubernetes Deployment
In a Kubernetes environment, a PostgreSQL deployment was experiencing issues with its readiness probe, leading to frequent failures. The readiness probe is a critical mechanism ...
Documentation: Managing the autoCreateUserSchema Annotation for PostgreSQL Clusters
The autoCreateUserSchema annotation for PostgreSQL clusters managed by the CrunchyData PostgreSQL Operator is a feature that automatically creates user schemas when a new databa...