Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 39 Minuten 47 Sekunden

Kaarel Moppel: TIL - Starting in read-only mode the easy way

26. März 2025 - 23:00
Once a year or so Postgres manages to surprise me for some of those daily DB micro-operations, that come from muscle memory usually, without any braincells spent. Today to my delight I stumbled on one such again - for the task of starting a psql session in a safe read-only...

Thomas Klausner: Creating Postgres roles with passwords stored in gopass

26. März 2025 - 16:00

We are currently setting up a staging server (called beta) for a project consisting of two sub-projects and a bunch of services in each project. Each service uses a distinct role (postgres-speech for user), so I needed to set up a lot of roles, where each role has a distinct username and password. We use gopass to manage our passwords (and related info like usernames). When deploying (via Ansible) we can extract the passwords from gopass and inject them into the environment of the containers running the services.

Tomas Vondra: 15 years of Prague PostgreSQL Developer Day

26. März 2025 - 11:00

It’s been a couple weeks since P2D2 (Prague PostgreSQL Developer Day) 2025. We’ve been busy with the various tiny tasks that need to happen after the conference - processing feedback, paying invoices, and so on. But it’s also a good opportunity to look back - I realized this was the 15th year of the event I’ve helped to organize, so let me share some of that experience.

Elizabeth Garrett Christensen: Postgres Security Checklist from the Center for Internet Security

25. März 2025 - 16:00

The Center for Internet Security (CIS) releases security benchmarks to cover a wide variety of infrastructure used in modern applications, including databases, operating systems, cloud services, containerized services, and even networking. Since 2016 Crunchy Data has collaborated with CIS to provide this security resource for those deploying Postgres. The output of this collaboration is a checklist for folks to follow and improve the security posture of Postgres deployments.

David Wheeler: Mini Summit 2: Extension Search Path Patch

24. März 2025 - 22:14

This Wednesday, March 26 at noon America/New_York (16:00 UTC), Peter Eisentraut has graciously agreed to give a talk at the Extension Mini Summit #2 on the extension search path patch he recently committed to Post

David Wheeler: 2025 Postgres Extensions Mini Summit One

24. März 2025 - 21:46

Back on March 12, we hosted the first in a series of PostgreSQL Extensions Mini Summits leading up to the Extension Ecosystem Summit at PGConf.dev on May 13. I once again inaugurated the series with a short talk on the State of the Extension Ecosystem. The talk was followed by 15 minutes or so of discussion.

Andreas 'ads' Scherbaum: Shruthi K C

24. März 2025 - 15:00
PostgreSQL Person of the Week Interview with Shruthi K C: My name is Shruthi K C, and I live in Bangalore, Karnataka, India. I work as a Database Developer at EnterpriseDB, with over 15 years of experience in databases. The last 4 years I have been primarily focused on PostgreSQL.

Alexander Korotkov: Why PostgreSQL needs a better API for alternative table engines?

24. März 2025 - 1:00

For a long time now, PostgreSQL has had an extensible Index Access Method API (called AM), which has stood the test of time and enabled numerous robust extensions to provide their own index types.

Ian Barwick: PgPedia Week, 2025-03-23

23. März 2025 - 22:38

With CommitFest 52 (2025-03) - the final CommitFest in the PostgreSQL 18 development cycle - entering its final stages, there has been a burst of activity, and the PostgreSQL 18 code freeze has been announced for April 8th .

Jimmy Angelakos: SCaLE 22x, live streams and Row-Level Security Sucks

21. März 2025 - 20:30

The 22nd edition of the Southern California Linux Expo, or SCaLE 22x, took place from March 6-9, 2025, in Pasadena, California. It was a fantastic event packed with insightful talks, community spirit, and legendary figures from the computing world.

Robert Haas: Mentoring Applications and Hacking Workshop for April 2025

19. März 2025 - 16:04
Here are a few mentoring-related updates.Read more »

Greg Sabino Mullane: Postgres Troubleshooting: Fixing Duplicate Primary Key Rows

19. März 2025 - 15:00

Someone recently asked on the Postgres mailing lists about how to remove unwanted duplicate rows from their table. They are “unwanted” in that sense that the same value appears more than once in a column designated as a primary key. We’ve seen an uptick in this problem since glibc was kind enough to change the way they sorted things. This can lead to invalid indexes when one upgrades their OS and modifies the underlying glibc library.

Dave Stokes: PostgreSQL's COPY and \COPY

19. März 2025 - 14:59
PostgreSQL is equivalent to a Swiss Army Knife in the database world. There are things in PostgreSQL that are very simple to use, while in another database, they take many more steps to accomplish. But sometimes, the knife has too many blades, which can cause confusion. This is one of those cases. COPY and \COPY I needed a quick dump of a table as part of an ETL (Extract, Transform, and Load - official definition, Exorcism, Trauma, and Lost-sleep - unofficially) to port some data.

Colin Copeland: How to Use regexp_matches and regexp_match in PostgreSQL

19. März 2025 - 9:00
Introduction

regexp_matches() and regexp_match() are two similar string functions that support regular expression matching directly in the PostgreSQL database.

Chris Ellis: PGDay UK 2025 - Call for Papers and Call for Sponsors Open!

18. März 2025 - 15:30

We're happy to announce that the Call for Papers and Call for Sponsors is open for PGDay UK 2025!

Call for Papers is open from today until May 12, 2025 at 23:59:59 in London, UK. Selected speakers will be notified before May 26, 2025. We accept proposals from both established and new speakers on a range of PostgreSQL related topics. You don't need to have the talk written beforehand, we just need an abstract of your talk, so don't hold back and tell your friends. Find out more: https://2025.pgday.uk/call-for-papers/ .

Craig Kerstiens: Citus: The Misunderstood Postgres Extension

18. März 2025 - 14:50

Citus is in a small class of the most advanced Postgres extensions that exist. While there are many Postgres extensions out there, few have as many hooks into Postgres or change the storage and query behavior in such a dramatic way. Most that come to Citus have very wrong assumptions. Citus turns Postgres into a sharded, distributed, horizontally scalable database (that's a mouthful), but it does so for very specific purposes.

Citus, in general, is fit for these type of applications and only these type:

Hans-Juergen Schoenig: Debugging PostgreSQL more easily

18. März 2025 - 7:00

PostgreSQL is the foundation for thousands and thousands of applications. The system has long proven its worth and is operating reliably. However, the question people often ask is: What is the best way to actually debug a database application? 

For a couple of years now, I have been using a simple method that greatly speeds up the debugging process of typical applications.

vignesh C: Driving PostgreSQL forward: Fujitsu's key contributions

18. März 2025 - 0:52

Fujitsu has participated in the PostgreSQL community for over 20 years and has contributed to PostgreSQL development by developing new features, as well as creating and reviewing correction patches. And last year we took our team contributions to a whole new level.

Andreas 'ads' Scherbaum: Emma Saroyan

17. März 2025 - 15:00
PostgreSQL Person of the Week Interview with Emma Saroyan: I’m Emma Saroyan, a Developer Advocate from Yerevan, Armenia. Since graduating from university, I’ve been working with tech startups and actively contributing to open-source communities by mentoring, giving talks, and organising meetups.

Seiten