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.
A full set of sample commands for keeping your data and backups when you remove a Postgres Operator cluster.