Skip to content

Tags: ext

  • Catalog v2 Proposal: Immutable Typed Snapshots Instead of Bigger CSV

    By Ruohang Feng In Design

    Ruohang Fengcatalogrepoextcli

    Catalog v2 Proposal: Immutable Typed Snapshots Instead of Bigger CSV

    Decision date: 2026-08-13 Status: Pre-implementation proposal; security mechanism, overlay scope, packaging, and path ADRs remain open. Current reference: pig ext and pig repo describe the v1 Catalog behavior. Scope: A candidate PIG 2.0 publication …

    Decision date: 2026-08-13 Status: Pre-implementation proposal; security mechanism, overlay scope, packaging, and path ADRs remain open. Current reference: pig ext and pig repo describe the v1 Catalog behavior. Scope: A candidate PIG 2.0 publication …

  • pig v1.7.0

    By Ruohang Feng In Release

    Ruohang Fengrepocatalogext

    pig v1.7.0

    Pig v1.7.0 is a repository compatibility and catalog release on top of v1.6.2. It makes China-mirror selection explicit, preserves native DNF module filtering by default, restores a streamlined EL7 repository catalog, and grows the bundled extension …

    Pig v1.7.0 is a repository compatibility and catalog release on top of v1.6.2. It makes China-mirror selection explicit, preserves native DNF module filtering by default, restores a streamlined EL7 repository catalog, and grows the bundled extension …

  • pig v1.6.2

    By Ruohang Feng In Release

    Ruohang Fengcatalogrepoextsty

    pig v1.6.2

    Pig v1.6.2 is a feature and catalog release on top of v1.6.1. It grows the packaged extension catalog from 562 to 572, adds native Grafana dashboard schema v2 support, and improves local repository generation. The embedded Pigsty version remains …

    Pig v1.6.2 is a feature and catalog release on top of v1.6.1. It grows the packaged extension catalog from 562 to 572, adds native Grafana dashboard schema v2 support, and improves local repository generation. The embedded Pigsty version remains …

  • pig v1.6.1

    By Ruohang Feng In Release

    Ruohang Fengcatalogextinstallrepo

    pig v1.6.1

    pig v1.6.1 is a maintenance release on top of v1.6.0. It carries no new commands and no flag changes — the point of the release is the catalog that ships inside the binary. What changed Extension catalog refreshed. The embedded extension.csv is …

    pig v1.6.1 is a maintenance release on top of v1.6.0. It carries no new commands and no flag changes — the point of the release is the catalog that ships inside the binary. What changed Extension catalog refreshed. The embedded extension.csv is …

  • pig v1.5.1

    By Ruohang Feng In Release

    Ruohang Fengrepobuildext

    pig v1.5.1

    Pig v1.5.1 updates PG kernel forks to the latest package names. Highlights Add mirror/proxy mode to repo, build, sty, update, and extension update workflows; pig build rust -m also configures Cargo mirror settings with rsproxy.cn. Add explicit …

    Pig v1.5.1 updates PG kernel forks to the latest package names. Highlights Add mirror/proxy mode to repo, build, sty, update, and extension update workflows; pig build rust -m also configures Cargo mirror settings with rsproxy.cn. Add explicit …

  • What Is a PostgreSQL Distribution?

    By Ruohang Feng In Article

    Ruohang Fengpostgresrepoextsty

    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

    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

    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 …

  • pig v1.3.2

    By Ruohang Feng In Release

    Ruohang Fengcatalogbuildextpostgres

    pig v1.3.2

    Routine maintenance release. Refresh a batch of extension version metadata and catalog entries. Add the pig pg tune subcommand to generate PostgreSQL tuning parameters from hardware resources and workload profiles. Add pdu and pgdog source package …

    Routine maintenance release. Refresh a batch of extension version metadata and catalog entries. Add the pig pg tune subcommand to generate PostgreSQL tuning parameters from hardware resources and workload profiles. Add pdu and pgdog source package …

  • The PostgreSQL Extension Encyclopedia: Bilingual and Ready to Use

    By Ruohang Feng In Article

    Ruohang Fengextcatalogrepo

    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

    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 + …

  • pig v1.3.0

    By Ruohang Feng In Release

    Ruohang Fengcatalogbuildcliext

    pig v1.3.0

    This release is a focused engineering update from v1.2.0 to v1.3.0: 15 commits, 74 files changed, +1184 / -236 LOC. It hardens the pig build pipeline and extends catalog/alias coverage, increasing total extensions from 451 to 461. Highlights Build …

    This release is a focused engineering update from v1.2.0 to v1.3.0: 15 commits, 74 files changed, +1184 / -236 LOC. It hardens the pig build pipeline and extends catalog/alias coverage, increasing total extensions from 451 to 461. Highlights Build …

  • pig v0.9.0

    By Ruohang Feng In Release

    Ruohang Fengstyext

    pig v0.9.0

    Changes Rename pig sty install to pig sty deploy so the command name reflects that it runs the Pigsty deployment playbook. Add the -g, -p, and -o options to pig sty conf, aligning it with the configure script available in this release. Keep llvmjit …

    Changes Rename pig sty install to pig sty deploy so the command name reflects that it runs the Pigsty deployment playbook. Add the -g, -p, and -o options to pig sty conf, aligning it with the configure script available in this release. Keep llvmjit …

  • pig v0.8.1

    By Ruohang Feng In Release

    Ruohang Fengext

    pig v0.8.1

    Fix Restore llvmjit to the pgsql-full package alias after it was removed in v0.8.0. Bump the release version to v0.8.1. Checksums Copy all checksums Download asset FileChecksum pig-0.8.1-1.aarch64.rpm Linuxarm64SHA-256 fd9291b1…258c …

    Fix Restore llvmjit to the pgsql-full package alias after it was removed in v0.8.0. Bump the release version to v0.8.1. Checksums Copy all checksums Download asset FileChecksum pig-0.8.1-1.aarch64.rpm Linuxarm64SHA-256 fd9291b1…258c …

  • Forging a China-Rooted, Global PostgreSQL Distro

    By Ruohang Feng In Article

    Ruohang Fengpostgresrepoextbuild

    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. …

  • PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem

    By Ruohang Feng In Article

    Ruohang Fengextrepocatalogcli

    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 …

  • pig v0.7.1

    By Ruohang Feng In Release

    Ruohang Fengext

    pig v0.7.1

    The brand-new website: /ext/ Remove unnecessary sudo usage, now can be used inside docker Allow using pg18, pg17 arg format in pig ext link command Add environment var PIG_NO_SUDO to force not using sudo RPM Changelog: Add PG 18 support to almost …

    The brand-new website: /ext/ Remove unnecessary sudo usage, now can be used inside docker Allow using pg18, pg17 arg format in pig ext link command Add environment var PIG_NO_SUDO to force not using sudo RPM Changelog: Add PG 18 support to almost …

  • pig v0.6.0

    By Ruohang Feng In Release

    Ruohang Fengcatalogext

    pig v0.6.0

    New extension catalog: https://ext.pgsty.com New subcommand: pig install to simplify pig ext install Add new kernel support: percona with pg_tde Add new package: Google GenAI MCP toolbox for databases Add new repo: percona repo and clickhouse repo …

    New extension catalog: https://ext.pgsty.com New subcommand: pig install to simplify pig ext install Add new kernel support: percona with pg_tde Add new package: Google GenAI MCP toolbox for databases Add new repo: percona repo and clickhouse repo …

  • pig v0.4.1

    By Ruohang Feng In Release

    Ruohang Fengextcatalog

    pig v0.4.1

    Update the extension list to 414 Add citus_wal2json and citus_pgoutput to pig ext scan mapping Add PG 18 beta repo Add PG 18 package alias v0.4.1 Released 2025-05-07 View release Source · tar.gz Source · zip pgsty/pig

    Update the extension list to 414 Add citus_wal2json and citus_pgoutput to pig ext scan mapping Add PG 18 beta repo Add PG 18 package alias v0.4.1 Released 2025-05-07 View release Source · tar.gz Source · zip pgsty/pig

  • pig v0.4.0

    By Ruohang Feng In Release

    Ruohang Fengextcatalogpatronirepo

    pig v0.4.0

    Updated extension list, available extensions reached 407 Added pig do subcommand for executing Pigsty playbook tasks Added pig pt subcommand for wrapping Patroni command-line tools Added extension aliases: openhalo and orioledb Added gitlab-ce / …

    Updated extension list, available extensions reached 407 Added pig do subcommand for executing Pigsty playbook tasks Added pig pt subcommand for wrapping Patroni command-line tools Added extension aliases: openhalo and orioledb Added gitlab-ce / …

  • Postgres Extension Day - See You There!

    By Ruohang Feng In Article

    Ruohang Fengextrepobuild

    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 v0.3.3

    By Ruohang Feng In Release

    Ruohang Fengrepobuildext

    pig v0.3.3

    Add pig build dep command to install extension build dependencies Update default repo list Use pigsty.io mirror for mssql module (wiltondb/babelfish) Merge docker module into infra Remove pg16/17 from el7 target Allow installing extensions in el7 …

    Add pig build dep command to install extension build dependencies Update default repo list Use pigsty.io mirror for mssql module (wiltondb/babelfish) Merge docker module into infra Remove pg16/17 from el7 target Allow installing extensions in el7 …

  • pig v0.3.1

    By Ruohang Feng In Release

    Ruohang Fengrepoextcatalog

    pig v0.3.1

    Routine bugfix Fix repo format string Fix ext info links Update pg_mooncake metadata v0.3.1 Released 2025-03-19 View release Source · tar.gz Source · zip pgsty/pig

    Routine bugfix Fix repo format string Fix ext info links Update pg_mooncake metadata v0.3.1 Released 2025-03-19 View release Source · tar.gz Source · zip pgsty/pig

  • Pig, The Postgres Extension Wizard

    By Ruohang Feng In Article

    Ruohang Fengcliextrepopostgres

    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

    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 …

  • pig build

    In PIG: Packager Index Gateway

    Referencebuildext

    The pig build command simplifies the full workflow for building PostgreSQL extensions from source. It provides build infrastructure setup, dependency management, and compilation environments for standard and custom PostgreSQL extensions across …

    The pig build command simplifies the full workflow for building PostgreSQL extensions from source. It provides build infrastructure setup, dependency management, and compilation environments for standard and custom PostgreSQL extensions across …

  • pig ext

    In PIG: Packager Index Gateway

    Referenceextcatalog

    The pig ext command searches the extension catalog and manages PostgreSQL extension packages on a host. It can resolve names, inspect package availability, install/remove/update RPM or DEB packages, and handle PostgreSQL kernel packages. …

    The pig ext command searches the extension catalog and manages PostgreSQL extension packages on a host. It can resolve names, inspect package availability, install/remove/update RPM or DEB packages, and handle PostgreSQL kernel packages. …

  • Introduction

    In PIG: Packager Index Gateway

    Conceptcatalogext

    PostgreSQL has an unusually rich extension ecosystem, but distributing those extensions is harder than discovering them. A usable package must match the PostgreSQL major version, Linux distribution release, CPU architecture, dependency set, and …

    PostgreSQL has an unusually rich extension ecosystem, but distributing those extensions is harder than discovering them. A usable package must match the PostgreSQL major version, Linux distribution release, CPU architecture, dependency set, and …

  • Getting Started

    In PIG: Packager Index Gateway

    Tutorialinstallrepoext

    Here is a simple getting started tutorial to help you experience the core capabilities of the PIG package manager. Short Version curl -fsSL https://repo.pigsty.io/pig | bash # Install PIG from Cloudflare pig repo set # One-time setup for Linux, …

    Here is a simple getting started tutorial to help you experience the core capabilities of the PIG package manager. Short Version curl -fsSL https://repo.pigsty.io/pig | bash # Install PIG from Cloudflare pig repo set # One-time setup for Linux, …