Date: 2025-05-14
Time: 10:00–10:50
Room: Breakout Room 2
Level: Intermediate
As part of the PGXN v2 project I've been working on a binary packaging design for extensions inspired by the Python Wheel and Tembo Trunk formats. Sounds easy, right? Well, PostgreSQL extension management, as currently implemented, presents a number of unique challenges. These include where the server looks for various extension files, the immutability of OCI images, testing by binary packagers, what files to include in a package, and the mechanism for extension registration and distribution.
In this session, I'll review these issues, as well as some of the edge cases and unexpected gotchas discovered in the process of exploring them, and progress on the plans for the PostgreSQL core, PGXN, and other environments like CNGP and Postgres.app to resolve them. It's a wild ride, but the destination looks great!