Skip to content

Release

pig — PostgreSQL Package Manager Release Notes

Changes for v1.11.0 and earlier versions are listed below.

VersionDateSummaryGitHub
v1.11.02026-11-12Pigsty 4.6.0, sty conf shorthand lookup, stronger operational safeguards, 625 catalog entriesv1.11.0
v1.10.42026-11-06Seven new catalog entries, refreshed package metadata, target-version alias fixes, and 626 entries.v1.10.4
v1.10.32026-10-29Four new extensions, metadata refresh, 620 catalog entriesv1.10.3
v1.10.22026-10-24pg_nanotime, extension and package updates, 616 catalog entriesv1.10.2
v1.10.12026-10-24Go 1.27.3 security fix, dependency updates, 615 catalog entriesv1.10.1
v1.10.02026-10-17603 catalog entries, PostgreSQL target and recovery safety, faithful Inventory, automation fixesv1.10.0
v1.9.02026-10-06600 catalog entries, Xray roles, repository keys, pgrx 0.19.3v1.9.0
v1.8.12026-09-03CLI/repository safety, debug packages by default, pgrx 0.19.2v1.8.1
v1.8.02026-08-14Native sty boot and sty conf, 575 packaged extensionsv1.8.0
v1.7.02026-08-12EL module policy, China mirrors, EL7 compatibility, 575 extensionsv1.7.0
v1.6.22026-08-11572 extensions, Grafana schema v2, SOW-first repository generationv1.6.2
v1.6.12026-07-30Catalog refresh and embedded Pigsty 4.5.0v1.6.1
v1.6.02026-07-28562 packaged extensions, patronictl passthrough, inventory & CMDB, Grafanav1.6.0
v1.5.12026-07-08PG kernel fork updates, mirror mode, bug fixesv1.5.1
v1.5.02026-07-04531 extensions, pigsty v4.4, pg/pt/pb/pitr rework, clone & forkv1.5.0
v1.4.22026-06-18524 extensions, PG19 beta, pgrx 0.18.1, Patroni fixesv1.4.2
v1.4.12026-05-01510 extensions, Ubuntu 26.04 support, repo calibrationv1.4.1
v1.4.02026-04-19510 extensions, pgrx 0.18.0, more building specsv1.4.0
v1.3.42026-04-14504 extensions refreshed, release checksums updatedv1.3.4
v1.3.32026-04-10481 extensions and Go 1.26.2 updatev1.3.3
v1.3.22026-03-23Routine metadata refresh, new pg tune, new build aliasesv1.3.2
v1.3.12026-03-05Retire PG13 defaults, unify PG14-18 support window, 464 extensionsv1.3.1
v1.3.02026-02-27Build pipeline hardening, 461 extensions, new pgedge/ivory supportv1.3.0
v1.2.02026-02-23Unified aliases, routine updates, plan mode, repo fixesv1.2.0
v1.1.12026-02-14Path, symlink, and build migration fixesv1.1.1
v1.1.02026-02-12451 extensions, Agent-Native CLI frameworkv1.1.0
v1.0.02026-01-26New pg/pt/pb/pitr commands, availability matrixv1.0.0
v0.9.02025-12-28Rename sty deploy and expand sty conf optionsv0.9.0
v0.8.12025-12-27Restore llvmjit to the pgsql-full aliasv0.8.1
v0.8.02025-12-26440 extensions, remove sysupdate repov0.8.0
v0.7.52025-12-12Routine extension update, fixed aliyun mirrorv0.7.5
v0.7.42025-12-01Update ivory/pgtde kernel and pgdg extrasv0.7.4
v0.7.32025-11-24Fix repo for el10 & debian13v0.7.3
v0.7.22025-11-20437 extensions, fix pig build issuev0.7.2
v0.7.12025-11-10New Website, improve in-docker experiencev0.7.1
v0.7.02025-11-05Build Enhancement and massive upgradev0.7.0
v0.6.22025-10-03PG 18 official Repov0.6.2
v0.6.12025-08-14CI/CD, el10 stub, PGDG CN Mirrorv0.6.1
v0.6.02025-07-17423 extension, percona pg_tde, mcp toolboxv0.6.0
v0.5.02025-06-30422 extension, new extension catalogv0.5.0
v0.4.22025-05-27421 extension, halo & oriole debv0.4.2
v0.4.12025-05-07414 extension, pg18 alias supportv0.4.1
v0.4.02025-05-01do & pt sub-cmd, halo & orioledbv0.4.0
v0.3.42025-04-05routine updatev0.3.4
v0.3.32025-03-25alias, repo, depsv0.3.3
v0.3.22025-03-21new extensionsv0.3.2
v0.3.12025-03-19minor bug fixv0.3.1
v0.3.02025-02-24new home page and extension catalogv0.3.0
v0.2.22025-02-22404 extensionsv0.2.2
v0.2.02025-02-14400 extensionsv0.2.0
v0.1.42025-02-12routine bugfixv0.1.4
v0.1.32025-01-23390 extensionsv0.1.3
v0.1.22025-01-12the anon extension and 350 other extv0.1.2
v0.1.12025-01-09Update Extension Listv0.1.1
v0.1.02024-12-29repo, ext, sty, and self-updatev0.1.0
v0.0.12024-12-23Genesis Releasev0.0.1

v1.11.0

PIG v1.11.0 embeds Pigsty v4.6.0, adds ordered template shorthand lookup to pig sty conf, strengthens package and operational safeguards across ext, repo, do, pg, pb, pitr, sty, and inventory, and updates the embedded PostgreSQL extension catalog to 625 entries.

Command and Package Safeguards

  • Protected package removal: pig ext rm prevents accidental removal of PostgreSQL server, shared contrib, and supported alternative kernels through extension names or category aliases (error 100102, exit 2). Standalone procedural-language packages remain removable by extension name. Removing server/kernel groups requires explicit aliases such as pg18-server, pg18-contrib (EL only), or orioledb-server. See the protected-removal design.
  • APT Release-level trust: pig repo add and repo set reconcile trusted and signed-by by APT URI/suite before writing files, preserve signature verification enabled by sty boot when appending modules, and reject explicit conflicts early.
  • Pigsty removal safeguards: pig do pgsql-rm defaults to pg_rm_pkg=false, using pg_rm_pkg=true only with --uninstall. pig do pgmon-rm consistently removes /infra/targets/pgrds/<cluster>.yml on infra hosts, matching pgmon-add. See the operational CLI safety contract.
  • PostgreSQL and recovery commands: text pig pg status matches structured exit codes and no longer depends on external test when already running as the target DBSU. pig pg psql -f enables ON_ERROR_STOP=1 and resolves caller-relative paths before switching users; internal database enumeration uses psql -X. pig pg fork pins independent data_directory, hba_file, ident_file, port, and archive/recovery overrides in both postgresql.conf and postgresql.auto.conf and retains --force in retry prompts. pig pg vacuum / pig pg freeze require --table with --schema. pig pg kill / pig pg tune reject invalid PID, polling, and floating-point bounds. pig pb restore / pig pitr retain compound incremental/differential labels, reject forwarded --reset-* / --no-* overrides and empty -D, and hide raw option values in diagnostics.
  • Structured output and configuration fidelity: early argument errors support -ojson without crossing --; atomic rewrites preserve original modes instead of falling back to 0644; legacy wrapper downloads suppress progress on stdout. Bounded diagnostics retain both ends, while configuration and SQL are read in full. pig inventory cmdb dump preserves signed/unsigned 64-bit integers and float types and recognizes multi-host PostgreSQL URIs and sslpassword. pig pt status returns structured JSON on Patroni parse errors. pig sty grafana rejects unsafe dashboard path components and redacts malformed endpoint URLs.
  • Catalog loading and installation paths: pig ext honors configured catalog sources and validates PostgreSQL installation paths before installation.

Pigsty 4.6.0 Bootstrap and Configuration

  • pig sty conf resolves bare names in Pigsty’s fixed order: conf/, conf/ha/, conf/fork/, conf/app/, conf/demo/, conf/build/. Shorthands such as full, trio, and oss retain the selected template’s version pinning and preflight rules.
  • pig sty conf can write an explicit or detected default region over a template’s china, keeping file output and structured results consistent.
  • pig sty boot and pig repo boot look for /var/tmp/pkg.tgz first, falling back to /tmp/pkg.tgz only when the preferred path is absent. Unsafe or unreadable automatically selected archives are rejected before creating destination directories.

Extension Catalog and Package Aliases

  • Add kes and openbao to the infra group on EL and Debian/Ubuntu.
  • Update nine embedded entries: login_hook (1.8 → 1.9), pg_curl (2.4.6 → 2.5.0), pg_improv (0.12.2 → 0.14.0), pg_integrity_checksums (2.1.0 → 2.2.0), pg_mentat (1.19.1 → 1.20.0), pg_search (0.26.5 → 0.26.6), pg_tokenizer (1.0.0 → 1.1.0), vchord (1.2.0 → 1.3.0), and vchord_bm25 (1.0.0 → 1.1.0).
  • Remove the retired documentdb_distributed record, clean stale require_by references from citus, documentdb, and documentdb_core, and restore columnar to available.

Catalog Counts and Build Versions

The embedded catalog has 625 records, all 625 available, with 0 retained removed records. Including PostgreSQL contrib modules, these map to 518 distinct package names and 457 non-contrib package families. See Catalog Counts.

PIG v1.11.0 is built with Go 1.27.4, embeds Pigsty 4.6.0, and defaults to cargo-pgrx 0.19.3. See Installation for upgrades.

Release artifacts: v1.11.0

Checksums

Download asset
FileChecksum
pig-1.11.0-1.aarch64.rpm Linuxarm64SHA-256c3c24b64…bcac
pig-1.11.0-1.x86_64.rpm Linuxamd64SHA-2562c0d05ab…36b9
pig-v1.11.0.darwin-amd64.tar.gz macOSamd64SHA-256d9c0b9b3…6cd9
pig-v1.11.0.darwin-arm64.tar.gz macOSarm64SHA-256474788f7…da27
pig-v1.11.0.linux-amd64.tar.gz Linuxamd64SHA-2568f21efdd…974c
pig-v1.11.0.linux-arm64.tar.gz Linuxarm64SHA-2564c269961…bdcd
pig_1.11.0-1_amd64.deb Linuxamd64SHA-2564bf90bbd…ea5a
pig_1.11.0-1_arm64.deb Linuxarm64SHA-256ba4fb6cd…4979

v1.10.4

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 pgcontext_pgvector record, for a net increase of six.

New catalog entries

ExtensionVersionPostgreSQL supportDescription
pg_warren0.8.015–18Versioned graph traversal and computation over PostgreSQL tables
pg_statecharts0.1.016–18Hierarchical state machines and transactional event handling
pg_statecharts_dev0.1.016–18SCXML import and migration tooling for pg_statecharts
pg_lion0.3.016–18Roaring bitmap inverted indexes for filtering, counts and aggregates
pg_lion_citext0.3.016–18Case-insensitive citext operator class for lion indexes
pg_lion_vector0.3.016–18Filtered nearest-neighbor indexes for pgvector vector and halfvec
opencc0.1.014–18OpenCC conversion between Simplified Chinese, Traditional Chinese, regional variants and Japanese Shinjitai

Installability depends on the target PostgreSQL major, operating system, architecture, and configured repository.

Version and package metadata updates

Selected catalog version changes:

ExtensionVersion change
postgis3.6.4 → 3.7.0
timescaledb_toolkit1.26.0 → 1.27.0
vchord1.1.1 → 1.2.0
vchord_bm250.3.0 → 1.0.0
pg_tokenizer0.1.1 → 1.0.0
pg_search0.26.3 → 0.26.5
pg_duckdb1.1.1 → 1.2.0
pg_lake3.5 → 3.6
anon3.2.3 → 3.3.2
pg_integrity_checksums2.0.0 → 2.1.0

The refresh also updates package availability, dependencies, descriptions, and source metadata. PostGIS 3.7 uses the postgis37_N RPM family, with separate address-standardizer and Tiger Geocoder packages. The EL pgaudit catalog uses pgaudit_14 and pgaudit_15 for PostgreSQL 14 and 15.

Category aliases follow the target version

For stable PostgreSQL versions, pgsql-<category> -v N now selects the same platform and PostgreSQL-major matrix as pgN-<category>. For example, pig ext add pgsql-gis -v 14 --plan no longer includes packages available only for a newer PostgreSQL major. Package names come from the catalog, replacing the obsolete pgaudit rename in the resolver. Beta targets retain the existing latest-stable, PGDG-only fallback.

