######octothorp.es

#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"