
A beginner’s guide to encrypting your database connections “’SSL is enabled’ and ‘SSL is actually working’ are two very different things.” 1. What is SSL, and why does a database need it? SSL stands for Secure Sockets Layer. Its successor…


It's that time again. The upcoming Postgres v18.4 release (along with minor releases for all Major versions) has dropped some serious hints in the git logs, and it's bringing a significant payload of CVE tagged patches. As a seasoned…

I'm excited to announce release 1.0 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This is a major release that introduces a new optional capability:…
A step-by-step guide to migrating a PostgreSQL 17 cluster managed by Crunchy PGO v6 to PostgreSQL 18 under CloudNativePG. Two paths are covered: a fully declarative offline migration using CloudNativePG’s built-in pg_dump import, and an…