Catalog count and build versions

The embedded catalog contains 626 records: 624 available entries and 2 retained removed records. They map to 518 distinct package names, including PostgreSQL contrib modules, or 457 non-contrib package families. See the catalog-entry counting rule.

Go remains at 1.27.3, embedded Pigsty at 4.5.0, and default cargo-pgrx at 0.19.3. Follow the installation guide to upgrade PIG.

Release artifacts: v1.10.4

Checksums

Download asset
FileChecksum
pig-1.10.4-1.aarch64.rpm Linuxarm64SHA-2564981a060…13ce
pig-1.10.4-1.x86_64.rpm Linuxamd64SHA-256d1624bbc…2b07
pig-v1.10.4.darwin-amd64.tar.gz macOSamd64SHA-25693847598…119e
pig-v1.10.4.darwin-arm64.tar.gz macOSarm64SHA-256d0f876a5…9b0d
pig-v1.10.4.linux-amd64.tar.gz Linuxamd64SHA-2561caa6f4a…fe0b
pig-v1.10.4.linux-arm64.tar.gz Linuxarm64SHA-256756b7c94…80ba
pig_1.10.4-1_amd64.deb Linuxamd64SHA-25698bbfce9…5bf3
pig_1.10.4-1_arm64.deb Linuxarm64SHA-25618447ccf…38e1

v1.10.3

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

ExtensionVersionPostgreSQL supportDescription
oai_fdw1.1614–18Read-only OAI-PMH foreign data wrapper for metadata harvesting over HTTP/HTTPS
pg_agent_gate0.3.018SQL proposal, verification, and execution gate with human approval for agent roles
pg_integrity_checksums2.0.014–18Physical and logical checksums for PostgreSQL pages, rows, tables, indexes, and databases
pg_stat_tcpinfo1.114–18Linux TCP connection statistics, latency, and retransmission metrics

These records describe catalog and package availability; actual installability still depends on the target PostgreSQL major, operating system, architecture, and repository snapshot.

Version and metadata refresh

The catalog updates existing package and extension metadata, including pg_nanotime 0.2.0 → 0.3.0, supautils 3.4.4 → 4.0.0, pg_ducklake 1.0.2 → 1.0.3, pg_improv 0.10.0 → 0.12.1, wrappers 0.6.3 → 0.6.4, edtf_postgres 1.2.3 → 1.3.2, hypopg 1.4.3 → 1.4.4, and rdf_fdw 3.0 → 3.1. It also refreshes package matrices, compatibility ranges, descriptions, and source metadata for the maintained catalog.

Catalog count

The catalog now contains 620 entries: 617 available records and 3 retained removed records. The catalog-entry counting rule includes SQL utilities and lifecycle records; availability remains platform-specific.

Go remains at 1.27.3, embedded Pigsty at 4.5.0, and default cargo-pgrx at 0.19.3. Follow the installation guide to upgrade PIG.

Checksums

Download asset
FileChecksum
pig-1.10.3-1.aarch64.rpm Linuxarm64SHA-2562068ca81…66ea
pig-1.10.3-1.x86_64.rpm Linuxamd64SHA-25697ff1c17…4ceb
pig-v1.10.3.darwin-amd64.tar.gz macOSamd64SHA-25616203993…004c
pig-v1.10.3.darwin-arm64.tar.gz macOSarm64SHA-2560eb3f044…fb14
pig-v1.10.3.linux-amd64.tar.gz Linuxamd64SHA-256a3e61d0d…2e04
pig-v1.10.3.linux-arm64.tar.gz Linuxarm64SHA-2565f25ff6c…4ecf
pig_1.10.3-1_amd64.deb Linuxamd64SHA-256dfabbcf4…721a
pig_1.10.3-1_arm64.deb Linuxarm64SHA-2564065ed14…045f

Release artifacts: v1.10.3

v1.10.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 nanosecond timestamp and fixed-duration interval types. The catalog records RPM and DEB packages for PostgreSQL 17 and 18. Upstream classifies 0.2.0 as a testing release.

Version updates

ExtensionPreviousUpdated
citus, citus_columnar14.2.014.3.0 packages
duckdb_fdw2.0.12.0.2
pg_mentat1.17.21.18.0
pg_tre4.5.14.5.2

The Citus catalog extension version is 14.3-1; its RPM and DEB package version is 14.3.0. The refresh also adds DEB availability metadata for pg_tre on PostgreSQL 17 and 18.

Catalog metadata

  • Update PostgreSQL compatibility, package availability, licenses, and descriptions.
  • Set the duckdb_fdw catalog range to PostgreSQL 15–18 and pgcontext_pgvector to PostgreSQL 17.
  • Count 616 catalog entries: 613 available records and 3 retained removed records. The catalog-entry counting rule includes SQL utilities and lifecycle records; availability still depends on the platform and PostgreSQL major version.

Go remains at 1.27.3, embedded Pigsty at 4.5.0, and default cargo-pgrx at 0.19.3. Follow the installation guide to upgrade PIG.

Checksums

Download asset
FileChecksum
pig-1.10.2-1.aarch64.rpm Linuxarm64SHA-256f07992b2…62ed
pig-1.10.2-1.x86_64.rpm Linuxamd64SHA-256372f4fe8…0b20
pig-v1.10.2.darwin-amd64.tar.gz macOSamd64SHA-256a54be0a4…d864
pig-v1.10.2.darwin-arm64.tar.gz macOSarm64SHA-25660df049a…a731
pig-v1.10.2.linux-amd64.tar.gz Linuxamd64SHA-256686c5d6c…bd8a
pig-v1.10.2.linux-arm64.tar.gz Linuxarm64SHA-256e1e84d5a…afeb
pig_1.10.2-1_amd64.deb Linuxamd64SHA-25638b9634b…a63b
pig_1.10.2-1_arm64.deb Linuxarm64SHA-2564034cebd…ae58

Release artifacts: v1.10.2

v1.10.1

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 to 1.27.3. CI and release builds read the version from go.mod.
  • Include the crypto/x509 fix for CVE-2026-111943 / GO-2026-6809. Go’s certificate verifier rejects chains containing specific intermediate certificates that are no longer trusted.

Go 1.27.3 adds one security fix over 1.27.2, as documented in the Go release announcement. Earlier Go security fixes are already included in the 1.27.2 baseline used by PIG v1.10.0.

Dependency updates

Update inherited tooling dependencies through version-specific module replacements:

ModulePreviousUpdated
github.com/cpuguy83/go-md2man/v2v2.0.6v2.0.7
github.com/stretchr/objxv0.1.0v0.8.0
golang.org/x/modv0.41.0v0.42.0
golang.org/x/toolsv0.51.0v0.52.0

Extension catalog

The embedded catalog now contains 615 entries, with 12 additions since v1.10.0:

  • codesystem, encsearch, hdr_histogram, pg_improv
  • pg_kv, pg_lease, pg_synonym, pg_table_range
  • pg_tre, pg_try_cast, stannum, tin

The refresh also updates existing extension versions and package availability metadata. The total follows the catalog-entry counting rule: it includes packaged SQL utilities and retained records for removed extensions. It does not imply that all 615 entries support CREATE EXTENSION or can be installed on every platform.

Compatibility

Commands, flags, and configuration remain compatible with v1.10.0. Embedded Pigsty remains at 4.5.0, and default cargo-pgrx remains at 0.19.3.

Building from source requires Go 1.27.3 or later. Prebuilt packages do not require a local Go installation. Follow the installation guide to upgrade PIG. Replacing the PIG executable brings in the updated Go standard library; upgrading the host’s Go installation alone does not update an existing PIG binary.

Checksums

Download asset
FileChecksum
pig-1.10.1-1.aarch64.rpm Linuxarm64SHA-256fbd58de4…a69d
pig-1.10.1-1.x86_64.rpm Linuxamd64SHA-2567955e937…629b
pig-v1.10.1.darwin-amd64.tar.gz macOSamd64SHA-25631fea0e9…7942
pig-v1.10.1.darwin-arm64.tar.gz macOSarm64SHA-2561177f3b6…2c5a
pig-v1.10.1.linux-amd64.tar.gz Linuxamd64SHA-2560e837098…3b50
pig-v1.10.1.linux-arm64.tar.gz Linuxarm64SHA-25666582428…f397
pig_1.10.1-1_amd64.deb Linuxamd64SHA-25637f5dca9…2eab
pig_1.10.1-1_arm64.deb Linuxarm64SHA-256f385d1c6…9be5

Release artifacts: v1.10.1

v1.10.0

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 performed. The bundled catalog grows from 600 to 603 records. Embedded Pigsty remains 4.5.0; the default cargo-pgrx remains 0.19.3.

PostgreSQL targets and maintenance

  • An explicit -D binds psql, ps, kill, vacuum, analyze, freeze, and repack to the selected instance, including --all database enumeration. PIG validates the PID, data directory, port, socket, and process identity before starting the SQL client. Invalid, stale, copied, or uncertain runtime metadata causes failure instead of a fallback to another instance.
  • Without -D, those SQL commands retain native client connection defaults. pg clone and pg fork retain their own port options. Promotion timeline checks use the selected instance or its control data; an unresolved timeline is left unknown.
  • Plans and confirmation retry commands preserve the selected data directory, PostgreSQL version, operating-system user, and maintenance options. VACUUM FULL plans correctly require confirmation.
  • Maintenance operands are literal database names. Values containing = or beginning with postgres:// or postgresql:// are rejected before planning or execution, without echoing the value. Spaces and non-ASCII names remain supported. Generated commands put names after --, so a database named --all cannot become a command option.
  • vacuum, analyze, and freeze --all validate the complete database list before maintenance begins. Use native clients when a connection string or a database name rejected by this boundary is required.

See pig pg for target selection and maintenance commands for database-name rules.

Runtime state, recovery, and fork safety

  • Permission failures, malformed PID metadata, and unavailable process identity are reported as errors or unknown state. They cannot authorize forced initialization, restore, or fork replacement. pg status returns 130201 (exit 3) for permission failures and 130808 (exit 1) for other runtime-probe failures. Plans report an unresolved precondition as unknown.
  • Declining PITR confirmation or reaching EOF returns 161001 (exit 7) before any service stop, restore, or startup. An unknown state cannot supply a PID for forced termination or count as successful startup. Post-restore SQL checks require a verified target.
  • Replacing a nonempty unmanaged fork requires valid ownership metadata with a matching explicit target path. Missing, damaged, or mismatched metadata cannot authorize deletion. Existing protections for running targets and source/destination relationships remain in force.
  • Clone and fork path checks run as the selected database operating-system user when needed, supporting private 0700 data directories. An inaccessible or unresolved path cannot bypass validation. Managed orphan cleanup remains available through the managed fork name.
  • Files written as the database user use private sibling staging and exact-target replacement. The new file has 0600 permissions; directory or symlink targets are refused, and replacement does not overwrite the contents of another hard link to the old file.

The PITR reference explains the managed recovery workflow; pig pb restore remains a separate restore primitive.

Inventory and Pigsty

  • sty deploy and do pass the resolved Inventory path explicitly to Ansible. Flag and environment paths resolve from the caller’s working directory; quoted ~/ paths expand before resolution. A selected missing or invalid source does not silently fall back to another inventory.
  • pg_users[].roles preserves both role-name strings and structured grants, including grant state and optional admin, set, and inherit attributes.
  • Editing, serialization, and CMDB export retain strings that YAML consumers might otherwise interpret as numbers, dates, or timestamps. Existing timestamp scalars retain their original source representation. Independent PyYAML checks verify the emitted string types.
  • sty conf --proxy accepts uppercase and lowercase HTTP, HTTPS, ALL, and NO proxy variables. Missing HTTP and HTTPS values both fall back to ALL_PROXY. Version completion observes dotted version boundaries, so a request for 1.1 cannot select 1.10.

See Inventory source selection and pig sty.

