#extensions
- Update Your Control Files
https://justatheory.com/2025/04/update-control
Suggestions to PostgreSQL extension maintainers to make some tweaks to your .control files and Makefiles.
- Mini Summit Five
https://justatheory.com/2024/05/mini-summit-five
Links, notes, and commentary from Yurii Rashkovskii’s presentation, “Universally Buildable Extensions: Dev to Prod,” at the fifth Postgres Extension Ecosystem Mini-Summit on May 1, 2024.
- 2025 Postgres Extensions Mini Summit Two
https://justatheory.com/2025/04/mini-summit-two
A transcript of from the second PostgreSQL Extension Mini Summit, “Implementing an Extension Search Path”, by Peter Eisentraut.
- RFC: Extension Metadata Typology
https://justatheory.com/2024/02/extension-metadata-typology
Thinking through the PostgreSQL extension metadata use cases and recognizing the types of information they need.
- Postgres Extensions: Use PG_MODULE_MAGIC_EXT
https://justatheory.com/2025/05/pg_module_magic_ext
Details for extension authors for how to use the new PG_MODULE_MAGIC_EXT macro introduced in PostgreSQL 18.
- Patch: Postgres ABI and API Guidance
https://justatheory.com/2024/06/abi-api-guidance
Dear Postgres extension developers: Please review and give feedback on the proposed patch adding ABI and API guidance to the C language documentation.
- Mini Summit 4 Transcript: The User POV
https://justatheory.com/2025/05/2025-mini-summit-four
Last week Floor Drees moderated a panel on “The User POV” at the fourth Extension Mini-Summit. Read on for the transcript and link to the video.
- Mini Summit Four
https://justatheory.com/2024/04/mini-summit-four
Links, notes, and commentary from Jonathan Katz’s presentation at the fourth Postgres Extension Ecosystem Mini-Summit, “Trusted Language Extensions for PostgreSQL”.
- 🏔 Extension Ecosystem Summit 2024
https://justatheory.com/2024/06/extension-ecosystem-summit
A brief report on the PostgreSQL Extension Ecosystem Summit at PGConf.dev 2024 in Vancouver, Canada.
- Mini Summit Three
https://justatheory.com/2024/04/mini-summit-three
A rough transcript of my Devrim Gündüz’s talk, “Overview of {yum,zypp}.postgresql.org, and the challenges around RPMifying extensions”, along with interspersed chat comments.
- 2025 Postgres Extensions Mini Summit One
https://justatheory.com/2025/03/mini-summit-one
A rough transcript of my talk “State of the Extension Ecosystem”.
- I'm a Postgres Extensions Tembonaut
https://justatheory.com/2024/01/tembonaut
Near year, new job. I accepted a new position at Tembo to work on improving the PostgreSQL extension ecosystem full time.
- To Preload, or Not to Preload
https://justatheory.com/2024/08/extension-preloading
When should a Postgres extension be pre-loaded and when should it not? Should it be loaded in user sessions or at server startup? For the Tembo blog, I dug into this question and wrote up my findings.
- Contemplating Decentralized Extension Publishing
https://justatheory.com/2024/02/decentralized-extension-publishing
The Go package ecosystem uses distributed publishing to release modules without authentication or uploads. Could we do something similar for Postgres extensions?
- Mini Summit 5 Transcript: Improving the PostgreSQL Extensions Experience in Kubernetes with CloudNativePG
https://justatheory.com/2025/05/mini-summit-cnpg
At the final Mini-Summit of 2025, Gabriele Bartolini gave an overview of PostgreSQL extension management in CloudNativePG.
- Mini Summit 3 Transcript: Apt Extension Packaging
https://justatheory.com/2025/04/mini-summit-three
Last week Christoph Berg, who maintains PostgreSQL’s APT packaging system, gave a very nice talk on that system. Herein lie the transcript and links to the slides and video.
- RFC: Extension Packaging & Lookup
https://justatheory.com/2024/11/rfc-extension-packaging-lookup
A proposal to modify the PostgreSQL core so that all files required for an extension live in a directory named for the extension, along with a search path to find extension directories.
- Extension Ecosystem Summit 2025
https://justatheory.com/2025/03/extension-ecosystem-summit
We’re doing it again! The PostgreSQL Extension Ecosystem Summit returns to PGConf.dev. We’ll again be looking at indexing, discovery, packaging, and core support. And we’ll once again be hosting a series of “Mini Summits” leading up to the event. Join us!
- Mini Summit 3: APT Extension Packaging
https://justatheory.com/2025/04/mini-summit-apt-packaging
Join us at PostgresSQL Extension Mini Summit #3 this week, where PostgreSQL Debian packaging maintainer Christoph Berg will takes on a tour of APT extension packaging.
- Mini Summit One
https://justatheory.com/2024/03/mini-summit-one
A rough transcript of my talk “State of the Extension Ecosystem”, along with interspersed chat comments and appearances by Bagel.
- PGXN Challenges
https://justatheory.com/2024/01/pgxn-challenges
Some thoughts on the challenges for PGXN’s role in the ideal PostgreSQL extension ecosystem of the future.
- Mini Summit 4: The User POV
https://justatheory.com/2025/04/mini-summit-user-pov
Join our fine panel on Wednesday at Extension Mini Summit #4 to hear all about “The User POV” — for better and for worse!
- PGConf & Extension Ecosystem Summit EU 2024
https://justatheory.com/2024/10/pgconf-extension-summit-eu
Notes and links from the Extension Ecosystem Summit EU 2024 and my first time at PGConf EU. Plus thoughts and photos from ancient sites and archeological museums I visited.
- Mini Summit 5: Extension Management in CNPG
https://justatheory.com/2025/05/mini-summit-cnpg-extensions
The last Mini-Summit of the year features Gabriele Bartolini talking about extension management in CloudNativePG.
- The History and Future of Extension Versioning
https://justatheory.com/2024/02/extension-versioning
What versioning standard should be used for Postgres extension distribution? Some context from PostgreSQL and PGXN, a survey of the version standard landscape today, and a recommendation.
- PGConf.dev 2024
https://justatheory.com/2024/06/pgconf-future-ecosystem
At PGConf.dev, I attended some great talks, made one of my own, and enjoyed the commearderie of fellow PostgreSQL extension authors and core developers. A brief report.
- ⛰️ Postgres Ecosystem Summit EU
https://justatheory.com/2024/10/postgres-ecosystem-summit-eu
The sequel to the successful PGConf.dev event, the Extension Ecosystem Summit EU will showcases some exemplary extension use cases.
- RFC: PGXN Metadata Sketch
https://justatheory.com/2024/03/rfc-pgxn-metadata-sketch
Request for comments on a sketch of a new metadata standard for Postgres extension packaging, distribution, and delivery, building on the PGXN Meta Spec to address its shortcomings and emerging use cases 12 years on.
- Extension Ecosystem Summit 2024
https://justatheory.com/2024/02/extension-ecosystem-summit
Some pals and I organized a summit at PGConf.dev on May 28 to work together as a community toward comprehensive indexing, discovery, and binary distribution, as well as a speaker series “mini summit” leading up to the event.
- Mini Summit Two
https://justatheory.com/2024/03/mini-summit-two
- Extension Registry Namespacing RFC
https://justatheory.com/2024/03/extension-namespace-rfc
A proposal for an additional level of name uniqueness for Postgres extension packaging and distribution, based on URIs.
- Mini Summit Six
https://justatheory.com/2024/05/mini-summit-six
A rough transcript of the sixth and final Extension Ecosystem Mini-Summit, in which we review potential topics for the in-person summit at PGConf.dev and discuss how to organize it.
- Adventures in Extension Packaging
https://justatheory.com/2025/05/extension-packaging-adventures
Narrative version of a PGConf.dev talk covering the many issues I stumbled upon while designing a universal packaging format for PostgreSQL extensions, maintaining pgt.dev packages, and experimenting with CloudNativePG immutability.
Follow #extensions
on RSS or use the
JSON API
curl -X GET \
-H "Content-type: application/json" \
-H "Accept: application/json" \
"https://octothorp.es/~/extensions"