Latest posts
A Postgres Primer for Oracle DBAs
You're an Oracle DBA and now you have to support a Postgres database! Where do you start? Stephen has a review of some of the high points in getting started with PostgreSQL.
8 min read
Kubernetes + Postgres Cluster From Scratch on Rocky 8
How to create a Kubernetes cluster from scratch, including getting it to run with cgroup v2 and swap turned on.
8 min readStreaming 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