Repositories and extensions

  • Repository commands validate the complete operand list before changing files. Empty values, empty comma-separated elements, and unsafe repository names fail before mutation. Only truly argument-free repo rm backs up all repository files; repo rm all expands the node, pgsql, and infra modules. Removal results preserve the original request and distinguish missing targets from removed files. --update also refreshes the cache after a full backup.
  • Repository creation retains documentation RPMs. Debug package suppression continues to use --nodbg; a -docs or -doc name alone does not make a package a debug package.
  • Default extension lists, availability summaries, and refresh results count all catalog records, including SQL utilities and retained lifecycle entries. The total describes catalog coverage, not how many extensions can be installed on one host or enabled with CREATE EXTENSION.
  • Text, JSON, and YAML share availability rules. On covered Linux platforms, package matrices take precedence and a missing matrix cell means unavailable. Architecture aliases are normalized. On macOS, the status describes declared PostgreSQL support without promising an RPM/DEB package. ext list -v selects the version used to evaluate status; unavailable records remain listed.
  • ext import reports failure if any requested package cannot be resolved or downloaded, while retaining successful downloads and reporting the completed and failed portions. APT virtual dependency markers are excluded from package download requests. Installed-library scanning also recognizes catalog entries without a control file.
  • The three new catalog records are pg_icu_parser, pg_vectorsearch, and textsearch_intl. Existing versions and platform metadata are refreshed as well. Use pig ext avail NAME to inspect a target before installing.

Details: pig repo, pig ext.

Builds and automation

  • Multi-version build dependency installation expands package names for every selected PostgreSQL major version and removes duplicates. Default build targets retain their metadata and local installation rules independently of package-matrix gaps.
  • Debian/Ubuntu builds preserve the inherited PATH order and append the current user’s ~/.cargo/bin when present, preserving an explicitly selected toolchain.
  • Xray setup recognizes complete legacy service definitions, including marker-free macOS plists generated by the previous renderer. A comment alone cannot prove ownership; changed or foreign definitions still require explicit replacement. Matching reruns preserve a running service.
  • JSON/YAML output and PIG_NON_INTERACTIVE=1 consistently disable prompt input and use non-interactive sudo in PIG-owned adapters. Explicit data-input channels remain available; native Patronictl forwarding retains its interaction and exit contract.
  • CMDB connection strings, legacy VMess credentials, and license keys are excluded from routine parameters and failure details. Explicit credential export and raw Inventory display retain their documented sensitive-output behavior.
  • Exporter HTTP 4xx/5xx responses now fail with the numeric status and standard description, without including response bodies or custom status text. Unsupported pig update platforms fail explicitly. Command help and bilingual references are aligned with these behaviors.
  • Go dependencies and validation tools are refreshed. CI includes Linux permission and instance boundary acceptance plus independent YAML consumer checks.

See pig build, pig pe, and global command behavior.

Upgrade notes

Existing command names and flags remain available. Automation should handle the corrected failure statuses for partial imports, HTTP errors, cancelled recovery, and indeterminate PostgreSQL state. Scripts must supply valid repository operands, explicit confirmation where required, and literal maintenance database names. When a name begins with -, place all options before -- and the name.

Upgrade with the installation instructions.

Release artifacts: v1.10.0


v1.9.0

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 servers

  • pig build proxy installs or verifies Xray. pig build proxy client configures a VLESS/REALITY/Vision HTTP/SOCKS client; pig build proxy server configures a Linux server. Linux uses systemd; the macOS client uses a dedicated user LaunchAgent.
  • Client input accepts a standard VLESS URI, --from FILE/-, or explicit connection flags. The first client listener is 127.0.0.1:12345; the first direct server listener is 0.0.0.0:443. Repeated setup preserves existing listeners and server credentials.
  • Matching configuration, ownership, permissions, and service state avoid rewrites and restarts. Failed client connectivity checks restore prior managed files and service state. Replacing a different client requires --replace --yes; --plan previews either role.
  • server --export-only --host HOST --export - exports an existing connection without changing the deployment. File exports use mode 0600; explicit stdout export requires text output. Ordinary results and plans omit credentials. The historical VMess positional form remains available through V2Ray.
sudo pig build proxy server --host proxy.example.com --target www.sraoss.co.jp:443 --export ./client.uri
sudo pig build proxy client --from ./client.uri

Run the server command on the server, then transfer client.uri securely to the client and run the client command there. See pig build for prerequisites and macOS setup.

Repository keys

  • repo add, repo set, and sty boot prepare the embedded Pigsty public key when selected repositories need it. Existing regular key files are reused; missing defaults are installed offline at /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty or /etc/apt/keyrings/pigsty.asc.
  • Implicit default-key failure emits a warning and falls back only for selected Pigsty definitions. Default key references remain stable, including APT signed-by.
  • Explicit signing-key references are mandatory: invalid or unavailable keys fail before repository replacement or cache refresh. EL imports explicit references with rpm --import. Selecting unrelated repositories does not prepare the Pigsty key.

See pig repo for signature-enforcement defaults and the distinction between key preparation and metadata refresh.

Catalog and build defaults

  • The embedded catalog contains 600 entries, adding 22 entries to the v1.8.1 snapshot. New entries include edtf_postgres, plphp, pg_lexo, pg_money, istore, colnames, pg_statkit, pgtelemetry, pg_rusage, pgexporter_ext, pg_statvfs, and libx509pq. Package versions and platform-availability metadata are refreshed as well.
  • The catalog total includes retained lifecycle records. Installability depends on each extension’s state and OS/architecture/PostgreSQL matrix. Use pig ext avail NAME to check a target.
  • pig build pgrx defaults to cargo-pgrx 0.19.3. An explicit -v and extension-specific catalog metadata continue to select another required version.
  • Platform debug packages remain enabled by default, as in v1.8.1. Use --nodbg for RPM debuginfo/debugsource and DEB dbgsym suppression; -s|--symbol is a deprecated no-op.

Compatibility

No existing command or flag is removed. New Xray role commands use VLESS/REALITY/Vision; existing positional VMess commands retain their V2Ray behavior. Server setup checks the local listener and service. Configure the firewall, cloud security group, and any Nginx frontend for the chosen public port, then verify the connection from the client.

Release artifacts: v1.9.0

Verification

The verified v1.9.0 tag points to 9eb5488. The exact commit passed full CI, including randomized tests, command race regressions, vet, static analysis, vulnerability scanning, and a release snapshot. The Release workflow produced eight Linux/macOS archives and RPM/DEB packages. Published downloads were verified against SHA-256.

Checksums

Download asset
FileChecksum
pig-1.9.0-1.aarch64.rpm Linuxarm64SHA-256d0d80bd2…180f
pig-1.9.0-1.x86_64.rpm Linuxamd64SHA-256e3b25640…6a7c
pig-v1.9.0.darwin-amd64.tar.gz macOSamd64SHA-256d7eb266e…cab9
pig-v1.9.0.darwin-arm64.tar.gz macOSarm64SHA-25609628457…8824
pig-v1.9.0.linux-amd64.tar.gz Linuxamd64SHA-256a4b5ffca…afd2
pig-v1.9.0.linux-arm64.tar.gz Linuxarm64SHA-256ddfa80fb…8def
pig_1.9.0-1_amd64.deb Linuxamd64SHA-2563d955a24…d93a
pig_1.9.0-1_arm64.deb Linuxarm64SHA-256c175b375…1471

v1.8.1

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 embedded extension catalog and moves the build toolchain to Go 1.27.1 and cargo-pgrx 0.19.2. The embedded Pigsty version remains 4.5.0.

CLI safety and correctness

  • Read-only and configuration-independent commands no longer require a writable HOME or create ~/.pig as a side effect. Leaf commands preserve their declared initialization policy.
  • pig pg log, pig pt log, and pig pb log preserve arguments through sudo execution as the database OS user and reject unsafe log-file links.
  • pig do validates Pigsty names and rejects reserved Ansible cluster targets before execution.
  • Native PostgreSQL role detection is bound to the selected instance rather than an unrelated local default.
  • Structured results redact credentials, license material, and build-proxy identifiers while retaining truthful command failure.

Repository and build hardening

  • Repository add and remove operations now fail when any requested operation fails, deduplicate module selections, and preserve replacement boundaries.
  • Offline cache bundles reject unsafe paths, links, special files, and incomplete inputs; archive extraction remains rooted and fail-closed. The obsolete exported cache wrapper was removed after production moved to the structured result path.
  • Build source and artifact validation rejects incomplete or unsafe inputs. pig build proxy uses the package-provided service contract, treats its operands as optional, and keeps secret identifiers out of structured output.
  • Self-update verifies release checksums, and release tooling refuses dirty or mismatched-tag publication and immutable artifact replacement.

Toolchain and catalog

  • pig build ext and pig build pkg keep platform debug packages enabled by default; use --nodbg to omit them. -s|--symbol remains a deprecated compatibility no-op.

  • Go is updated to 1.27.1; Logrus to 1.10.2; GoReleaser to 2.18.0; and golangci-lint to 2.13.2.

  • pig build pgrx now installs cargo-pgrx 0.19.2 by default. Use -v when an extension requires an older pgrx line recorded in its catalog metadata.

  • The embedded catalog is refreshed from the maintained pgext view. It adds acdat 0.1.0, marks the superseded pgcontext_pgvector entry removed, and updates package versions, repository ownership, PostgreSQL coverage, and availability matrices.

Verification

The release is built from source commit 1c6f524. The exact commit passed the full CI workflow, including randomized tests, command race regressions, vet, static analysis, dead-code detection, vulnerability scanning, and a GoReleaser snapshot. The tag then passed the Release workflow, which produced the published RPM, DEB, macOS, and Linux artifacts.

Compatibility notes

  • No CLI command or flag is removed in this release.
  • Scripts that previously depended on read-only commands creating local configuration should create that state explicitly instead.
  • The pgrx default changes to 0.19.2; extension-specific metadata remains authoritative when a build requires another pgrx version.

Checksums

Download asset
FileChecksum
pig-1.8.1-1.aarch64.rpm Linuxarm64SHA-2564154b3e4…23cf
pig-1.8.1-1.x86_64.rpm Linuxamd64SHA-25635c398f4…869d
pig-v1.8.1.darwin-amd64.tar.gz macOSamd64SHA-2566c08b6a6…8455
pig-v1.8.1.darwin-arm64.tar.gz macOSarm64SHA-2560fb6c86c…b868
pig-v1.8.1.linux-amd64.tar.gz Linuxamd64SHA-2569219e874…bf2b
pig-v1.8.1.linux-arm64.tar.gz Linuxarm64SHA-256b3092488…3078
pig_1.8.1-1_amd64.deb Linuxamd64SHA-2566fc30450…618e
pig_1.8.1-1_arm64.deb Linuxarm64SHA-2561a70cd71…0051

Release artifacts: v1.8.1

v1.8.0

Pig v1.8.0 updates native controller workflows from v1.7.0. Go implementations of pig sty boot and pig sty conf replace wrappers for the legacy bootstrap and configure shell scripts. The packaged PostgreSQL extension count remains 575. The embedded Pigsty version remains 4.5.0.

Highlights

  • pig sty boot can elevate once through sudo. It verifies Ansible and its actual Python runtime. It supports explicit local packages, HTTP(S) URLs, trusted automatic offline packages, committed local repositories, and regional online repositories. It backs up repository configuration before replacement and restores it on failure. It attempts to repair localhost SSH and a missing ~/pigsty, but repair is not guaranteed.
  • pig sty conf generates inventory natively from safe templates. It supports up to ten IP mappings, exact domain replacement, region and proxy settings, PostgreSQL-version selection, and random credentials. It validates the complete candidate, then writes it atomically with mode 0600.
  • Bootstrap download and extraction no longer require curl, wget, tar, or gzip. Offline operation uses only pigsty-local and requires the /www -> /data/nginx layout.
  • EL8 and newer consistently prefer DNF. Local RPM requirements resolve by provider capability. This release updates extension metadata and availability matrices, and moves the toolchain to Go 1.26.6.

Compatibility Notes

  • pig sty boot no longer runs <PIGSTY_HOME>/bootstrap. Automation that relied on script side effects must use the native command.
  • Removed pig sty conf --raw. --conf MODE and positional MODE are equivalent. --ip accepts up to ten addresses. You cannot combine it with --skip.
  • EL8 and newer use DNF. The limited EL7 compatibility catalog keeps its separate legacy YUM path.

Checksums

Artifacts: GitHub Release · checksums.txt

