A full set of sample commands for keeping your data and backups when you remove a Postgres Operator cluster.
Interested in trying out TimescaleDB with the Crunchy Postgres Operator? Here's a quick guide to set it up.
A how-to guide to create a multi-factor (MFA) single-sign on (SSO) authentication system for PostgreSQL on Kubernetes using certificates and passwords.
Some helpful queries and examples for revenue accruing per day over the course of a month.
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.
Crunchy Bridge can now be deployed through the new Red Hat OpenShift Database Access (RHODA).
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.
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.
Data Definition Language (DDL) in SQL itself is notoriously non-dynamic but this next post on Devious SQL provides some examples of Dynamic DDL Postgres syntax for utility queries where you need to review the current state of the database.
The cool thing about foreign data wrappers is that they're an alternative to needing to have everything in the same data store. With spatial data being stored and shared in so many different formats, imagine being able to abstract that conversion away and just focus on analysis. Read on for a couple of quick demos.