From time to time I see questions from otherwise well informed people about how the PostgreSQL Build farm checks how pg_upgrade checking is done across versions, e.g. how does it...
This blog provides my opinion on how Postgres, according to the annual Stack Overflow developer survey, became the most admired, desired and used database by developers. This is part three...
Earlier this year we started a program ("Developer U") to help colleagues who show promise for PostgreSQL Development to become contributors. Meet one of the participants: Akshay Joshi, a Principal...
Thomas Munro recently put together a page that shows a summary of the buildfarm builds for the tip of each branch. That looked neat to me, but rather than scraping...
After a very long development period, we finally completed the project to rework NOT NULL constraints in PostgreSQL. This has long been a desire of the Postgres development community, and...
Introduction PostgreSQL 18 introduces a significant new feature: OAuth2 authentication. This enables PostgreSQL to authenticate users using OAuth2 tokens instead of traditional username/password pairs. In this guide, we'll explore how...
PostgreSQL 18 ( RC1 was released on 09/05/2025) introduces a significant new feature: OAuth2 authentication. This lets PostgreSQL authenticate users using OAuth2 tokens instead of traditional username/password pairs. In this...
PostgreSQL 18 ( RC1 was released on 09/05/2025) introduces a native OAuth2 authentication method based on the SASL OAUTHBEARER mechanism. Instead of passwords, clients present bearer tokens issued by an...
PostgreSQL has come a long way from its early days as a single-node database. If you’ve worked with PostgreSQL for a while, you’ll know its journey to robust logical replication...