Download asset
FileChecksum
pig-1.8.0-1.aarch64.rpm Linuxarm64SHA-25602fd2628…223b
pig-1.8.0-1.x86_64.rpm Linuxamd64SHA-25672ba72a0…ce8b
pig-v1.8.0.darwin-amd64.tar.gz macOSamd64SHA-256f023a5c9…a65f
pig-v1.8.0.darwin-arm64.tar.gz macOSarm64SHA-256e0ccf61c…0998
pig-v1.8.0.linux-amd64.tar.gz Linuxamd64SHA-256a24a08c1…0353
pig-v1.8.0.linux-arm64.tar.gz Linuxarm64SHA-2569d238758…fa7b
pig_1.8.0-1_amd64.deb Linuxamd64SHA-25696259ff7…7321
pig_1.8.0-1_arm64.deb Linuxarm64SHA-2562e737021…4b63

Release: https://github.com/pgsty/pig/releases/tag/v1.8.0


v1.7.0

Pig v1.7.0 updates repository compatibility and the catalog from v1.6.2. It makes China-mirror selection explicit and preserves native DNF module filtering by default. It restores a simplified EL7 repository catalog. The bundled extension snapshot grows from 572 to 575. The embedded Pigsty version remains 4.5.0.

Highlights

  • -m|--mirror directly selects the bundled china repository definitions. PGDG, Rocky Linux, Debian, Ubuntu, Docker, and other regional routes use the maintained mirror list. This replaces the former PGDG proxy rewrite at runtime.
  • EL repository definitions no longer receive module_hotfixes=1 globally. Pigsty and PGDG repositories explicitly enable it when they need to override module streams. BaseOS, AppStream, EPEL, and other repositories retain native DNF module filtering.
  • EL7 retains a limited compatibility catalog. It includes archived CentOS 7 Base/Updates/Extras/SCLo and EPEL definitions for x86_64, plus shared Pigsty and supported PGDG entries. EL7 YUM rendering removes the DNF-only module_hotfixes key.
  • If the catalog has no matching definitions, repository setup reports an unsupported platform. It no longer continues with an empty repository set.

Extension Catalog

  • Packaged extensions: 572 -> 575, with no removals.
  • Add pg_local_cache 1.2.0, pg_statviz 0.1.0, and pg_policy 0.1.0.
  • Refresh biscuit 3.0.0, pg_clickhouse 0.10.0, pg_search 0.25.2, pg_turbovec packages 1.29.0, pg_uuid_v8 1.1.0, and the Debian q3c 2.0.5 package.

Compatibility Notes

  • No commands or global flags are removed in this release.
  • -m|--mirror now explicitly selects the China region. It no longer rewrites the PGDG proxy. For a specific route, use --region=default|china|europe.
  • Custom EL repository definitions must set meta.module_hotfixes: 1 explicitly to override module streams. Ordinary OS repositories omit this setting. EL7 removes it.
  • EL7 is end-of-life and has only limited compatibility coverage. Prefer EL8 or newer for current PostgreSQL and extension packages.

Checksums

Artifacts: GitHub Release · checksums.txt

Download asset
FileChecksum
pig-1.7.0-1.aarch64.rpm Linuxarm64SHA-256e3a339fe…47d1
pig-1.7.0-1.x86_64.rpm Linuxamd64SHA-25634ce29d7…67f8
pig-v1.7.0.darwin-amd64.tar.gz macOSamd64SHA-256d26803c6…9ba7
pig-v1.7.0.darwin-arm64.tar.gz macOSarm64SHA-256ea8120d4…d3ce
pig-v1.7.0.linux-amd64.tar.gz Linuxamd64SHA-25640295b64…d0bf
pig-v1.7.0.linux-arm64.tar.gz Linuxarm64SHA-25679290917…12d5
pig_1.7.0-1_amd64.deb Linuxamd64SHA-25641523c15…1072
pig_1.7.0-1_arm64.deb Linuxarm64SHA-256adf7b2d9…7ef5

Release: https://github.com/pgsty/pig/releases/tag/v1.7.0


v1.6.2

Pig v1.6.2 adds features and updates the catalog from v1.6.1. Packaged extensions increase from 562 to 572. This release adds native Grafana dashboard schema v2 support and improves local repository generation. The embedded Pigsty version remains 4.5.0.

Highlights

  • pig sty grafana accepts legacy dashboard JSON and native dashboard.grafana.app/v2 Dashboard resources. It loads v2 dashboards through the Grafana resource API to preserve tabs and section variables across loading and dumping. Dumps preserve an existing v2 destination. New dumps use the legacy format by default.
  • When SOW is available, pig repo create prefers sow create --pigsty --timeout 10m -- <dir>. It requires a repo_complete marker that is a regular file. On Linux, it can fall back to createrepo_c / dpkg-scanpackages.
  • Local repository creation works on macOS through SOW. On macOS, it defaults to the current directory and does not require sudo. The Linux default remains /www/pigsty.
  • Release metadata is bumped to 1.6.2; the embedded Pigsty version stays at 4.5.0.

Extension Catalog

  • Packaged extensions: 562 -> 572, with no removals.
  • 10 new extensions: pg_turbovec, pg_disorder, pg_mentat, plruby, jsonb_plruby, hstore_plruby, ltree_plruby, pg_describe, cat_tools, and pg_vault_tde.
  • 12 version refreshes: timescaledb 2.29.1, q3c 2.0.5, pgmnemo 0.16.1, pg_search 0.25.1, citus 14.2.0, citus_columnar 14.2.0, provsql 1.12.0, plpgsql_check 2.10.4, pg_rational 0.0.3, pgbson 2.1.0, pg_readme 0.7.1, and pg_readme_test_extension 0.7.1.
  • Package metadata and availability matrices are refreshed. Run pig ext reload to replace the embedded release snapshot with the latest online catalog.

Compatibility Notes

  • No commands or global flags are removed in this release.
  • With SOW installed, pig repo create prefers it over the legacy Linux generators. It checks for the completion marker before reporting success.
  • The catalog count does not guarantee package availability for every PostgreSQL / OS / architecture combination. Check the target host with pig ext avail NAME.

Checksums

Artifacts: GitHub Release · checksums.txt

Download asset
FileChecksum
pig-1.6.2-1.aarch64.rpm Linuxarm64SHA-2566697a96b…162f
pig-1.6.2-1.x86_64.rpm Linuxamd64SHA-256ad0b3118…a184
pig-v1.6.2.darwin-amd64.tar.gz macOSamd64SHA-256bb167e04…c9db
pig-v1.6.2.darwin-arm64.tar.gz macOSarm64SHA-2563de74e33…a79d
pig-v1.6.2.linux-amd64.tar.gz Linuxamd64SHA-2567b69214e…0294
pig-v1.6.2.linux-arm64.tar.gz Linuxarm64SHA-256b511e727…d5a8
pig_1.6.2-1_amd64.deb Linuxamd64SHA-2563d1a80b8…c4bc
pig_1.6.2-1_arm64.deb Linuxarm64SHA-25600e4c84c…fb44

Release: https://github.com/pgsty/pig/releases/tag/v1.6.2


v1.6.1

Pig v1.6.1 is a maintenance release. It updates the bundled extension catalog and sets the embedded Pigsty version to 4.5.0. It adds no commands and changes no flags.

Highlights

  • Regenerates the embedded extension.csv from Pigsty package repositories. New installations use current package metadata without first running pig ext reload.
  • Update the embedded Pigsty version reported by pig sty and pig status from 4.4.0 to 4.5.0.
  • Keep 562 packaged extensions across PostgreSQL 14-18, EL 8/9/10, Debian 12/13, and Ubuntu 22/24/26 on x86_64 and aarch64.

Checksums

Artifacts: Pigsty Mirror · checksums.txt

Download asset
FileChecksum
pig-1.6.1-1.aarch64.rpm Linuxarm64SHA-256088e62bf…2e77
pig-1.6.1-1.x86_64.rpm Linuxamd64SHA-25611b81f43…f5d3
pig-v1.6.1.darwin-amd64.tar.gz macOSamd64SHA-256f0512d26…080a
pig-v1.6.1.darwin-arm64.tar.gz macOSarm64SHA-256595f122c…1533
pig-v1.6.1.linux-amd64.tar.gz Linuxamd64SHA-256d6c0ad77…83fd
pig-v1.6.1.linux-arm64.tar.gz Linuxarm64SHA-256017fbae1…8627
pig_1.6.1-1_amd64.deb Linuxamd64SHA-256571bc16b…385b
pig_1.6.1-1_arm64.deb Linuxarm64SHA-25654010b41…1fa6

Release: https://github.com/pgsty/pig/releases/tag/v1.6.1


v1.6.0

Pig v1.6.0 is a major release. pig pt becomes a transparent patronictl launcher. The root-level pig inventory group adds lossless editing and validation of pigsty.yml, plus an experimental PostgreSQL CMDB bridge. pig sty grafana adds native Grafana dashboard management. The packaged extension catalog grows to 562.

Highlights

  • pig pt becomes a native patronictl launcher. All cluster commands (list, restart, switchover, failover, edit-config, …) forward directly with native flags, prompts, output, and exit codes. New patronictl features therefore work without a new pig release. Local helpers status, log, set, and service/svc remain. New options are -c/--config-file, -d/--dcs-url, and -k/--insecure. Use pig pt -- … to pass arguments directly.
  • Adds the root-level pig inventory command group (alias inv): status / list / show / edit / validate / check / diff. Its lossless YAML engine preserves comments, formatting, key order, and anchors byte-for-byte. edit validates before writing, then writes atomically. Invalid YAML cannot reach disk.
  • Adds experimental pig inventory cmdb subcommands: check / init / load / dump / enable / disable. They exchange inventory with the PostgreSQL Pigsty CMDB through a native driver. They use bounded timeouts and confirmation tied to a digest for destructive operations.
  • Adds pig sty grafana (alias gf) for native Grafana dashboard management over HTTP. Its commands are info / list / boot / load / init / dump / clean / lang / style. Removes sty edit / validate / check / cmdb / dashboard / release to simplify pig sty. Use pig inventory, pig sty grafana, and pig sty list / get instead.
  • Reliability improvements: repository, catalog, and download writes are atomic, preventing truncated files after interruption. Structured -o json|yaml output keeps only the result envelope on stdout and sends wrapped-tool output to stderr. More specific exit codes distinguish usage errors (2) from missing --yes confirmation (7). Ansible list variables use JSON encoding.
  • Repository updates: MySQL moves to 8.4 LTS, with new Percona XtraBackup (pxb84) and MySQL Tools repositories. Kubernetes moves to v1.36. LLVM APT coverage extends to Debian/Ubuntu 26. Percona TDE uses repo.percona.com directly. Removes the wiltondb repository.
  • Toolchain: Go 1.26.5, new native PostgreSQL driver (pgx v5), embedded Pigsty version 4.4.0.

Extension Catalog

  • Packaged extensions: 531 -> 562; the broader PGEXT.CLOUD directory contains 2,230 entries.
  • 33 new extensions, including the pg_lake family (pg_lake, pg_lake_table, pg_lake_engine, pg_lake_iceberg, pg_lake_copy), pg_jieba, pg_cjk_parser, pg_fts, pgmonitor, pgmemento, pg_tiktoken_c, online_advisor, pgsqlmock, and plx.
  • 2 removed: pg_analytics, spat; 58 version refreshes, including vector 0.8.5, timescaledb 2.28.3, pg_search 0.24.3, pg_tde 2.2.1, and powa 5.2.0.
  • Aligns package aliases with Pigsty. Renames kafka to kafka-stack. The Debian/Ubuntu postgresql alias maps only to postgresql-$v. For the full development set, use pgsql / pgsql-full.

Compatibility Notes

  • ⚠ pig pt failover <name> now treats the positional argument as the cluster, not the promotion candidate. Use pig pt failover CLUSTER --candidate MEMBER. Review failover automation before upgrading.
  • pig pt uses native cluster-first positional arguments (restart CLUSTER [MEMBER]). Forwarded commands return native patronictl exit codes and manage their own confirmation prompts. -y no longer controls those prompts. They no longer support -o json; use native --format json. pig pt set K=V and native show-config / edit-config replace pig pt config.
  • In structured output mode, wrapped-tool output goes to stderr. Stdout contains only the JSON/YAML envelope. Update scripts that parsed mixed output.
  • pig inventory edit tightens the inventory file mode to 0600 after a successful edit, since the file may contain credentials.

Checksums

