Blog
"Everything is a process until you leave this world."
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...
Backup Schedule Template in PGO Crunchy PostgreSQL Operator — Detailed Guide
Detailed guide explaining the rationale behind each step of managing and scheduling pgBackRest backups for a PostgreSQL PGO Crunchy cluster. Replace placeholders as needed.
Accessing LVM Storage Across Different Machines
This research explores the practical and theoretical aspects of accessing Logical Volume Manager (LVM) storage across different machines by connecting physical volumes (PVs) fro...
Setting Up PostgreSQL and pgBackRest as a Readonly database in a replica where archived databases are actively restored and made live on different ports
This guide will help you set up PostgreSQL (Percona-PostgreSQL-13) and pgBackRest (Percona-pgBackRest) on a machine (clusterreplica) to restore archived databases and make them ...
pgBackRest setup
pgBackRest is a backup tool used to perform PostgreSQL database backup, archiving, restoration, and point-in-time recovery. While it can be used for local backups, this procedur...