Release Notes

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 …

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

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

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 …

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 dc78def9a1e5eb483ac5df4c87f4ac0ef2018bb12b4bedff650d8ba4d58a05fd pig-1.3.4-1.aarch64.rpm 998fcbdab1846c94c3155391d2100dad9b0fe338f48212022db38980bb11e696 pig-1.3.4-1.x86_64.rpm …

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 …

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 …

This version is a planned architecture-level upgrade 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 …

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 …

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 …

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 …

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 …

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 …

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 …

Add support for Debian 13 and EL 10 distributions Massive extension updates to the latest versions with PostgreSQL 18 support Almost all Rust extensions now support PG 18 via pgrx 0.16.1 pig build command overhaul pig build pkg <pkg> will now …

Use official PG 18 repo instead of testing repo Add v prefix when specifying pigsty version string Improved network connectivity check Checksums 01f5b7dc20644226c762dbb229768347 pig_0.6.2-1_amd64.deb ce4f00256adc12cbea91467b7f2241cd …

Add el10 and debian 13 trixie support stub Dedicated website: /docs/pig/ Rebuild with go 1.25 and CI/CD pipeline Use PIGSTY PGDG mirror in mainland China Remove unused pgdg-el10fix repo Use Pigsty WiltonDB mirror Add EL 10 dedicated epel repo pig …

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 422 New extension: pgactive from AWS Bump timescaledb to 2.20.3 Bump citus to 13.1.0 Bump vchord to 0.4.3 Bug fix pgvectorscale debian/ubuntu pg17 failure Bump kubernetes repo to 1.33 Bump default pigsty version to 3.5.0 …

Update the extension list to 421 Add openhalo/orioledb support for Debian / Ubuntu pgdd 0.6.0 (pgrx 0.14.1) convert 0.0.4 (pgrx 0.14.1) pg_idkit 0.3.0 (pgrx 0.14.1) pg_tokenizer.rs 0.1.0 (pgrx 0.13.1) pg_render 0.1.2 (pgrx 0.12.8) pgx_ulid 0.2.0 …

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 Release: https://github.com/pgsty/pig/releases/tag/v0.4.1

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

curl https://repo.pigsty.io/pig | bash -s 0.3.4 Routine extension metadata update Use aliyun epel mirror instead of broken tsinghua tuna mirror Bump pigsty version string Add gitlab repo to the repo list Release: …

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 …

Enhancement New extensions Use upx to reduce binary size Remove embedded pigsty to reduce binary size Release: https://github.com/pgsty/pig/releases/tag/v0.3.2

Routine bugfix Fix repo format string Fix ext info links Update pg_mooncake metadata Release: https://github.com/pgsty/pig/releases/tag/v0.3.1

The pig project now has a new homepage, along with the PostgreSQL Extension Catalog. Release: https://github.com/pgsty/pig/releases/tag/v0.3.0

404 Extensions Available in Pig v0.2.2 Release: https://github.com/pgsty/pig/releases/tag/v0.2.2

Release: https://github.com/pgsty/pig/releases/tag/v0.2.0

Release: https://github.com/pgsty/pig/releases/tag/v0.1.4

v0.1.3, routine update, with 390 extensions available now! Release: https://github.com/pgsty/pig/releases/tag/v0.1.3

351 PostgreSQL Extensions, including the powerful postgresql-anonymizer 2.0 Release: https://github.com/pgsty/pig/releases/tag/v0.1.2

Update Extension List Release: https://github.com/pgsty/pig/releases/tag/v0.1.1

pig CLI v0.1 released Release: https://github.com/pgsty/pig/releases/tag/v0.1.0

Genesis Release Release: https://github.com/pgsty/pig/releases/tag/v0.0.1