Download asset
FileChecksum
pig-1.6.0-1.aarch64.rpm Linuxarm64SHA-2566899e8a3…6768
pig-1.6.0-1.x86_64.rpm Linuxamd64SHA-256cabe593f…737c
pig-v1.6.0.darwin-amd64.tar.gz macOSamd64SHA-2561f46d4a0…2231
pig-v1.6.0.darwin-arm64.tar.gz macOSarm64SHA-256845decb9…261d
pig-v1.6.0.linux-amd64.tar.gz Linuxamd64SHA-2564f1bb4fd…89e2
pig-v1.6.0.linux-arm64.tar.gz Linuxarm64SHA-2564384d111…4ed8
pig_1.6.0-1_amd64.deb Linuxamd64SHA-256e35ef0f2…7e8e
pig_1.6.0-1_arm64.deb Linuxarm64SHA-256c3bc6d04…1901

Release: https://github.com/pgsty/pig/releases/tag/v1.6.0


v1.5.1

Pig v1.5.1 updates PG kernel forks to the latest package names.

Highlights

  • Adds mirror/proxy mode to repository, build, sty, update, and extension update workflows. pig build rust -m also configures Cargo mirrors through rsproxy.cn.
  • Adds explicit PostgreSQL 19 beta build options: pig build repo --beta, pig build tool --beta, and pig build pgrx -b. PostgreSQL 18 and PG14-18 remain the stable defaults.
  • Refresh kernel and fork package aliases for IvorySQL, PolarDB, OrioleDB, OpenHaloDB, Babelfish, and the pgEdge suite.
  • Improve the Cloudberry package build flow for cloudberry, cloudberry-backup, and cloudberry-pxf.
  • Refresh source/package metadata for Cloudberry, Babelfish, OrioleDB, pgEdge, PolarDB, polarstore, zlog, libpgfeutils, and libfq.
  • Improve repository generation for newer EL release strings, including PGDG on EL9.6+ / EL10+ and EPEL’s EL10 10z stream.
  • Refresh extension versions including pg_ivm 1.15, spock 5.0.10, snowflake 2.5.0, pg_tde 2.2, decoderbufs 3.6.0, and IvorySQL 5.4 packages.

Checksums

Download asset
FileChecksum
pig-1.5.1-1.aarch64.rpm Linuxarm64SHA-256bc83887d…98e3
pig-1.5.1-1.x86_64.rpm Linuxamd64SHA-256f0eab8e6…4c0a
pig-v1.5.1.darwin-amd64.tar.gz macOSamd64SHA-256b32d894d…e8e7
pig-v1.5.1.darwin-arm64.tar.gz macOSarm64SHA-2564d768829…9932
pig-v1.5.1.linux-amd64.tar.gz Linuxamd64SHA-25669f4a016…e5eb
pig-v1.5.1.linux-arm64.tar.gz Linuxarm64SHA-256f49becb5…e77b
pig_1.5.1-1_amd64.deb Linuxamd64SHA-256a0d15145…6d49
pig_1.5.1-1_arm64.deb Linuxarm64SHA-256f05b9b5a…b9a6

Release: https://github.com/pgsty/pig/releases/tag/v1.5.1


v1.5.0

Pig v1.5.0 updates PostgreSQL operations for daily DBA work. It adds local database clone and fork workflows. It clarifies the roles of pg, pt, pb, and pitr. It also improves previews, confirmation, and structured output for high-risk operations.

Highlights

  • pig pg focuses on local PostgreSQL operations. pig pg clone makes quick database-level copies. pig pg fork creates temporary physical instance forks for local validation, recovery drills, and isolated experiments.
  • Recovery commands have clearer roles. pig pitr coordinates Patroni, PostgreSQL, and pgBackRest. pig pb restore remains the low-level pgBackRest restore command. Restore commands require an explicit target. They provide more specific plans and guidance for steps after recovery.
  • Patroni operations use more consistent behavior. High-risk actions such as pig pt restart, reinit, switchover, and failover use Pig-managed confirmation and plan output. When a restart is required, pig pt config pg directs operators to pig pt restart --pending.
  • Structured output no longer confirms destructive commands. High-risk execution requires explicit -y/--yes. --plan and next_actions provide more consistent workflows to preview an operation before execution.
  • Improves logs and status output for incident response. The pg, pb, and pt log commands support common latest / tail / show / grep workflows. Structured log snapshots use JSONL semantics.
  • Build and release defaults were refreshed: Pig is 1.5.0, embedded Pigsty is 4.4.0, and pig build pgrx defaults to cargo-pgrx 0.19.1.

Extension Catalog

  • Available extensions: 524 -> 531, with no removals.
  • New extensions: pg_ducklake, pgdisablelogerror, pg_stat_log, pg_stat_plans, passwordpolicy, db2fce, plpgsql_wrap.
  • Refreshed a batch of existing extension versions and package metadata, including timescaledb 2.28.2, postgis 3.6.4, vector 0.8.4, biscuit 2.4.1, citus 14.1.0, orioledb 1.8, documentdb 0.113, credcheck 5.0, and pgtt 4.5.
  • orioledb aliases no longer pin to PG17. They resolve against the requested PostgreSQL major version. EL9 ARM64 Patroni aliases now select noarch packages.

Compatibility Notes

  • For destructive operations in automation, use -y/--yes. Structured output mode no longer replaces human confirmation.
  • pig pb restore and pig pitr require exactly one explicit recovery target. For automatic promotion, use --target-action=promote.
  • Removed ambiguity in several short options. For log commands, -o json selects a JSONL snapshot. It does not apply to tail/follow streaming modes.

Checksums

Download asset
FileChecksum
pig-1.5.0-1.aarch64.rpm Linuxarm64SHA-2569f83b78e…e1df
pig-1.5.0-1.x86_64.rpm Linuxamd64SHA-256b7920014…3e6e
pig-v1.5.0.darwin-amd64.tar.gz macOSamd64SHA-256ae1081df…a29d
pig-v1.5.0.darwin-arm64.tar.gz macOSarm64SHA-2566d69efcd…5dc6
pig-v1.5.0.linux-amd64.tar.gz Linuxamd64SHA-2568f914821…4a85
pig-v1.5.0.linux-arm64.tar.gz Linuxarm64SHA-256d4de9ef1…2234
pig_1.5.0-1_amd64.deb Linuxamd64SHA-25635fd32af…6245
pig_1.5.0-1_arm64.deb Linuxarm64SHA-2562be1df80…3e04

Release: https://github.com/pgsty/pig/releases/tag/v1.5.0


v1.4.2

  • 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, and pg_projection.
  • Update package metadata for 48 existing extensions, including timescaledb 2.28.0, timescaledb_toolkit 1.23.0, pg_task 2.1.29, pg_search 0.24.0, pg_clickhouse 0.3.2, pg_graphql 1.6.1, documentdb 0.112, toastinfo 1.7, wrappers 0.6.1, and pgclone 4.3.2. No extensions were removed or demoted.
  • Add PostgreSQL 19 beta install/build/config support. PG19 is accepted as an explicit installable major, while PostgreSQL 18 remains the stable default for auto-detection, catalog display, and latest-version aliases.
  • Add pg19 package aliases and PG19 category alias resolution. PG19 category aliases borrow the PostgreSQL 18 visibility template and limit beta package expansion to PGDG-origin entries.
  • pig sty conf -v 19 enables the beta repository module if the template supports it. It warns if the template is not tuned for PG19 beta or cannot enable the beta repository automatically.
  • Fixes Patroni cluster operations by passing the resolved CLUSTER_NAME to patronictl restart, reinit, switchover, and failover. pig pt list also accepts an optional cluster name.
  • Bump the default pgrx version for pig build pgrx from 0.18.0 to 0.18.1.
  • Bump release metadata to v1.4.2, refresh Go module checksums, and add focused tests for PG19 aliases/config generation plus Patroni cluster-scope behavior.

Checksums

Download asset
FileChecksum
pig-1.4.2-1.aarch64.rpm Linuxarm64SHA-256790afe4d…ef93
pig-1.4.2-1.x86_64.rpm Linuxamd64SHA-256ef918166…4bea
pig-v1.4.2.darwin-amd64.tar.gz macOSamd64SHA-2563e37ff22…6273
pig-v1.4.2.darwin-arm64.tar.gz macOSarm64SHA-2565eb7db77…eb23
pig-v1.4.2.linux-amd64.tar.gz Linuxamd64SHA-256c536c324…87eb
pig-v1.4.2.linux-arm64.tar.gz Linuxarm64SHA-2568b2d5746…86ab
pig_1.4.2-1_amd64.deb Linuxamd64SHA-256566e06f6…43c8
pig_1.4.2-1_arm64.deb Linuxarm64SHA-2568c09e741…1fc1

Release: https://github.com/pgsty/pig/releases/tag/v1.4.2


v1.4.1

  • 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

Download asset
FileChecksum
pig-1.4.1-1.aarch64.rpm Linuxarm64SHA-256cbfbb04b…6dc3
pig-1.4.1-1.x86_64.rpm Linuxamd64SHA-256c3325c7c…462b
pig-v1.4.1.darwin-amd64.tar.gz macOSamd64SHA-256c82e8a5e…5d4d
pig-v1.4.1.darwin-arm64.tar.gz macOSarm64SHA-256a62e223a…f6bd
pig-v1.4.1.linux-amd64.tar.gz Linuxamd64SHA-25665938e11…e89f
pig-v1.4.1.linux-arm64.tar.gz Linuxarm64SHA-2560fe4172d…db58
pig_1.4.1-1_amd64.deb Linuxamd64SHA-256bdcc318e…827e
pig_1.4.1-1_arm64.deb Linuxarm64SHA-2561a1acb69…112d

Release: https://github.com/pgsty/pig/releases/tag/v1.4.1


v1.4.0

  • 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 related Rust extension builds.
  • Updates authoritative source bundles for pig build get. These include Cloudberry / OrioleDB build inputs and bundled artifacts for RDKit and OneSparse packages.
  • Fix repo set flag isolation and correct schema maintenance SQL.
  • Bump patroni to 4.1.1 for el9.aarch64.

Checksums

Download asset
FileChecksum
pig-1.4.0-1.aarch64.rpm Linuxarm64SHA-256c8d2f46e…ecd0
pig-1.4.0-1.x86_64.rpm Linuxamd64SHA-256fb1fd2f4…f976
pig-v1.4.0.darwin-amd64.tar.gz macOSamd64SHA-256aa08045a…1733
pig-v1.4.0.darwin-arm64.tar.gz macOSarm64SHA-25680e50dd2…39f0
pig-v1.4.0.linux-amd64.tar.gz Linuxamd64SHA-256e425bf35…f583
pig-v1.4.0.linux-arm64.tar.gz Linuxarm64SHA-256840a2169…39b7
pig_1.4.0-1_amd64.deb Linuxamd64SHA-256401d91ba…e587
pig_1.4.0-1_arm64.deb Linuxarm64SHA-256d60515f7…bcce

Release: https://github.com/pgsty/pig/releases/tag/v1.4.0


v1.3.4

Increases total available extensions to 504.

Checksums

Download asset
FileChecksum
pig-1.3.4-1.aarch64.rpm Linuxarm64SHA-256dc78def9…05fd
pig-1.3.4-1.x86_64.rpm Linuxamd64SHA-256998fcbda…e696
pig-v1.3.4.darwin-amd64.tar.gz macOSamd64SHA-256031048c5…a1df
pig-v1.3.4.darwin-arm64.tar.gz macOSarm64SHA-256e13c9393…8fd3
pig-v1.3.4.linux-amd64.tar.gz Linuxamd64SHA-25646aa321c…5c64
pig-v1.3.4.linux-arm64.tar.gz Linuxarm64SHA-256f25c4f33…caa4
pig_1.3.4-1_amd64.deb Linuxamd64SHA-25656351604…dfbb
pig_1.3.4-1_arm64.deb Linuxarm64SHA-25681bb4828…52ba

Release: https://github.com/pgsty/pig/releases/tag/v1.3.4


v1.3.3

  • Refresh extension catalog and increase total available extensions to 481.
  • Bump Go toolchain from 1.26.0 to 1.26.2.

Extension Updates

