PIG Blog

Decision date: 2026-11-06 Status: Implemented in source commit 7c069dc; released in v1.10.4. Current reference: pig ext category aliases Scope: Dynamic pgN-* and pgsql-* category aliases that resolve extension package groups. Decision Stable …

PIG v1.10.4 refreshes the embedded PostgreSQL extension catalog from 620 to 626 entries and fixes category aliases to respect the requested PostgreSQL major version. The November 6, 2026 snapshot adds seven entries and drops the retired …

PIG v1.10.3 refreshes the embedded PostgreSQL extension catalog from 616 to 620 entries, adding four extensions and updating package, version, compatibility, and availability metadata. New extensions Extension Version PostgreSQL support Description …

PIG v1.10.1 is a security and catalog maintenance release. It upgrades Go to 1.27.3, refreshes tooling dependencies, and expands the embedded PostgreSQL extension catalog from 603 to 615 entries. Security update Upgrade the Go toolchain from 1.27.2 …

PIG v1.10.2 refreshes the embedded PostgreSQL extension catalog from 615 to 616 entries, adding pg_nanotime and updating extension versions, compatibility, and package availability metadata. New extension Add pg_nanotime 0.2.0, which provides …

Pig v1.10.0 strengthens the correctness and safety of existing commands. It verifies PostgreSQL targets before operations, preserves Inventory sources and YAML types, and makes repository, extension, and automation results match the work actually …

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 …

Pig v1.9.0 adds one-command Xray client/server setup, automatic Pigsty repository-key preparation, and a refreshed 600-entry extension catalog. The default cargo-pgrx version is now 0.19.3; the embedded Pigsty version remains 4.5.0. Xray clients and …

Decision date: 2026-10-05 Status: Released in v1.9.0. The 2026-10-16 refinements below are Implemented in the v1.10.0 candidate, not yet released. Current reference: pig build, operations safety, and release history Scope: One-command Xray client …

Decision date: 2026-10-04 Status: Released in v1.9.0. Current reference: pig repo Scope: Installing the existing embedded Pigsty public key during repository configuration. Decision When a selected module contains an available pigsty-infra or …

Decision date: 2026-09-03 Status: Released in v1.8.1. Current reference: pig build Scope: Debug-package policy for pig build ext and pig build pkg; individual package recipes remain authoritative for their payload. Decision pig build ext and pig …

Pig v1.8.1 is a safety, correctness, and maintenance release on top of v1.8.0. It hardens command initialization, privileged log access, repository and build workflows, release integrity, and structured-output redaction. It also refreshes the …

Decision date: 2026-08-14 Status: Implemented and released in pig v1.8.0. Current reference: pig sty boot Scope: Preparing a Pigsty controller and its package sources; not deploying a database cluster. Decision pig sty boot should be one native, …

Pig v1.8.0 makes Pigsty controller setup native. The two core setup commands, pig sty boot and pig sty conf, are now failure-aware Go workflows instead of wrappers around the legacy bootstrap and configure shell scripts. The release keeps the public …

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 …

Decision date: 2026-08-13 Status: Proposal for review; not implemented. Current reference: PIG documentation and release history Scope: Candidate product boundaries and verification gates for a future PIG 2.0 / Pigsty 5.0 line. Decision The proposed …

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 …

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 …

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 …

I was updating the Redis module in Pigsty recently, adding Valkey as an alternative engine, and found a bug in an inherited packaging patch. In affected Valkey DEB packages, failed synchronous saves can corrupt used_memory until it reports a value …

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.0 is a major release: pig pt becomes a transparent patronictl launcher, the new root-level pig inventory command group brings lossless editing and validation of pigsty.yml (with an experimental PostgreSQL CMDB bridge), pig sty grafana adds …

Decision date: 2026-07-21 Status: Implemented and released in pig v1.6.0. Current reference: pig pt Scope: Patronictl-backed cluster commands plus PIG-owned configuration selection, settings sugar, service, status, and log helpers. Decision pig pt …

Decision date: 2026-07-18 Status: Released in v1.6.0; dashboard schema v2 support followed in v1.6.2. Current reference: pig sty grafana Scope: Dashboard import, export, cleanup, and selected organization and user preferences. Decision PIG uses a …

Decision date: 2026-07-18 Status: Released in v1.6.0 as an experimental adapter. The earlier revision-store design is superseded. Current reference: pig inventory cmdb Scope: Exchanging declarations with Pigsty’s existing CMDB, not designing another …

Decision date: 2026-07-18 Status: Implemented and released in pig v1.6.0. The 2026-10-16 to 2026-10-17 refinements below are Implemented in the v1.10.0 candidate, not yet released. Current reference: pig inventory Scope: Static Pigsty Inventory …

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 …

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 …

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 …

Pig v1.5.0 is a PostgreSQL operations release for day-to-day DBA work. It adds local database clone/fork workflows, clarifies the boundaries between pg, pt, pb, and pitr, and tightens preview, confirmation, and structured-output behavior for …

Decision date: 2026-07-02 Status: Released for pg, pb, pt, and pitr by v1.5.0; the 2026-08-29 do and build proxy refinements were released in v1.8.1. The acceptance refinements below are Implemented for v1.10.0; source evidence is listed under …

Decision date: 2026-06-30 Status: Implemented; the repository uses this layout for new commands. Current reference: pig command overview and the source repository Scope: Go source ownership and command registration, not the public command taxonomy …

