Neues vom PostgreSQL Planet

 Structured Query Language, or SQL, is my favorite programming language, but its quirky syntax can sometimes be frustrating. Many have professed a need to bypass SQL and query databases in English (another quirky language. Is it possible to have an Artificial Intelligence take a request in English and translate it into SQL on my behalf?

I am using the AI Chat Feature of DBeaver Enterprise to test. 

Introduction

In our previous blog, we have done an introduction to CloudNativePG (CNPG) and showed how we can create a single instance cluster. In this blog, we’ll walk through creating a PostgreSQL cluster using initdb with custom options, manage roles, and create databases—all declaratively with Kubernetes manifests.

Postgres AI Checkup service: expert-led, AI-assisted comprehensive database health assessment

This is Day 3 of Postgres AI launch week

It starts innocently enough.

You choose Postgres – solid, reliable, battle-tested. You pick a managed service like RDS or CloudSQL. They handle backups, high availability, disaster recovery. You can focus on building your product. Life is good.

 If you've ever wanted to skip SQL and its quirks and write queries in English, I am happy to report that you can do it with an AI of your choice and DBeaver. I have a webinar on July 24th that shows you how to do just that.  

If you missed Prairie PUG meetup, here is the recording!

There will be no meetup in August – we will see you on September 10. Please keep an eye on announcements!

A year ago we renamed the Talking Postgres podcast—and just published our 29th episode. Since it’s a monthly thing, that means 13 new conversations in the past year. So this feels like a good moment to pause, reflect, and share a few highlights.

Three events published their schedule. Here are the Program Committees behind that work. Registrations are open for these three events.

PgDay Austria

© Laurenz Albe 2025

You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in the PostgreSQL license text, the name of installation packages and elsewhere. But have you ever stopped to think who this mysterious organization is? Have you ever wondered how one becomes a member? Then read on.

PostgreSQL Person of the Week Interview with Peter Zaitsev: I was born and raised in Moscow, Russia, graduated from Moscow State University and had my first startup there. In 2004 I moved to the US while working at MySQL AB.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres. 

I regularly update my slides to reflect improvements, corrections, and changes to Postgres. Recently I have made changes to two of my slide decks that I would like to highlight. First, my talk Postgres Scaling Opportunities is a rarely-presented deck about the ways Postgres can be scaled. One thing I always felt diminished the usefulness of that presentation was a clear explanation of why scaling databases is so complex.

The PostGIS Team is pleased to release PostGIS 3.6.0beta1! Best Served with PostgreSQL 18 Beta2 and soon to be released GEOS 3.14.

This version requires PostgreSQL 12 - 18beta2, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres.