Latest posts
CQL Filtering in pg_featureserv
Recently Crunchy Data added pg_featureserv support for most of CQL2. Here we'll describe the powerful new capability it provides.
4 min readHow to Cheat at WORDLE with PostgreSQL
Fun with PostgreSQL! Using the French Wordle list, this post shows you some sql to find out the most often used letters in a table, how to reduce possibilities once you’ve found some letters, and how to solve wordle puzzles using the back end.
13 min readCloud Data Sources for the Postgres Operator for Kubernetes
New feature release for PGO v5.0.5 Initializing your Postgres database with backups from AWS S3, GCS or Azure.
5 min readSafer Application Users in Postgres
Risk management for Postgres. A guide to changing application user permissions so they can't delete your production database.
8 min read
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