Refresh the built-in extension catalog from 510 to 524 available extensions. This adds 14 extensions: pg_stl, pgmnemo, psql_bm25s, pg_orca, pg_sorted_heap, graph, pgrdf, fsm_core, jsonschema, pg_durable, pg_mockable, pg_uuid_v8, pg_stat_backtrace, …

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 …

510 extensions, 3 new extensions, 20 updated. Ubuntu 26.04 resolute support, drop support for Ubuntu 20.04 focal. Bump el9.aarch64 ad hoc patroni to 4.1.2. Bump pgEdge to PostgreSQL 18. Calibrate upstream repo definition. Checksums Copy all …

Refresh the extension catalog and increase the total available extensions to 510, with version bumps such as timescaledb 2.26.3, decoderbufs 3.5.0, pgclone 4.0.0, and nominatim_fdw 1.3. Bump the default pgrx version from 0.17.0 to 0.18.0 and align …

Bump total available extensions to 504. Checksums Copy all checksums Download asset FileChecksum pig-1.3.4-1.aarch64.rpm Linuxarm64SHA-256 dc78def9…05fd pig-1.3.4-1.x86_64.rpm Linuxamd64SHA-256 998fcbda…e696 pig-v1.3.4.darwin-amd64.tar.gz …

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 …

Refresh extension catalog and increase total available extensions to 481. Bump Go toolchain from 1.26.0 to 1.26.2. Extension Updates Extension Old New Notes timescaledb 2.25.2 2.26.2 available, PG15-18 pg_background 1.8 1.9.2 DEB only, PG14-18 …

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 …

Decision date: 2026-03-21 Status: Released in pig v1.3.2, following implementation on 2026-03-23. Current reference: pig pg tune Scope: Generate a starting configuration from hardware, PostgreSQL version, and workload profile. Decision pig pg tune …

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 is a small maintenance release from v1.3.0 to v1.3.1. PG13 install/build support is removed because PGDG upstream has dropped PG13 archive/distribution. Active supported PostgreSQL major versions are now 14-18. Refresh extension catalog (461 -> …

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 …

Extension catalog and alias resolution enhancements: Introduce dynamic PG category alias resolution by PG major version. Add OS-level alias overrides (ansible/bootstrap) and converge unknown distro fallback to PGDG-only. Add aliases such as …

Decision date: 2026-02-18; the production contract was finalized on 2026-08-14. Status: Implemented and released in pig v1.8.0. Current reference: pig sty conf Scope: Generating one validated static Inventory from a trusted Pigsty template; not …

Fixes Preserve symlink semantics during build-tree migration and support cross-device moves. Handle a PostgreSQL log directory configured as the filesystem root without resolving files outside the intended directory. Allow pig repo rm to remove …

This release upgrades the CLI architecture from v1.0.0 to v1.1.0 (79 commits, 193 files changed), with the core goal of moving pig from a “human-friendly CLI” to an “agent-native orchestratable CLI”. Seven new extensions are added, bringing the total …

Decision date: 2026-02-12 Status: Released in pig v1.1.0 and refined by later command-layer work. The 2026-10-16 refinements below are Implemented in the v1.10.0 candidate, not yet released. Current reference: pig command overview Scope: PIG-owned …

This release introduces three major new subcommand groups (pig pg, pig pt, pig pb) for managing PostgreSQL, Patroni, and pgBackRest, along with an orchestrated PITR command and enhanced extension availability display. New Commands pig pg - PostgreSQL …

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 …

Extension Updates Total extensions reached 440 New extension: pg_ai_query 0.1.1 New extension: pg_textsearch 0.1.0 New extension: pg_clickhouse 0.1.0 pg_biscuit upgraded from 1.0 to 2.0.1 (switched to new repo, renamed to biscuit) pg_search upgraded …

Extension Updates timescaledb 2.23.1 -> 2.24.0 pg_search 0.20.0 -> 0.20.3 convert 0.0.4 -> 0.0.5 pglinter 1.0.0 -> 1.0.1 pgdd 0.6.0 -> 0.6.1 pg_session_jwt 0.3.3 -> 0.4.0 pg_anon 2.4.1 -> 2.5.1 pg_enigma 0.4.0 -> 0.5.0 wrappers 0.5.6 -> 0.5.7 …

Update extension metadata: pg_search, pgmq, pg_stat_monitor Update pgdg repo URL, the extras now move to parent directory Bump ivorysql to 5.0 (compatible with PG 18.0) Bump Percona Postgres TDE Kernel to 18.1 Checksums Copy all checksums Download …

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

Add new command: pig repo reload to update repo metadata Fix EL PGDG sysupdate aarch64 repo issue (now aarch64 repo ready) Fix EL10.aarch64 PGDG repo renaming issue Update extension versions Bump Pigsty version to 3.7.0 Checksums Copy all checksums …

My earlier post “PG ‘Export Controls’ and Supply-Chain Trust” drew a comment from an administrator at Tsinghua University’s TUNA mirror: “As a university mirror admin, calling us ‘lying flat’ or ‘irresponsible’ is unfair and demoralizing.” I replied: …

Extension list update, + 6 new extensions, 437 total Add PGDG EL10 Sysupdate repo Add LLVM APT repo Use local extension.csv catalog in pig build sub command Updated extensions: vchord pg_later pgvectorscale pglite_fusion pgx_ulid pg_search citus …