ExtensionOldNewNotes
timescaledb2.25.22.26.2available, PG15-18
pg_background1.81.9.2DEB only, PG14-18
pg_ivm1.131.14upgraded, PG14-18
system_stats3.24.0upgraded, PG14-18
nominatim_fdw1.1.01.2upgraded, PG14-18
pg_textsearch0.5.01.0.0PG17-18
pg_clickhouse0.1.50.1.10available, PG14-18
pg_search0.22.20.22.6manual download, PG15-18
pg_store_plans1.91.10upgraded, PG14-18
pg_dispatch0.1.5new, PG14-18
pg_fsql1.1.0new, PG14-18
pg_liquid0.1.7new, PG14-18
pg_regresql2.0.0new, PG14-18
pg_slug_gen1.0.0new, PG15-18
pg_stat_ch0.3.3new, PG16-18
pg_variables1.2.5new, PG14-18
pgcalendar1.1.0new, PG14-18
pgclone2.2.0new, PG14-18
pgelog1.0.2new, PG14-18
pglock1.0.0new, PG14-18
pgproto0.2.1new, PG14-18
postgresbson2.0.2new, PG14-18
rdf_fdw2.4.0new, PG14-18
parray_gin1.4.0new, PG14-18

Checksums

Download asset
FileChecksum
pig-1.3.3-1.aarch64.rpm Linuxarm64SHA-256e7441806…2088
pig-1.3.3-1.x86_64.rpm Linuxamd64SHA-2568450e3e1…2231
pig-v1.3.3.darwin-amd64.tar.gz macOSamd64SHA-256952a0e94…c826
pig-v1.3.3.darwin-arm64.tar.gz macOSarm64SHA-256c896b4fd…bb8a
pig-v1.3.3.linux-amd64.tar.gz Linuxamd64SHA-256d18a92f9…e85e
pig-v1.3.3.linux-arm64.tar.gz Linuxarm64SHA-25662d02007…190a
pig_1.3.3-1_amd64.deb Linuxamd64SHA-2567a613a1f…d614
pig_1.3.3-1_arm64.deb Linuxarm64SHA-256f4c91ce8…43d8

Release: https://github.com/pgsty/pig/releases/tag/v1.3.3


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 aliases for pig build get.
  • Migrate extension catalog URLs from pgext.cloud to pigsty.io/ext.

Checksums

Download asset
FileChecksum
pig-1.3.2-1.aarch64.rpm Linuxarm64SHA-256d760f476…d8f3
pig-1.3.2-1.x86_64.rpm Linuxamd64SHA-256c2e02e62…ef55
pig-v1.3.2.darwin-amd64.tar.gz macOSamd64SHA-256b8d066dd…397f
pig-v1.3.2.darwin-arm64.tar.gz macOSarm64SHA-256a90e78d8…b1f9
pig-v1.3.2.linux-amd64.tar.gz Linuxamd64SHA-2562fe3a9ff…9559
pig-v1.3.2.linux-arm64.tar.gz Linuxarm64SHA-256522290aa…12c2
pig_1.3.2-1_amd64.deb Linuxamd64SHA-256d6c1cf2c…8d30
pig_1.3.2-1_arm64.deb Linuxarm64SHA-2564352385c…77aa

Release: https://github.com/pgsty/pig/releases/tag/v1.3.2


v1.3.1

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 -> 464), including pg_pinyin, pg_eviltransform, and qos.
  • Percona PPG upstream repo is bumped to 18.3.
  • Fix pig build dependency/build sync issues; rsync now uses --keep-dirlinks.
  • In YUM repos, Nginx is split out from infra into its own module index (nginx).

Checksums

Download asset
FileChecksum
pig-1.3.1-1.aarch64.rpm Linuxarm64SHA-256196e57c7…7b8f
pig-1.3.1-1.x86_64.rpm Linuxamd64SHA-256e4bdd52e…92ac
pig-v1.3.1.darwin-amd64.tar.gz macOSamd64SHA-2564f3f9479…dce5
pig-v1.3.1.darwin-arm64.tar.gz macOSarm64SHA-25605ae2f55…f20d
pig-v1.3.1.linux-amd64.tar.gz Linuxamd64SHA-25694064549…0ec4
pig-v1.3.1.linux-arm64.tar.gz Linuxarm64SHA-2568b2c204f…ab43
pig_1.3.1-1_amd64.deb Linuxamd64SHA-2561cfc23d1…8ea5
pig_1.3.1-1_arm64.deb Linuxarm64SHA-256e495678a…20cc

Release: https://github.com/pgsty/pig/releases/tag/v1.3.1


v1.3.0

This engineering update moves from v1.2.0 to v1.3.0. It contains 15 commits across 74 changed files, with +1184 / -236 LOC.

It improves the reliability of the pig build pipeline and extends catalog and alias coverage. Total extensions increase from 451 to 461.

Highlights

  • Build source download improvements (pig build get):
    • Parse multi-source Source fields (whitespace/newline/tab) and deduplicate entries.
    • Add source mappings for agensgraph / agentsgraph.
    • pgedge now downloads both postgresql-17.9.tar.gz and spock-5.0.5.tar.gz.
  • Dependency resolution and install improvements (pig build dep):
    • RPM dependencies can infer the PG major version from pgmajorversion in spec files. Missing spec/control files return explicit errors.
    • DEB dependency parsing now covers Build-Depends / Build-Depends-Arch / Build-Depends-Indep, including multiline fields, alternatives, arch qualifiers, and build-profile cleanup.
    • PGVERSION placeholders can be expanded from --pg, installed PG majors, or extension metadata.
    • Dependency install failures are downgraded to warnings so batch runs continue.
  • DEB build result semantics fixed (pig build ext/pkg):
    • A successful build command exit code determines success. Artifact discovery is best-effort and can only produce warnings.
    • Suppress empty package-list banners on successful no-artifact runs.
    • Partial artifacts are warnings, not failures.
    • Build logs now print real metadata source/version values instead of always composing name-version.
  • Better machine-readable ext operation output (pig ext rm/update):
    • After alias resolution, removed/updated now returns resolved package names instead of extension aliases.
  • Extension catalog and alias updates:
    • New aliases: agensgraph / agens, pgedge, babelfishpg.
    • openhalodb is aligned to PG14 package naming; ivorysqldb naming is aligned.
    • Fork metadata and availability matrix were refreshed in batch (including timescaledb, pgmq, orioledb, documentdb, pg_tde, and babelfishpg_* entries).
  • Engineering and release:
    • Updated the version to v1.3.0, including a v1.2.1 transition commit. Changed the copyright year to 2026. Updated the README for 461 extensions and current alias documentation.

Compatibility Notes

  • Structured removed/updated fields in pig ext rm/update now contain package names. Automation that matched extension aliases should update parsing logic.

New Extensions (451 -> 461)

ExtensionVersionNotes
aux_mysql1.5openHalo MySQL compatibility helper (PG14)
gb18030_20221.0IvorySQL charset conversion module
ivorysql_ora1.0IvorySQL Oracle compatibility extension
ora_btree_gin1.0Oracle datatype GIN indexing support
ora_btree_gist1.0Oracle datatype GiST indexing support
pg_get_functiondef1.0Function definition utility
plisql1.0PL/iSQL procedural language
snowflake2.4pgEdge Snowflake-style ID generator
spock5.0.5pgEdge multi-master logical replication extension
lolor1.2.2pgEdge logical-replication-friendly large objects

Full Commit List (v1.2.0..v1.3.0)

  • b8ecf8d bump version string to 1.2.1
  • 55df9a4 build/get: support multi-source parsing and pgedge spock tarball
  • da8e347 add agensgraph and pgedge alias
  • 86edbd7 ext: show resolved package names in rm/update results
  • ef3c905 build/dep: improve rpm/deb dependency resolution
  • 7144e09 ext/catalog: refresh fork metadata and matrix entries
  • befffbf build(deb): treat successful build command as authoritative result
  • 33fd517 build(deb): avoid empty package list banner on successful no-artifact runs
  • 3b450f2 avoid concat ext pkg name with version when download
  • 33847ab fix(ext): satisfy staticcheck S1011 in rm/update
  • b8b917d build(dep): treat dependency install failures as warnings
  • 8110c00 adjust ivorysqldb babelfishpg alias
  • fac9faf bump version to 1.3.0
  • 1f88f06 chore: update copyright year to 2026
  • c804757 v1.3.0

Checksums

Download asset
FileChecksum
pig-1.3.0-1.aarch64.rpm Linuxarm64SHA-256196f3241…6534
pig-1.3.0-1.x86_64.rpm Linuxamd64SHA-256a2dcc930…e7ec
pig-v1.3.0.darwin-amd64.tar.gz macOSamd64SHA-256c7ebda6b…0714
pig-v1.3.0.darwin-arm64.tar.gz macOSarm64SHA-256b717b485…4c1a
pig-v1.3.0.linux-amd64.tar.gz Linuxamd64SHA-25640e6570c…0148
pig-v1.3.0.linux-arm64.tar.gz Linuxarm64SHA-256d61430ee…644f
pig_1.3.0-1_amd64.deb Linuxamd64SHA-25662c9a4fa…519c
pig_1.3.0-1_arm64.deb Linuxarm64SHA-25619261ae5…308b

Release: https://github.com/pgsty/pig/releases/tag/v1.3.0


v1.2.0

  • Extension catalog and alias resolution enhancements:

    • Introduce dynamic PG category alias resolution by PG major version.
    • Adds OS-level alias overrides (ansible/bootstrap). Unknown distributions now fall back only to PGDG.
    • Add aliases such as node/infra and babelfish/cloudberry, and refresh extension metadata to reduce package resolution ambiguity.
  • Plan preview for high-risk operations:

    • Add pig install --plan with structured execution plan output.
    • Align preview semantics for pig pitr and pgBackRest repack/expire under --plan / --dry-run.
    • Add plan-flag consistency tests to keep subcommand behavior aligned.
  • Native sty configuration capability:

    • Add pig sty configure with full execution flow (preflight, argument handling, execution orchestration).
    • Unifies sty conf/configure behavior. The native implementation is the default, and --raw remains as a fallback.
    • Add tests for configure main flow, preflight, routing, and install integration to improve maintainability.
  • Repo/build/reliability fixes:

    • Fix nil dereference in repo cache on os.Stat error paths.
    • Align Ubuntu and Debian repo channel mapping, and add timeout control for mirror pulls during reload.
    • Harden repo rm for dotted module names with safe deletion and path validation.
    • Fix symlink preservation, cross-device migration, and target-directory handling in sty init and build flows.
    • Improve text output and matrix color rendering, and fix ext command validation for empty args/targets.
  • 35 commits, 66 files changed, LOC: +5006 / -379

  • PG extension and kernel package updates

PackageOldNewNotes
timescaledb2.25.02.25.1
citus14.0.0-314.0.0-4Rebuilt from the latest official upstream release
age1.7.01.7.0Add PG 17 support for version 1.7.0
pg_background-1.8DEB-only build; RPM package comes from PGDG
pgmq1.10.01.10.1This extension package is currently unavailable
pg_search0.21.60.21.8Used as direct download package
oriolepg17.1117.16OriolePG kernel update
orioledbbeta12beta14Matched with OriolePG 17.16
cloudberry-2.0.0New package
babelfishpg-5.5.0New BabelfishPG package group
babelfish-5.5.0New Babelfish compatibility package
antlr4-runtime413-4.13New runtime dependency for Babelfish

Checksums

Download asset
FileChecksum
pig-1.2.0-1.aarch64.rpm Linuxarm64SHA-256344b7738…d206
pig-1.2.0-1.x86_64.rpm Linuxamd64SHA-256aa9cf182…b757
pig-v1.2.0.darwin-amd64.tar.gz macOSamd64SHA-256f26e4d9e…b678
pig-v1.2.0.darwin-arm64.tar.gz macOSarm64SHA-2562ca41efc…19a2
pig-v1.2.0.linux-amd64.tar.gz Linuxamd64SHA-256f7aa291b…5181
pig-v1.2.0.linux-arm64.tar.gz Linuxarm64SHA-25638007ecd…53f0
pig_1.2.0-1_amd64.deb Linuxamd64SHA-256e824716d…8d7a
pig_1.2.0-1_arm64.deb Linuxarm64SHA-256b67baa40…3d2a

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


v1.1.1

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 repository modules whose names contain dots while retaining safe-path validation.
  • Accept safe relative symlinks when pig sty init extracts a Pigsty release archive.

Checksums

Download asset
FileChecksum
pig-1.1.1-1.aarch64.rpm Linuxarm64SHA-25622fe5e95…7429
pig-1.1.1-1.x86_64.rpm Linuxamd64SHA-2567f5a10bb…457a
pig-v1.1.1.darwin-amd64.tar.gz macOSamd64SHA-256b90aec9d…0e59
pig-v1.1.1.darwin-arm64.tar.gz macOSarm64SHA-2563063e3a7…f4ea
pig-v1.1.1.linux-amd64.tar.gz Linuxamd64SHA-256081ff8c8…e177
pig-v1.1.1.linux-arm64.tar.gz Linuxarm64SHA-2569a81e868…272d
pig_1.1.1-1_amd64.deb Linuxamd64SHA-25685ce861c…f541
pig_1.1.1-1_arm64.deb Linuxarm64SHA-2563a108f05…664f

