Skip to content

Article

Long-form articles about the problems PIG is built to solve: making PostgreSQL extensions discoverable, packaging them as native RPM/DEB artifacts, publishing trustworthy repositories, and exposing the resulting capabilities through a practical CLI.

The articles retain their original publication dates, historical package counts, screenshots, and contemporary context. For current behavior, use the PIG documentation, the live extension catalog, and the release notes.

Suggested reading paths:

SOW: Postpartum Care for 100,000 Packages repobuildcatalog
A Packaging Patch Has Been Corrupting Valkey's Memory Accounting Since 2017 buildrepo
Instantly Clone PostgreSQL Databases—No Black Magic Required postgresclisty
What Is a PostgreSQL Distribution? postgresrepoextsty
Extensions for Everyone extrepocatalogbuild
504 Extensions: Expand the PostgreSQL Landscape extcatalogbuild
The PostgreSQL Extension Encyclopedia: Bilingual and Ready to Use extcatalogrepo
464 Extensions, Ready Out of the Box: The New PostgreSQL Extension Catalog extcatalogrepo
Forging a China-Rooted, Global PostgreSQL Distro postgresrepoextbuild
On Trusting Open-Source Supply Chains repobuild
PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem extrepocatalogcli
Build and Packaging: An Overlooked but Scarce Skill buildrepo
The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain repoinstallbuild
PGDG Cuts Off Mirror Sync Channel repoinstall
Postgres Extension Day - See You There! extrepobuild
Pig, The Postgres Extension Wizard cliextrepopostgres
The Ideal Way to Deliver PostgreSQL Extensions extrepocatalogbuild

Extensions for Everyone

Ruohang Feng

