ext

Decision date: 2026-10-16 Status: Implemented in the v1.10.0 candidate, not yet released. Current reference: pig ext catalog count Scope: Catalog totals and default listing membership; package installation and SQL activation rules remain defined by …

Decision date: 2026-08-13 Status: Proposal; security mechanism, overlays, packaging, and path layout remain open. Current reference: pig ext and pig repo describe the v1 Catalog behavior. Scope: A candidate PIG 2.0 publication and consumption model …

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

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 …

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 …

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 …

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 …

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 …

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

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 …

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 …

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 …

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

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 …

Launch the new PGEXT.CLOUD extension catalog 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 …

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 …

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

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

The annual PostgreSQL developer conference, PGConf.dev, will be held in Montreal in May. Postgres Extensions Day takes place the day before it, with a focus on extension development, packaging, and release. The agenda has just been released, with 14 …

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 …

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 is a Go command-line tool for installing PostgreSQL and extensions through the system package manager. It selects packages for the operating system, CPU architecture, and PostgreSQL version, then uses APT, YUM, or DNF to install them. The …

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

pig build downloads sources, installs dependencies, and produces RPM/DEB packages using Pigsty build recipes. Use it on an EL, Debian, or Ubuntu build host. Rust, pgrx, and the Xray client also support their respective macOS workflows. Command …

pig ext searches the extension catalog and installs, updates, or removes PostgreSQL extension packages on the host. It also supports PostgreSQL server packages. After installing a package, apply the SQL and configuration required by the extension. …

PIG is a command-line tool for installing and managing PostgreSQL and its extensions. It maps extension names to RPM or DEB packages and uses apt, dnf, or yum to install them. The catalog contains 603 extension entries. PIG selects package names for …

This tutorial installs PostgreSQL 18 and pgvector, starts a local test instance, and enables the extension in a database. Use a supported Linux test host with internet access and curl installed. You need root or sudo access. Run the commands in …