Release: https://github.com/pgsty/pig/releases/tag/v1.1.1


v1.1.0

This release upgrades the CLI architecture from v1.0.0 to v1.1.0, with 79 commits across 193 changed files. It extends pig from an interactive CLI to a CLI that agents can orchestrate.

Seven new extensions are added, bringing the total available extensions to 451.

New Features

  • Adds a unified output framework for agents. Global --output supports text/yaml/json/json-pretty. A common Result structure provides stable status codes and machine-readable output for ext/repo/pg/pt/pb/pitr/status/version/context.
  • Adds ANCS (Agent Native Command Schema) metadata, including type/volatility/parallel/risk/confirm/os_user/cost fields. In structured mode, help outputs a command capability tree. Agents can use it to identify capabilities and risks.
  • Adds the pig context (pig ctx) environment snapshot command. One call collects host, PostgreSQL, Patroni, pgBackRest, and extension information for direct use in agent workflows.
  • Extends plan support beyond PITR with pig ext add/rm --plan, pig pg stop/restart --plan, and pig pt switchover/failover --plan. These match pig pitr --plan/--dry-run in a common, reviewable format. Plans show actions, scope, risks, and expected results.
  • Extends structured results with native pgbackrest info JSON. Unifies structured return DTOs across Patroni/PostgreSQL/PITR/Repo/Ext for automation compatibility.
  • Adds legacy structured wrappers for command groups such as pg_exporter/pg_probe/do/sty. These retain existing interaction behavior while providing structured execution results and captured output.
  • Update pigsty to v4.1.0.

Extension Update

ExtensionOldNew
timescaledb2.24.02.25.0
citus14.0.0-214.0.0-3
pg_incremental1.2.01.4.1
pg_bigm1.2-202406061.2-20250903
pg_net0.20.00.20.2
pgmq1.9.01.10.0
pg_textsearch0.4.00.5.0
pljs1.0.41.0.5
sslutils1.4-11.4-2
table_version1.11.01.11.1
supautils3.0.23.1.0
pg_math1.01.1.0
pgsentinel1.3.11.4.0
pg_uri1.201512241.20251029
pgcollection1.1.01.1.1
pg_readonly1.0.31.0.4
timestamp91.4.0-11.4.0-2
pg_uint1281.1.11.2.0
pg_roaringbitmap0.5.51.1.0
plprql18.0.018.0.1
pglinter1.0.11.1.0
pg_jsonschema0.3.30.3.4
pg_anon2.5.13.0.1
vchord1.0.01.1.0
pg_search0.21.40.21.6/0.21.7
pg_graphql1.5.12-11.5.12-2
pg_summarize0.0.1-20.0.1-3
nominatim_fdw-1.1.0
pg_utl_smtp-1.0.0
pg_strict-1.0.2
pg_track_optimizer-0.9.1
pgmb-1.0.0

Bug Fixes

  • Security fix: resolve parsing panic in pig build proxy when receiving malformed proxy addresses.
  • Security fix: resolve path traversal risk in pig pg log, preventing access to files outside the log directory via ../../.
  • Security hardening: improve installer/repo path and quoting handling to reduce path injection and invalid-path misuse risks.
  • Build reliability fixes: pig build get/pkg/ext now propagates errors and returns non-zero exit codes when downloads or builds fail. Fixes false DEB build failures caused by a pg_ver mismatch.
  • Repository/catalog update fixes: adds quiet mirror fallback for ext/repo reload. Commands repo add/set/rm return the correct error status when cache updates fail.
  • Extension management fixes: ext update now uses explicit targets, and status drift issues are fixed. ext import downloads requested DEB resources to the specified repository directory.
  • Output/observability fixes: aligns structured-output exit codes with text mode. Improves permission handling and parsing stability in pg status.

Checksums

Download asset
FileChecksum
pig-1.1.0-1.aarch64.rpm Linuxarm64SHA-25695245dc0…780e
pig-1.1.0-1.x86_64.rpm Linuxamd64SHA-2568b1a26f1…56f4
pig-v1.1.0.darwin-amd64.tar.gz macOSamd64SHA-256dbd07951…c456
pig-v1.1.0.darwin-arm64.tar.gz macOSarm64SHA-2563f3ba081…f251
pig-v1.1.0.linux-amd64.tar.gz Linuxamd64SHA-256ad61384b…005e
pig-v1.1.0.linux-arm64.tar.gz Linuxarm64SHA-2567713632b…1e00
pig_1.1.0-1_amd64.deb Linuxamd64SHA-25670cfc41b…b867
pig_1.1.0-1_arm64.deb Linuxarm64SHA-256fc5cf166…ad0e

Release: https://github.com/pgsty/pig/releases/tag/v1.1.0


v1.0.0

This release adds three command groups: pig pg for PostgreSQL, pig pt for Patroni, and pig pb for pgBackRest. It also adds a coordinated PITR command and improves extension availability displays.

New Commands

  • pig pg - PostgreSQL instance management

    • pg init/start/stop/restart/reload/status - Control and manage PostgreSQL instances
    • pg role/promote - Detect and switch instance role (primary/replica)
    • pg psql/ps/kill - Connection and session management
    • pg vacuum/analyze/freeze/repack - Database maintenance operations
    • pg log - Log viewing (list/tail/cat/less)
  • pig pt - Patroni cluster management

    • pt list/config - View cluster status and configuration
    • pt restart/reload/reinit - Manage cluster members
    • pt switchover/failover - Cluster failover operations
    • pt pause/resume - Control automatic failover
    • pt start/stop/status/log - Patroni service management
  • pig pb - pgBackRest backup management

    • pb info/ls - View backup information
    • pb backup/restore/expire - Backup operations
    • pb create/upgrade/delete - Stanza management
    • pb check/start/stop/log - Control operations
  • pig pitr - Orchestrated Point-In-Time Recovery

    • Automatic Patroni/PostgreSQL coordination
    • Multiple recovery targets: time, LSN, XID, restore point
    • Dry-run mode and post-recovery guidance

New Features

  • Add availability matrix to pig ext avail and pig ext ls

Improvements

  • Unified command aliases across pg/pt/pb commands
  • Standardized error message format
  • Code refactoring and cleanup

Bug Fixes

  • Fix missing UTIL extension category

Checksums

Download asset
FileChecksum
pig-1.0.0-1.aarch64.rpm Linuxarm64SHA-25630663707…a872
pig-1.0.0-1.x86_64.rpm Linuxamd64SHA-256d2b94404…414c
pig-v1.0.0.darwin-amd64.tar.gz macOSamd64SHA-256c8a169e4…4e62
pig-v1.0.0.darwin-arm64.tar.gz macOSarm64SHA-256c0996037…a2f8
pig-v1.0.0.linux-amd64.tar.gz Linuxamd64SHA-25613837c6f…79f6
pig-v1.0.0.linux-arm64.tar.gz Linuxarm64SHA-25608207dfe…c876
pig_1.0.0-1_amd64.deb Linuxamd64SHA-256a543882a…ce66
pig_1.0.0-1_arm64.deb Linuxarm64SHA-2564cd6ec54…8995

Release: https://github.com/pgsty/pig/releases/tag/v1.0.0


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 in the pgsql-full package alias.

Checksums

Download asset
FileChecksum
pig-0.9.0-1.aarch64.rpm Linuxarm64SHA-256ea0c098d…13fa
pig-0.9.0-1.x86_64.rpm Linuxamd64SHA-256707f4e1f…90cc
pig-v0.9.0.darwin-amd64.tar.gz macOSamd64SHA-25656aeb616…d93e
pig-v0.9.0.darwin-arm64.tar.gz macOSarm64SHA-256a213d168…3de4
pig-v0.9.0.linux-amd64.tar.gz Linuxamd64SHA-2566a1a1836…452f
pig-v0.9.0.linux-arm64.tar.gz Linuxarm64SHA-2565e5728aa…b8b0
pig_0.9.0-1_amd64.deb Linuxamd64SHA-256e80d2cb3…353b
pig_0.9.0-1_arm64.deb Linuxarm64SHA-256ecb504ef…0fe2

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


v0.8.1

Fix

  • Restore llvmjit to the pgsql-full package alias after it was removed in v0.8.0.

Checksums

Download asset
FileChecksum
pig-0.8.1-1.aarch64.rpm Linuxarm64SHA-256fd9291b1…258c
pig-0.8.1-1.x86_64.rpm Linuxamd64SHA-256c2ec07d1…edec
pig-v0.8.1.darwin-amd64.tar.gz macOSamd64SHA-256b07017d2…fc34
pig-v0.8.1.darwin-arm64.tar.gz macOSarm64SHA-256090889ba…0501
pig-v0.8.1.linux-amd64.tar.gz Linuxamd64SHA-25664cfd28d…9544
pig-v0.8.1.linux-arm64.tar.gz Linuxarm64SHA-2566216612a…fbe4
pig_0.8.1-1_amd64.deb Linuxamd64SHA-25629a2109a…d387
pig_0.8.1-1_arm64.deb Linuxarm64SHA-2567d872865…f882

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


v0.8.0

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 from 0.20.3 to 0.20.5
  • pg_duckdb upgraded to official release 1.1.1
  • vchord_bm25 upgraded from 0.2.2 to 0.3.0
  • pg_semver upgraded from 0.40.0 to 0.41.0
  • pg_timeseries upgraded from 0.1.7 to 0.1.8
  • Fixed debian/ubuntu pg18 extension issues: supautils, pg_summarize, pg_vectorize, pg_tiktoken, pg_tzf, pglite_fusion, pgsmcrypto, pgx_ulid, plprql
  • Pigsty version synced to 4.0.0

Repository Updates

  • Removed pgdg yum sysupdate repo due to upstream changes
  • Removed pgdg yum llvmjit package due to upstream changes
  • Fixed patroni 3.0.4 duplicate package issue on el9.aarch64
  • Added priorities for EL repository definitions. Skips the Docker repository when it is unavailable.
  • Added epel 10 / pgdg 9/10 OS minor version hotfix

Checksums

Download asset
FileChecksum
pig-0.8.0-1.aarch64.rpm Linuxarm64SHA-256e457832f…bc9e
pig-0.8.0-1.x86_64.rpm Linuxamd64SHA-256c97b1bfd…b523
pig-v0.8.0.darwin-amd64.tar.gz macOSamd64SHA-256d892f06d…254d
pig-v0.8.0.darwin-arm64.tar.gz macOSarm64SHA-256222413ba…c7ae
pig-v0.8.0.linux-amd64.tar.gz Linuxamd64SHA-256d50aa980…fedc
pig-v0.8.0.linux-arm64.tar.gz Linuxarm64SHA-256d2f410f7…dff8
pig_0.8.0-1_amd64.deb Linuxamd64SHA-2564ccd330a…6abe
pig_0.8.0-1_arm64.deb Linuxarm64SHA-2565cb9eccc…b8a0

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


v0.7.5

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
  • pg_vectorize 0.25.0 -> 0.26.0

Repository Updates

Uses the corrected Aliyun PGDG mirror repository.

Checksums

Download asset
FileChecksum
pig-0.7.5-1.aarch64.rpm Linuxarm64SHA-2569de11ac1…eca6
pig-0.7.5-1.x86_64.rpm Linuxamd64SHA-256071d6555…2b34
pig-v0.7.5.darwin-amd64.tar.gz macOSamd64SHA-256befe0a8f…1f9b
pig-v0.7.5.darwin-arm64.tar.gz macOSarm64SHA-2564766b4e9…bae2
pig-v0.7.5.linux-amd64.tar.gz Linuxamd64SHA-256dc45726c…1ade
pig-v0.7.5.linux-arm64.tar.gz Linuxarm64SHA-2561483cf96…2c13
pig_0.7.5-1_amd64.deb Linuxamd64SHA-2560152b7bd…d92e
pig_0.7.5-1_arm64.deb Linuxarm64SHA-2567d22116d…b105

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


