Latest posts
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 (MRR) 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
Devious SQL: Dynamic DDL in PostgreSQL
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.
6 min read
Postgres 14: It's The Little Things
Today I wanted to call some extra attention to those little things, the ones that don't get the spotlight, but simply make a developer's life better.
5 min read
Querying Spatial Data with PostGIS and ogr_fdw
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.
7 min read
Devious SQL: Message Queuing Using Native PostgreSQL
An interesting question came up on the postgresql IRC channel about how to use native PostgreSQL features to handle some sort of queuing behavior. While the specific usage was related to handling serialization of specific events to some external broker, the specifics are less important than the overall structure.
8 min read
Insert-Only Tables and Autovacuum Issues Prior to PostgreSQL 13
If you have insert-only tables in a version of PostgreSQL earlier that 13, you could benefit from running a regularly scheduled VACUUM.
5 min read
Fast, Flexible Summaries with Aggregate Filters and Windows
PostgreSQL can provide high performance summaries over multi-million record tables, and supports some great SQL sugar to make it concise and readable, in particular aggregate filtering, a feature unique to PostgreSQL and SQLite.
3 min read
Waiting for PostGIS 3.2: Secure Cloud Raster Access
Raster data access from the spatial database is an important feature, and the coming release of PostGIS will make remote access more practical, by allowing access to private cloud storage.
6 min read
Understanding Foreign Data Wrappers in Postgres and postgres_fdw
Foreign data wrappers can simplify data querying and analysis when you need data from disparate sources.
5 min read
Using Cert Manager to Deploy TLS for Postgres on Kubernetes
Let's look at how we can use cert-manager on Kubernetes to manage TLS for Postgres clusters.
6 min read
