Today we’re excited to introduce support for major PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessly upgrade your clusters across major versions of PostgreSQL.
We're excited to announce the general availability of version 5.1 of PGO, the open source Postgres Operator from Crunchy Data. In addition to providing a seamless upgrade experience across both PGO and PostgreSQL versions, this feature-packed release also introduces many powerful new capabilities.
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
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.
New feature release for PGO v5.0.5 Initializing your Postgres database with backups from AWS S3, GCS or Azure.
How to create a Kubernetes cluster from scratch, including getting it to run with cgroup v2 and swap turned on.
A guide to setting up streaming replication between two separate Postgres clusters using the Postgres Operator for Kubernetes.
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
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.