A field report on the PostgreSQL extension ecosystem: 1,617 discovered projects, 511 deliverable extensions, and the shared delivery layer needed to make extensibility work for users, authors, …

  • SOW: Postpartum Care for 100,000 Packages

    By Ruohang Feng In Article

    Ruohang Fengrepobuildcatalog

    Featured Image for SOW: Postpartum Care for 100,000 Packages

    Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When you maintain a PostgreSQL …

    Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When you maintain a PostgreSQL …

  • A Packaging Patch Has Been Corrupting Valkey's Memory Accounting Since 2017

    By Ruohang Feng In Article

    Ruohang Fengbuildrepo

    Featured Image for A Packaging Patch Has Been Corrupting Valkey's Memory Accounting Since 2017

    I was updating the Redis module in Pigsty recently, adding Valkey as an alternative engine, and hit an upstream bug while packaging it. If your Valkey runs on Debian or Ubuntu, and one day the disk fills up or the data directory permissions go wrong …

    I was updating the Redis module in Pigsty recently, adding Valkey as an alternative engine, and hit an upstream bug while packaging it. If your Valkey runs on Debian or Ubuntu, and one day the disk fills up or the data directory permissions go wrong …

  • Instantly Clone PostgreSQL Databases—No Black Magic Required

    By Ruohang Feng In Article

    Ruohang Fengpostgresclisty

    Featured Image for Instantly Clone PostgreSQL Databases—No Black Magic Required

    Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …

    Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …

  • What Is a PostgreSQL Distribution?

    By Ruohang Feng In Article

    Ruohang Fengpostgresrepoextsty

    Featured Image for What Is a PostgreSQL Distribution?

    People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin is not databases, but operating …

    People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin is not databases, but operating …

  • Extensions for Everyone

    By Ruohang Feng In Article

    Ruohang Fengextrepocatalogbuild

    Featured Image for Extensions for Everyone

    Slide deck: Extensions for Everyone Part I. Introduction 0. Extensions for Everyone 00. Extensions for Everyone Hi everyone. This talk is called Extensions for Everyone. It is about delivering PostgreSQL extensions, and about how a shared delivery …

    Slide deck: Extensions for Everyone Part I. Introduction 0. Extensions for Everyone 00. Extensions for Everyone Hi everyone. This talk is called Extensions for Everyone. It is about delivering PostgreSQL extensions, and about how a shared delivery …

  • 504 Extensions: Expand the PostgreSQL Landscape

    By Ruohang Feng In Article

    Ruohang Fengextcatalogbuild

    Featured Image for 504 Extensions: Expand the PostgreSQL Landscape

    A GitHub issue turned into an extension sprint. 32 new additions say a lot about where PostgreSQL is headed. It Started with a Chemistry Extension Two days ago, a user opened a GitHub issue: he was using RDKit, the de facto standard library in …

    A GitHub issue turned into an extension sprint. 32 new additions say a lot about where PostgreSQL is headed. It Started with a Chemistry Extension Two days ago, a user opened a GitHub issue: he was using RDKit, the de facto standard library in …

  • The PostgreSQL Extension Encyclopedia: Bilingual and Ready to Use

    By Ruohang Feng In Article

    Ruohang Fengextcatalogrepo

    Featured Image for The PostgreSQL Extension Encyclopedia: Bilingual and Ready to Use

    Directory: Chinese · English Extensions are the soul of PostgreSQL. Without them, PostgreSQL is just a very good relational database. With them, it becomes a platform that can swallow entire categories of database workloads. The problem is that the …

    Directory: Chinese · English Extensions are the soul of PostgreSQL. Without them, PostgreSQL is just a very good relational database. With them, it becomes a platform that can swallow entire categories of database workloads. The problem is that the …

  • 464 Extensions, Ready Out of the Box: The New PostgreSQL Extension Catalog

    By Ruohang Feng In Article

    Ruohang Fengextcatalogrepo

    Featured Image for 464 Extensions, Ready Out of the Box: The New PostgreSQL Extension Catalog

    Today I put Claude Code to work on another genuinely useful project: a completely new PostgreSQL extension catalog. You can find it at pigsty.io/ext. This is already the catalog’s fifth incarnation. After a long detour, it has returned to the Hugo + …

    Today I put Claude Code to work on another genuinely useful project: a completely new PostgreSQL extension catalog. You can find it at pigsty.io/ext. This is already the catalog’s fifth incarnation. After a long detour, it has returned to the Hugo + …

  • Forging a China-Rooted, Global PostgreSQL Distro

    By Ruohang Feng In Article

    Ruohang Fengpostgresrepoextbuild

    Featured Image for Forging a China-Rooted, Global PostgreSQL Distro

    Hi, I’m Feng Ruohang, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t whether PG will win—it already has. …

    Hi, I’m Feng Ruohang, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t whether PG will win—it already has. …

  • On Trusting Open-Source Supply Chains

    By Ruohang Feng In Article

    Ruohang Fengrepobuild

    Featured Image for On Trusting Open-Source Supply Chains

    Yesterday’s post “PG ‘Export Controls’ and Supply-Chain Trust” drew a comment from someone claiming to be an admin at a university mirror site (Tsinghua TUNA): “As a university mirror admin, calling us ‘lying flat’ or ‘irresponsible’ is unfair and …

    Yesterday’s post “PG ‘Export Controls’ and Supply-Chain Trust” drew a comment from someone claiming to be an admin at a university mirror site (Tsinghua TUNA): “As a university mirror admin, calling us ‘lying flat’ or ‘irresponsible’ is unfair and …

  • PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem

    By Ruohang Feng In Article

    Ruohang Fengextrepocatalogcli

    Featured Image for PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem

    WeChat link PostgreSQL’s killer feature is extensibility. PostGIS, pgvector, pg_duckdb, pg_search—extensions turn PG into GIS engine, vector DB, analytics warehouse, search cluster. But compiling and shipping them reliably across distros is a …

    WeChat link PostgreSQL’s killer feature is extensibility. PostGIS, pgvector, pg_duckdb, pg_search—extensions turn PG into GIS engine, vector DB, analytics warehouse, search cluster. But compiling and shipping them reliably across distros is a …

  • Build and Packaging: An Overlooked but Scarce Skill

    By Ruohang Feng In Article

    Ruohang Fengbuildrepo

    Featured Image for Build and Packaging: An Overlooked but Scarce Skill

    I was recently chatting with my friend Yurii, the founder of Omnigres. He wants to hire a PostgreSQL packaging expert and has even coined a title for the role: EEE, or Extension Ecosystem Engineer. It is an interesting idea. The job description is …

    I was recently chatting with my friend Yurii, the founder of Omnigres. He wants to hire a PostgreSQL packaging expert and has even coined a title for the role: EEE, or Extension Ecosystem Engineer. It is an interesting idea. The job description is …

  • The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain

    By Ruohang Feng In Article

    Ruohang Fengrepoinstallbuild

    Featured Image for The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain

    This month saw a high-profile “open source supply cut” incident — KubeSphere deleting images and running away, but there’s another slightly more subtle “chokepoint case” I mentioned last month — “Chokepoint: PGDG Cuts Mirror Sync Channels”. This …

    This month saw a high-profile “open source supply cut” incident — KubeSphere deleting images and running away, but there’s another slightly more subtle “chokepoint case” I mentioned last month — “Chokepoint: PGDG Cuts Mirror Sync Channels”. This …

  • PGDG Cuts Off Mirror Sync Channel

    By Ruohang Feng In Article

    Ruohang Fengrepoinstall

    Featured Image for PGDG Cuts Off Mirror Sync Channel

    Recently, while building Pigsty offline packages, I discovered that the PostgreSQL version installed during local testing wasn’t quite right - 17.4 was behind the latest 17.5 by one minor version. Also, when testing on EL10, I found several …

    Recently, while building Pigsty offline packages, I discovered that the PostgreSQL version installed during local testing wasn’t quite right - 17.4 was behind the latest 17.5 by one minor version. Also, when testing on EL10, I found several …

  • Postgres Extension Day - See You There!

    By Ruohang Feng In Article

    Ruohang Fengextrepobuild

    Featured Image for Postgres Extension Day - See You There!

    The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there’s also an additional dedicated event - Postgres Extensions Day, focusing on all aspects of PG extension development, delivery, and release. …

    The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there’s also an additional dedicated event - Postgres Extensions Day, focusing on all aspects of PG extension development, delivery, and release. …

  • Pig, The Postgres Extension Wizard

    By Ruohang Feng In Article

    Ruohang Fengcliextrepopostgres

    Featured Image for Pig, The Postgres Extension Wizard

    Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often comes at the …

    Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often comes at the …

  • The Ideal Way to Deliver PostgreSQL Extensions

    By Ruohang Feng In Article

    Ruohang Fengextrepocatalogbuild

    Featured Image for The Ideal Way to Deliver PostgreSQL Extensions

    PostgreSQL Is Eating the Database World through the power of extensibility. When this post was first published, the repository packaged 390 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …

    PostgreSQL Is Eating the Database World through the power of extensibility. When this post was first published, the repository packaged 390 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …

Last modified 2026-09-03 · chore(ci): update docs toolchain (d9065c0)