Latest posts
Postgres Constraints for Newbies
Examples of Postgres constraints using a schema and data requirements for a reservation system.
Secure Permissions for pgBackRest
A guide on securing the pgBackRest user for high-security Postgres environments.
14 min readElevation Profiles and Flightlines with PostGIS
Paul walks through spatial indexes and queries to find a solution to a recent postgis-user query.
5 min readPostgres Indexes for Newbies
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
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 read
