Latest posts
Streaming Replication Across Kubernetes Postgres Clusters
A guide to setting up streaming replication between two separate Postgres clusters using the Postgres Operator for Kubernetes.
7 min readFive Tips For a Healthier Postgres Database in the New Year
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
5 min read
Extracting and Substituting Text with Regular Expressions in PostgreSQL
Regular expressions? Exceptional expressions according to Paul! Some nice examples and tips for using regrex inside Postgres. Topics include true/false regex, text extraction, text substitutions, and using regex flags.
5 min read
Keep Storage and Backups when Dropping Cluster with PGO
A full set of sample commands for keeping your data and backups when you remove a Postgres Operator cluster.
9 min read
Tricks for Faster Spatial Indexes
Learn about how structuring an index based on the inputs it receives and the order of inputs can have a strong effect on the quality of the final index. This post includes a lot of example code and geometry.
3 min read
PostGIS Day 2021
Highlights from the 3rd annual PostGIS Day, hosted virtually November 18th, 2021.
Using TimescaleDB with PGO, the open source Postgres Operator
Interested in trying out TimescaleDB with the Crunchy Postgres Operator? Here's a quick guide to set it up.
3 min readMultifactor SSO Authentication for Postgres on Kubernetes
A how-to guide to create a multi-factor (MFA) single-sign on (SSO) authentication system for PostgreSQL on Kubernetes using certificates and passwords.
7 min read
Fun with SQL in Postgres: Finding Revenue Accrued Per Day
Some helpful queries and examples for revenue accruing per day over the course of a month.
6 min read
Can't Resize your Postgres Kubernetes Volume? No Problem!
Trouble with your Kubernetes storage class supporting resize? The Postgres Operator can help. Learn how to use PGO's instance sets to do this and more.
6 min read
Patroni & etcd in High Availability Environments
A deep dive into Patroni, etcd, and the etcd consensus protocol to diagnose common communication and system issues.
13 min read
Fully Managed Postgres for Kubernetes with Crunchy Bridge
Crunchy Bridge can now be deployed through the new Red Hat OpenShift Database Access (RHODA).
3 min read
Secure PostgreSQL 14 with CIS Benchmark
Committed to securing Postgres deployments, Crunchy Data is proud to announce this newly published CIS PostgreSQL 14 Benchmark.
4 min readDatabase Security Best Practices on Kubernetes
Review some important security topics for databases on Kubernetes like running as an unprivileged user, data encryption, and regular software updates.
7 min read
Encrypting Postgres Data at Rest in Kubernetes
An example of how you can encrypt Postgres data at rest using PGO, the open source Postgres Operator from Crunchy Data using AWS EBS gp2 volumes.
4 min read
Introducing the Crunchy Bridge CLI
We are excited to announce the release of our CLI tool for easy provisioning, instance management, and a new tool called cb scope to get additional insights on your database.
5 min read
Projecting Monthly Revenue Run Rate in Postgres
Calculate and project monthly recurring revenue (ARR) and annual recurring revenue (ARR) with PostgreSQL.
8 min read
Multi-Cluster Postgres Federation on Kubernetes with Postgres 14 Using GitOp
Using the newest version 5 release of PGO and Postgres 14, this example shows you how to create a multi-cluster federated Postgres cluster using GitOps.
11 min read
Crunchy Bridge: UI Refresh, In-place Upgrades, Postgres 14
A few highlights of the last couple months include an updated front end, in place upgrades, Postgres 14 support, and maintenance windows. Plus a bonus preview of what's coming soon.
4 min read
PostgreSQL 14 on Kubernetes (with examples!)
Run PostgreSQL 14 on Kubernetes, and see how convenient it is to use distributed features like parallel remote Postgres queries!
7 min read
