# Article > Essays on PIG, PostgreSQL extension delivery, Linux packaging, and repository supply chains. --- LLMS index: [llms.txt](/llms.txt) --- 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](/docs/), the live [extension catalog](https://pigsty.io/ext/), and the [release notes](/release/). Suggested reading paths: - **PIG and the pig family:** [Meet PIG](/article/pig/), [instant PostgreSQL cloning](/article/pg-pig-clone/), and [SOW's repository state model](/article/sow/). - **Extension delivery:** [the original repository rationale](/article/pg-ext-repo/), [PG Extension Cloud](/article/pgext-cloud/), the [extension encyclopedia](/article/pgext-pedia/), and [Extensions for Everyone](/article/extensions-for-everyone/). - **Packaging and trust:** [why Linux packaging is scarce](/article/packaging-skill/), the [PGDG mirror incident](/article/pg-mirror-break/), [Pigsty's response](/article/pg-mirror-pigsty/), and [what a Valkey packaging bug teaches us](/article/valkey-bug/). - **The distribution layer:** [forging a global PostgreSQL distribution](/article/forge-a-pg-distro/) and [what a PostgreSQL distribution actually is](/article/what-is-pg-distro/). --- Section pages: - [SOW: Postpartum Care for 100,000 Packages](/article/sow/): The hard part of maintaining a PostgreSQL distribution is not compiling packages. At 100,000 artifacts, deduplication, indexing, snapshots, atomic cutovers, and incremental publishing become the real challenge. SOW puts all of that into one self-contained binary, turning RPM and DEB repository management from ad hoc directory scripts into a recoverable, auditable state system. - [A Packaging Patch Has Been Corrupting Valkey's Memory Accounting Since 2017](/article/valkey-bug/): Codex found an old Valkey bug affecting Debian's packages and every official Valkey .deb. One line in a packaging patch releases a glibc allocation with Valkey's own deallocator, so the server either segfaults or silently stops accepting writes until you restart it. - [Instantly Clone PostgreSQL Databases—No Black Magic Required](/article/pg-pig-clone/): Pig v1.5 adds pig pg clone and pig pg fork, wrapping PostgreSQL 18's instant cloning capabilities in an agent-native CLI. - [What Is a PostgreSQL Distribution?](/article/what-is-pg-distro/): Starting with Linux distributions, this essay explains what a “PostgreSQL distribution” actually is: three layers, two paths, and one core idea. - [Extensions for Everyone](/article/extensions-for-everyone/): 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, vendors, and PostgreSQL hackers. - [504 Extensions: Expand the PostgreSQL Landscape](/article/extension-504/): One GitHub issue turned into an extension sprint. 32 new additions, 504 in total, say a lot about where PostgreSQL is headed. - [The PostgreSQL Extension Encyclopedia: Bilingual and Ready to Use](/article/pgext-pedia/): I turned 464 PostgreSQL extensions into a bilingual, ready-to-use encyclopedia with metadata, package matrices, install commands, docs, and binary distribution all in one place. - [464 Extensions, Ready Out of the Box: The New PostgreSQL Extension Catalog](/article/pg-ext-catalog-464/): The story and design principles behind a PostgreSQL extension catalog that brings packages and documentation together. - [Forging a China-Rooted, Global PostgreSQL Distro](/article/forge-a-pg-distro/): PostgreSQL already won. The real battle is the distro layer. Will Chinese developers watch from the sideline or craft a PG “Ubuntu” for the world? - [On Trusting Open-Source Supply Chains](/article/tuna-mirror-site/): In serious production you can’t rely on an upstream that explicitly says “no guarantees.” When someone says “don’t count on me,” the right answer is “then I’ll run it myself.” - [PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem](/article/pgext-cloud/): Free, open, no VPN. Install PostgreSQL and 431 extensions on 14 Linux distros × 6 PG versions via native RPM/DEB—and a tiny CLI. - [Build and Packaging: An Overlooked but Scarce Skill](/article/packaging-skill/): On the rare craft of production-grade Linux packaging in the PostgreSQL ecosystem. - [The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain](/article/pg-mirror-pigsty/): PostgreSQL official repos cut off global mirror sync channels, open-source binaries supply disrupted, revealing the true colors of various database and cloud vendors. - [PGDG Cuts Off Mirror Sync Channel](/article/pg-mirror-break/): PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain. - [Postgres Extension Day - See You There!](/article/pgext-day/): 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 - [Pig, The Postgres Extension Wizard](/article/pig/): Why would we need yet another package manager for PostgreSQL & extensions? - [The Ideal Way to Deliver PostgreSQL Extensions](/article/pg-ext-repo/): PostgreSQL is eating the database world through extensibility. This post introduces the Pigsty extension repository, which packaged 390 PostgreSQL extensions at launch and keeps growing through the Pigsty extension catalog.