v0.7.4

  • Update extension metadata: pg_search, pgmq, pg_stat_monitor
  • Updates the PGDG repository URL. The extras directory moves to the parent directory.
  • Bump ivorysql to 5.0 (compatible with PG 18.0)
  • Bump Percona Postgres TDE Kernel to 18.1

Checksums

Download asset
FileChecksum
pig-0.7.4-1.aarch64.rpm Linuxarm64SHA-2565769b005…ce57
pig-0.7.4-1.x86_64.rpm Linuxamd64SHA-256d15c829f…979c
pig-v0.7.4.darwin-amd64.tar.gz macOSamd64SHA-256bb4c90e2…1d47
pig-v0.7.4.darwin-arm64.tar.gz macOSarm64SHA-256faaf7ac7…f415
pig-v0.7.4.linux-amd64.tar.gz Linuxamd64SHA-256037cacdd…93df
pig-v0.7.4.linux-arm64.tar.gz Linuxarm64SHA-2562ce819b2…c867
pig_0.7.4-1_amd64.deb Linuxamd64SHA-25697f62d62…1fcd
pig_0.7.4-1_arm64.deb Linuxarm64SHA-256d2b80af8…a498

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


v0.7.3

  • Add new command: pig repo reload to update repo metadata
  • Fixes the EL PGDG sysupdate aarch64 repository. The aarch64 repository is now ready.
  • Fix EL10.aarch64 PGDG repo renaming issue
  • Update extension versions
  • Bump Pigsty version to 3.7.0

Checksums

Download asset
FileChecksum
pig-0.7.3-1.aarch64.rpm Linuxarm64SHA-25683e1b491…c742
pig-0.7.3-1.x86_64.rpm Linuxamd64SHA-25600671775…a974
pig-v0.7.3.darwin-amd64.tar.gz macOSamd64SHA-256d6ac6164…9cdb
pig-v0.7.3.darwin-arm64.tar.gz macOSarm64SHA-256c595df85…49b7
pig-v0.7.3.linux-amd64.tar.gz Linuxamd64SHA-256baa87589…5186
pig-v0.7.3.linux-arm64.tar.gz Linuxarm64SHA-256b6d75f7e…eb14
pig_0.7.3-1_amd64.deb Linuxamd64SHA-2565ddfd410…06dd
pig_0.7.3-1_arm64.deb Linuxarm64SHA-2562996c06f…e01a

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


v0.7.2

  • 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 timescaledb pg_profile pg_stat_monitor documentdb

  • New extensions: pglinter pg_typeid pg_enigma pg_retry pg_biscuit pg_weighted_statistics

Checksums

Download asset
FileChecksum
pig-0.7.2-1.aarch64.rpm Linuxarm64SHA-256080dd93c…a9af
pig-0.7.2-1.x86_64.rpm Linuxamd64SHA-256b9105623…dcf7
pig-v0.7.2.darwin-amd64.tar.gz macOSamd64SHA-2569b294e58…9cb7
pig-v0.7.2.darwin-arm64.tar.gz macOSarm64SHA-25674f32767…a1eb
pig-v0.7.2.linux-amd64.tar.gz Linuxamd64SHA-2560c9f6e6b…cda4
pig-v0.7.2.linux-arm64.tar.gz Linuxarm64SHA-256f6284221…b340
pig_0.7.2-1_amd64.deb Linuxamd64SHA-256091d12d5…75a0
pig_0.7.2-1_arm64.deb Linuxarm64SHA-25653346bd9…6ff5

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


v0.7.1

  • New PGEXT.CLOUD extension catalog.
  • Removes unnecessary sudo calls. Pig can now run inside Docker.
  • Allow using pg18, pg17 arg format in pig ext link command
  • Adds the environment variable PIG_NO_SUDO to prevent sudo use.
  • RPM Changelog: Add PG 18 support to almost all extensions
  • DEB Changelog: Add PG 18 support to almost all extensions
  • Infra Changelog: Routine update to the latest version

Checksums

Download asset
FileChecksum
pig-0.7.1-1.aarch64.rpm Linuxarm64SHA-256a696c9ec…5ca6
pig-0.7.1-1.x86_64.rpm Linuxamd64SHA-256f669538a…194d
pig-v0.7.1.darwin-amd64.tar.gz macOSamd64SHA-256e42bdaaf…b836
pig-v0.7.1.darwin-arm64.tar.gz macOSarm64SHA-256b4c240aa…a457
pig-v0.7.1.linux-amd64.tar.gz Linuxamd64SHA-256ffc687ad…82f7
pig-v0.7.1.linux-arm64.tar.gz Linuxarm64SHA-2567b0d1f15…22e1
pig_0.7.1-1_amd64.deb Linuxamd64SHA-25643e91a3b…0268
pig_0.7.1-1_arm64.deb Linuxarm64SHA-256fc2a34ae…08a2

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


v0.7.0

  • Add support for Debian 13 and EL 10 distributions
  • Updates many extensions to their 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> downloads source, prepares dependencies, and builds in one operation.
    • pig build pgrx is now separated from pig build rust
    • pig build pgrx [-v pgrx_version] can now use existing PG installation directly
    • pig build dep will now handle extension dependencies on both EL and Debian systems
    • pig build ext has more compact output. It can build RPM packages on EL without a build script.
    • pig build spec now supports downloading spec files directly from Pigsty repo
    • pig build repo / pig repo add / pig repo set now use node,pgsql,infra as default repo modules instead of node,pgdg,pigsty
  • Optimized error logging
  • Adds a catalog website based on Hugo and Hextra.

Checksums

Download asset
FileChecksum
pig_0.7.0-1_amd64.deb Linuxamd64MD5ad60f9ab…965e
pig_0.7.0-1_arm64.deb Linuxarm64MD5aa15d708…7cf9
pig-0.7.0-1.aarch64.rpm Linuxarm64MD505549fe0…f0b8
pig-0.7.0-1.x86_64.rpm Linuxamd64MD50cc9e46c…3b67
pig-v0.7.0.darwin-amd64.tar.gz macOSamd64MD5ddacfb05…1cdd
pig-v0.7.0.darwin-arm64.tar.gz macOSarm64MD517d25b56…946b
pig-v0.7.0.linux-amd64.tar.gz Linuxamd64MD5ee7e055c…f80b
pig-v0.7.0.linux-arm64.tar.gz Linuxarm64MD5284e6748…420d

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


v0.6.2

  • Use official PG 18 repo instead of testing repo
  • Add v prefix when specifying pigsty version string
  • Improved network connectivity check

Checksums

Download asset
FileChecksum
pig_0.6.2-1_amd64.deb Linuxamd64MD501f5b7dc…8347
pig_0.6.2-1_arm64.deb Linuxarm64MD5ce4f0025…41cd
pig-0.6.2-1.aarch64.rpm Linuxarm64MD5cefc36ae…a720
pig-0.6.2-1.x86_64.rpm Linuxamd64MD5d04a287c…b602
pig-v0.6.2.darwin-amd64.tar.gz macOSamd64MD5e637ca86…3d9a
pig-v0.6.2.darwin-arm64.tar.gz macOSarm64MD579749bc6…f98e
pig-v0.6.2.linux-amd64.tar.gz Linuxamd64MD5ad4f0299…1bb4
pig-v0.6.2.linux-arm64.tar.gz Linuxarm64MD59793affa…3dca

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


v0.6.1

  • Add el10 and debian 13 trixie support stub
  • Dedicated PIG documentation website.
  • 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
  • Version output includes the Go build environment.

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


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
  • Change extension summary info links to https://ext.pgsty.com
  • Fixes OrioleDB on Debian/Ubuntu.
  • Fix epel repo on EL distributions
  • Bump golang to 1.24.5
  • Bump pigsty to v3.6.0

Checksums

Download asset
FileChecksum
pig_0.6.0-1_amd64.deb Linuxamd64MD51804766d…bc3b
pig_0.6.0-1_arm64.deb Linuxarm64MD535f4efa3…adcb
pig-0.6.0-1.aarch64.rpm Linuxarm64MD5b523b54d…6b1d
pig-0.6.0-1.x86_64.rpm Linuxamd64MD59434d9dc…7f52
pig-v0.6.0.linux-amd64.tar.gz Linuxamd64MD5f635c12d…7d11
pig-v0.6.0.linux-arm64.tar.gz Linuxarm64MD5165af4e6…5732

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


v0.5.0

  • 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
  • Fixes pgvectorscale failures on Debian/Ubuntu with PG17.
  • Bump kubernetes repo to 1.33
  • Bump default pigsty version to 3.5.0

Checksums

Download asset
FileChecksum
pig_0.5.0-1_amd64.deb Linuxamd64MD59ec6f3ca…cb33
pig_0.5.0-1_arm64.deb Linuxarm64MD54fbb0a42…5d77
pig-0.5.0-1.aarch64.rpm Linuxarm64MD59cf82083…9efe
pig-0.5.0-1.x86_64.rpm Linuxamd64MD5d9a8d78c…aa8d
pig-v0.5.0.linux-amd64.tar.gz Linuxamd64MD5761df804…7674
pig-v0.5.0.linux-arm64.tar.gz Linuxarm64MD55d183006…ea39

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


v0.4.2

  • 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 (pgrx 0.12.7)
  • pg_ivm 1.11.0 for debian/ubuntu
  • orioledb 1.4.0 beta11
  • Add el7 repo back

Checksums

Download asset
FileChecksum
pig_0.4.2-1_amd64.deb Linuxamd64MD5bbf83fa3…e90a
pig_0.4.2-1_arm64.deb Linuxarm64MD5e4575333…0d72
pig-0.4.2-1.aarch64.rpm Linuxarm64MD5966d60bb…5f9f
pig-0.4.2-1.x86_64.rpm Linuxamd64MD51f31f54d…75ad
pig-v0.4.2.linux-amd64.tar.gz Linuxamd64MD51eec26c4…257a
pig-v0.4.2.linux-arm64.tar.gz Linuxarm64MD5768d4344…d4ef

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


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

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


v0.4.0

  • Updates the extension list to 407 available extensions.
  • 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 / gitlab-ee repository distinction
  • Built with the latest Go 1.24.2 and upgraded dependency versions
  • Fixed pig ext status panic issue under specific conditions
  • Fixes pig ext scan matching for several extensions.

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


v0.3.4

curl https://repo.pigsty.io/pig | bash -s 0.3.4
  • Routine extension metadata update
  • Uses the Aliyun EPEL mirror to replace the broken Tsinghua TUNA mirror.
  • Bump pigsty version string
  • Add gitlab repo to the repo list

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


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
  • Update package alias

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


v0.3.2

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


v0.3.1

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


v0.3.0

This release introduced a PIG homepage alongside the PostgreSQL extension catalog.

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


v0.2.2

404 Extensions Available in Pig v0.2.2

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


v0.2.0

New extensions

Extension updates

  • citus 13.0.0 -> 13.0.1
  • pg_mooncake 0.1.0 -> 0.1.1
  • timescaledb 2.17.2 -> 2.18.1
  • supautils 2.5.0 -> 2.6.0
  • VectorChord 0.1.0 -> 0.2.0
  • pg_bulkload 3.1.22 (+pg17)
  • pg_store_plan 1.8 (+pg17)
  • pg_search 0.14 -> 0.15.1
  • pg_analytics 0.3.0 -> 0.3.2
  • pgroonga 3.2.5 -> 4.0.0
  • zhparser 2.2 -> 2.3
  • pg_vectorize 0.20.0 -> 0.21.1

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


v0.1.4

New extensions

Extension updates

  • citus 13.0.0 -> 13.0.1
  • pg_mooncake 0.1.0 -> 0.1.1
  • timescaledb 2.17.2 -> 2.18.1
  • supautils 2.5.0 -> 2.6.0
  • VectorChord 0.1.0 -> 0.2.0
  • pg_bulkload 3.1.22 (+pg17)
  • pg_store_plan 1.8 (+pg17)
  • pg_search 0.14 -> 0.15.1
  • pg_analytics 0.3.0 -> 0.3.2
  • pgroonga 3.2.5 -> 4.0.0
  • zhparser 2.2 -> 2.3
  • pg_vectorize 0.20.0 -> 0.21.1

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


v0.1.3

Version v0.1.3 is a routine update with 390 available extensions.

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


v0.1.2

Includes 351 PostgreSQL extensions, including postgresql-anonymizer 2.0.

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


v0.1.1

Update Extension List

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


v0.1.0

pig CLI v0.1 released

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


v0.0.1

Genesis Release

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

Was this page helpful?

Table reader