Latest posts from Jonathan S. Katz
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 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
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
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.png)
Getting Started with PGO, Postgres Operator 5.0
An important design goal for PGO 5.0 was to make it as easy as possible to run production-ready Postgres with the features that one expects. Let's see what it takes to run cloud native Postgres that is ready for production.
4 min read
The Next Generation of Kubernetes Native Postgres
We're excited to announce the release of PGO 5.0, the open source Postgres Operator from Crunchy Data. While I'm very excited for you to try out PGO 5.0 and provide feedback, I also want to provide some background on this release.
6 min read
Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3
Almost a decade after range types were introduced, Postgres 14 makes it easier to write "boring SQL" for range data. Meet the "multirange" data type.
5 min read-1.png)
PGO 4.7, the Postgres Operator: PVC Resizing, GCS Backups, and More
We're excited to announce the new version of PGO, the open source Postgres Operator from Crunchy Data version 4.7! There's a lot of really cool features that make it easy to deploy production Postgres clusters on Kubernetes.
5 min read.png)
TLS for Postgres on Kubernetes: OpenSSL CVE-2021-3450 Edition
Not too long ago I wrote a blog post about how to deploy TLS for Postgres on Kubernetes in attempt to provide a helpful guide from bringing your own TLS/PKI setup to Postgres clusters on Kubernetes. In part, I also wanted a personal reference for how to do it!
7 min read.png)
Creating a Read-Only Postgres User
Learn how to create a read only user in Postgres both now and with a look ahead to Postgres 14.
7 min read
Announcing the Crunchy Postgres Operator 4.6.0 with rolling updates, pod tolerations, node affinity and more
With this release, we included features to streamline management of the Operator, added security features, and extra system metrics to enhance your high availability Kubernetes Postgres cluster. Let's take a look at what's new in the Postgres Operator 4.6!
6 min read
Helm, GitOps and the Postgres Operator
How can you apply GitOps principles to running PostgreSQL on Kubernetes with Helm?
4 min read
Kubernetes Pod Tolerations and Postgres Deployment Strategies
Learn how to use Kubernetes taints, pod tolerations, and node affinity for designing and deploying production PostgreSQL topologies.
5 min read-1.png)
Using GitOps to Self-Manage Postgres in Kubernetes
Deploy PostgreSQL clusters on Kubernetes with GitOps and the Postgres Operator!
6 min read
Deploy TLS for PgBouncer in Kubernetes
Learn how to deploy PgBouncer with TLS connections in Kubernetes using the Postgres Operator!
4 min read
