Release Note
The current public stable release is Pigsty v4.6.0, released on 2026-11-13 (Beijing time).
| Version | Release Date | Summary | Release Page |
|---|---|---|---|
| v4.6.0 | 2026-11-13 | VAULT secrets management, redesigned MySQL 8.4, PG 18.7, 625 extensions, and infrastructure updates | v4.6.0 |
| v4.5.0 | 2026-08-15 | Silo, Kafka, MySQL, Valkey, 575 extensions, and safer orchestration | v4.5.0 |
| v4.4.0 | 2026-07-10 | PG 19 beta support, 531 extensions, kernel updates, pig CLI improvements | v4.4.0 |
| v4.3.0 | 2026-05-01 | 510 extensions, batch Infra / PGSQL / kernel package updates, Ubuntu 26 support | v4.3.0 |
| v4.2.2 | 2026-03-23 | Insforge template, pdu, pgdog, tigerfs, ivorysql 5.3 | v4.2.2 |
| v4.2.1 | 2026-03-06 | Maintenance release: 3 new extensions, drop PG13, bug fixes | v4.2.1 |
| v4.2.0 | 2026-02-28 | Routine minor release with six PG kernel updates | v4.2.0 |
| v4.1.0 | 2026-02-12 | Major/minor upgrade support, Agent-Native CLI, stricter default firewall policy | v4.1.0 |
| v4.0.0 | 2026-01-28 | Observability revolution, security hardening, JUICE/VIBE modules, Apache-2.0 | v4.0.0 |
| v3.7.0 | 2025-12-02 | PG18 default, 437 extensions, EL10 & Debian 13 support, PGEXT.CLOUD | v3.7.0 |
| v3.6.1 | 2025-08-15 | Routine PG minor updates, PGDG China mirror, EL10/D13 stubs | v3.6.1 |
| v3.6.0 | 2025-07-30 | pgactive, MinIO/ETCD improvements, simplified install, config cleanup | v3.6.0 |
| v3.5.0 | 2025-06-16 | PG18 beta, 421 extensions, monitoring upgrade, code refactor | v3.5.0 |
| v3.4.1 | 2025-04-05 | OpenHalo & OrioleDB, MySQL compatibility, pgAdmin improvements | v3.4.1 |
| v3.4.0 | 2025-03-30 | Backup improvements, auto certs, AGE, IvorySQL all platforms | v3.4.0 |
| v3.3.0 | 2025-02-24 | 404 extensions, extension directory, App playbook, Nginx customization | v3.3.0 |
| v3.2.2 | 2025-01-23 | 390 extensions, Omnigres, Mooncake, Citus 13 & PG17 support | v3.2.2 |
| v3.2.1 | 2025-01-12 | 350 extensions, Ivory4, Citus enhancements, Odoo template | v3.2.1 |
| v3.2.0 | 2024-12-24 | Extension CLI, Grafana enhancements, ARM64 extension completion | v3.2.0 |
| v3.1.0 | 2024-11-24 | PG17 default, config simplification, Ubuntu24 & ARM support | v3.1.0 |
| v3.0.4 | 2024-10-30 | PG17 extensions, OLAP suite, pg_duckdb | v3.0.4 |
| v3.0.3 | 2024-09-27 | PostgreSQL 17, Etcd improvements, IvorySQL 3.4, PostGIS 3.5 | v3.0.3 |
| v3.0.2 | 2024-09-07 | Mini install mode, PolarDB 15 support, monitoring view updates | v3.0.2 |
| v3.0.1 | 2024-08-31 | Routine bug fixes, Patroni 4 support, Oracle compatibility improvements | v3.0.1 |
| v3.0.0 | 2024-08-25 | 333 extensions, pluggable kernels, MSSQL/Oracle/PolarDB compatibility | v3.0.0 |
| v2.7.0 | 2024-05-20 | Extension explosion, 20+ new powerful extensions, Docker apps | v2.7.0 |
| v2.6.0 | 2024-02-28 | PG16 as default, ParadeDB & DuckDB extensions introduced | v2.6.0 |
| v2.5.1 | 2023-12-01 | Routine minor update, PG16 key extension support | v2.5.1 |
| v2.5.0 | 2023-09-24 | Ubuntu/Debian support: bullseye, bookworm, jammy, focal | v2.5.0 |
| v2.4.1 | 2023-09-24 | Supabase/PostgresML support with graphql, jwt, pg_net, vault | v2.4.1 |
| v2.4.0 | 2023-09-14 | PG16, RDS monitoring, new extensions: FTS/graph/HTTP/embedding | v2.4.0 |
| v2.3.1 | 2023-09-01 | PGVector with HNSW, PG16 RC1, doc refresh, Chinese docs, bug fixes | v2.3.1 |
| v2.3.0 | 2023-08-20 | Node VIP, FerretDB, NocoDB, MySQL stub, CVE fixes | v2.3.0 |
| v2.2.0 | 2023-08-04 | Dashboard & provisioning overhaul, UOS compatibility | v2.2.0 |
| v2.1.0 | 2023-06-10 | PostgreSQL 12-16beta support | v2.1.0 |
| v2.0.2 | 2023-03-31 | Added pgvector support, fixed MinIO CVE | v2.0.2 |
| v2.0.1 | 2023-03-21 | v2 bug fixes, security enhancements, Grafana upgrade | v2.0.1 |
| v2.0.0 | 2023-02-28 | Major architecture upgrade, compatibility/security/maintainability | v2.0.0 |
| v1.5.1 | 2022-06-18 | Grafana security hotfix | v1.5.1 |
| v1.5.0 | 2022-05-31 | Docker application support | v1.5.0 |
| v1.4.1 | 2022-04-20 | Bug fixes & full English documentation translation | v1.4.1 |
| v1.4.0 | 2022-03-31 | MatrixDB support, separated INFRA/NODES/PGSQL/REDIS modules | v1.4.0 |
| v1.3.0 | 2021-11-30 | PGCAT overhaul & PGSQL enhancement & Redis beta support | v1.3.0 |
| v1.2.0 | 2021-11-03 | Default PGSQL version upgraded to 14 | v1.2.0 |
| v1.1.0 | 2021-10-12 | Homepage, JupyterLab, PGWEB, Pev2 & pgbadger | v1.1.0 |
| v1.0.0 | 2021-07-26 | v1 GA, Monitoring System Overhaul | v1.0.0 |
| v0.9.0 | 2021-04-04 | Pigsty GUI, CLI, Logging Integration | v0.9.0 |
| v0.8.0 | 2021-03-28 | Service Provision | v0.8.0 |
| v0.7.0 | 2021-03-01 | Monitor only deployment | v0.7.0 |
| v0.6.0 | 2021-02-19 | Architecture Enhancement | v0.6.0 |
| v0.5.0 | 2021-01-07 | Database Customize Template | v0.5.0 |
| v0.4.0 | 2020-12-14 | PostgreSQL 13 Support, Official Documentation | v0.4.0 |
| v0.3.0 | 2020-10-22 | Provisioning Solution GA | v0.3.0 |
| v0.2.0 | 2020-07-10 | PGSQL Monitoring v6 GA | v0.2.0 |
| v0.1.0 | 2020-06-20 | Validation on Testing Environment | v0.1.0 |
| v0.0.5 | 2020-08-19 | Offline Installation Mode | v0.0.5 |
| v0.0.4 | 2020-07-27 | Refactor playbooks into Ansible roles | v0.0.4 |
| v0.0.3 | 2020-06-22 | Interface enhancement | v0.0.3 |
| v0.0.2 | 2020-04-30 | First Commit | v0.0.2 |
| v0.0.1 | 2019-05-15 | POC | v0.0.1 |
v4.6.0
Chinese · English · Packages · Offline
English
Pigsty v4.6.0, released on 2026-11-13, adds a secrets-management module, rebuilds MySQL 8.4 orchestration, updates the default PostgreSQL baseline to 18.7, and expands the packaged extension catalog to 625 entries. The tagged source comparison contains 139 commits and 441 changed files since v4.5.0; the attached source archive also includes the offline dependency fixes described below.
Highlights
- VAULT secrets management: the new OpenBao 2.7.2 module provides Raft HA, static-seal auto-unseal, TLS 1.3, a VIP/HAProxy endpoint, daily snapshots, monitoring and removal safeguards.
- MySQL 8.4 overhaul: a 16-parameter public interface, a consistent
/data/mysqllayout, recovery from a complete cluster outage, InnoDB Clone rebuilding, 70 recording rules and 8 alerts. - PostgreSQL and kernel variants: PostgreSQL 18.7, IvorySQL 5.6, Babelfish 6.2.0 / 5.7.0, Percona PostgreSQL TDE 18.6.1, OrioleDB 1.10.3, AgensGraph 2.18.6.1, pgEdge revision 3PGSTY with Spock 5.0.13, PolarDB 17.11.1.0, Cloudberry 2.2.0, and DocumentDB 1.0.
- 625 packaged extensions: 52 additions and 2 removals, a net gain of 50 over v4.5.0; 457 non-contrib package families. Many Rust extensions move to pgrx 0.19.3. These are catalog counts, not the number installed by a template or included in one platform archive.
- Observability and tooling: PIG 1.11.0, PG Exporter 1.6.1, SOW 0.7.1, and Silo 20261112 with Console 2.7.2; 68 dashboards, 775 static recording rules (790 including dynamic templates), and 79 alerts.
- Templates and automation: ten kernel templates move under
conf/fork/; OpenHalo’s formerconf/mysql.ymlbecomesconf/fork/halo.yml. The template library grows to 53, includingapp/siloandapp/discourse. OpenTofu becomes the default IaC CLI, while Docker and Nginx get independent repository modules. - Validated offline installation: 14 complete archives, each below 2 GiB, cover seven distributions on x86_64 and ARM64. Every platform passed a fresh, isolated
bootstrap → configure -c rich → deployinstallation.
Modules and orchestration
- VAULT (Beta) deploys OpenBao on the
vaultgroup. One member provides a lab instance; three members form a production Raft cluster without ETCD or an external database. Its eight public parameters comprise five deployment and three removal settings, withvault_safeguard: true. Static-seal material is kept underfiles/pki/vault/on the admin node. Defaults enablesecret/(KV v2),transit/andapprole; Pigsty CA certificates secure TLS 1.3, and VIP/HAProxy exposeshttps://vault.pigsty:8200. The dailyvault-backupjob usesflock, retains seven snapshots, and retrieves snapshots to the admin node after initialization and before whole-cluster removal. The module adds 14 recording rules, six alerts and a Vault Overview dashboard. - MYSQL reduces its public interface to 13 deployment and three guarded removal parameters. Preflight rejects obsolete variables such as
mysql_backup_repo;configure -grandomizes the root, monitor and cluster passwords. Data lives under/data/mysql, with three retained physical backups under/data/backups/mysql. Memory settings account for host size and PostgreSQL co-location;server_idderives from the node IPv4 address. Reconciliation supportsdba.rebootClusterFromCompleteOutage(), InnoDB Clone andcluster.rescan().mysql_safeguarddefaults totrue, and the rules adapt to mysqld-exporter 0.21.0, including a stale-backup alert. - KAFKA adds
kafka_jmx_exporter_enabled(defaulttrue) to control the embedded JMX agent and its scrape target independently of the protocol exporter. Removal retires dynamic KRaft controller voters before stopping services, then cleans exporter units and targets. Kafka updates to 4.4.0. - JUICE and VIBE tighten service readiness and package installation. JuiceFS checks both the systemd result and the actual mount with
findmnt. VIBE installs nativeclaude-code2.1.322 andcodex0.167.2 packages from the INFRA repository, isolates JupyterLab in/data/jupyter/.venvwithuv, and updates Node.js to 26.13.1 LTS. The legacyclaudepackage remains separately available.
PostgreSQL and extensions
- Kernel templates use
./configure -c fork/<name>. Version overrides exclude the fixed-majorfork/mssqlandfork/polartemplates, and kernel-specific pgBackRest compatibility handling is completed. - The new
pg_pitrparameter renders declarative recovery settings into/pg/bin/pg-pitr. PostgreSQL TLS certificates include the configured VIP in their SANs. Thecritprofile starts a single primary withsynchronous_commit: local, then enables synchronous quorum settings after bootstrap. HAProxy health checks normalizepg_rtoto a valid duration. - PIG 1.11.0 embeds 625 available catalog records. The new entries cover search, time types, vector search, graph workloads, auditing and administration;
documentdb_distributedandpgcontext_pgvectorare removed. Key versions include TimescaleDB 2.31.0, PostGIS 3.7.0, pgvector 0.8.7, Citus 14.3.0, pg_search 0.26.6, pg_lake 3.6.0, pg_fts 1.16.0, pg_duckdb 1.2.0, duckdb_fdw 2.0.2, pg_mooncake 0.3.0, VectorChord 1.3.0, vchord_bm25 1.1.0, pg_tokenizer 1.1.0, and PGroonga 4.1.0. The shared package tables retain RPM/DEB differences and distinguish optional repository packages from the PG18 offline snapshot.
Infrastructure, applications and release engineering
- Docker and Nginx upstream repositories are separate
dockerandnginxmodules, with Docker CE 29.9.2 and Nginx 1.31.8. INFRA adds production portal templates and cache-directory settings. Certbot’s deploy hook refreshes certificate symlinks before validating and reloading Nginx. Rendered remote PostgreSQL exporter credentials use ownerprometheusand mode0600. - Docker application
.envrendering escapes literal$as$$and retains mode0600. New Silo and digest-pinned Discourse templates join updates to Supabase 0.8.2, Dify 1.17.1, InsForge 2.3.3, JumpServer 5.0.0, and Registry 3.1.2. - IaC scripts default to
tofu, withIAC_CLI=terraformavailable as an override. Cloud and VM image baselines are refreshed. The offline archive defaults to/var/tmp/pkg.tgz, with/tmp/pkg.tgzas a fallback; failed extraction or a missingrepo_completemarker aborts bootstrap and removes partial output. Docker builds usemake source, Debian 13.7, andpig=1.11.0-*. - Offline repositories resolve the complete explicit package set in one APT/DNF transaction against an empty installed state. APT recommendations/suggestions and DNF weak dependencies are disabled.
hdfs_fdwand OneSparse are hidden from default package groups, so their Java and GraphBLAS/LAGraph dependency chains are absent. The verified archives also avoid unintended PG14 and duplicate PostGIS branches. Required dependencies remain; this is not a claim that every optional repository package is installed or that the solver produces a mathematically minimal set.
Package updates
Release package baseline
The core versions below come from the actual PG18 release archives. Exact package revisions, architectures and hashes are recorded in PACKAGE-MANIFEST.json.
| Component | Release baseline |
|---|---|
| PostgreSQL | 18.7 |
| Patroni | 4.1.5 |
| PgBouncer | 1.26.1 |
| pgBackRest | 2.60.0 |
| PostGIS | 3.7.0 |
| pgvector | 0.8.7 |
| TimescaleDB | 2.31.0 |
| PIG / PG Exporter / SOW | 1.11.0 / 1.6.1 / 0.7.1 |
| Grafana | 13.3.1 |
| VictoriaMetrics / Logs / Traces | 1.156.0 / 1.53.0 / 0.13.0 |
| ETCD / HAProxy | 3.7.3 / 3.4.7 |
| Silo / Console | 20261112 / 2.7.2 |
PGSQL package updates
This table consolidates the RPM/DEB changes since v4.5.0, checked against the PG18 release archives. Previous versions are the earliest recorded baselines in this cycle. Current versions are the final repository records or explicitly marked PG18 snapshots. Optional kernels, extensions and libraries are included in the changelog; they are not all installed by default or bundled on every platform. Other PostgreSQL majors follow their own repository branches.
| Package | Previous | Current | Notes |
|---|---|---|---|
postgresql-18 | 18.6 | 18.7 | Default production baseline: PostgreSQL 18.7; other supported majors follow their own maintenance branches. |
acdat | 0.1.1 | 0.1.1 | PG14-18; First full production packaging of an existing extension; 80 main packages |
address_standardizer | - | RPM: 3.7.0-1PGSTY / DEB: 3.7.0 | EL8 gap fill; standalone; SQL 3.7; includes data_us; no PostGIS dependency |
addressing_dictionary | - | 1.1 | PG14-18; SQL-only |
age | 1.7.0 | RPM: 1.8.0 / DEB: 1.8.0~rc0 | PG18 snapshot: RPM 1.8.0 and PGDG DEB 1.8.0~rc0; older PG majors retain their release branches. |
agensgraph-18 | - | 2.18.6.1 | PG18.6 kernel and contrib |
arrow | 22.0.0 | RPM: 25.0.1 / DEB: 24.0.0 / 25.0.1 | Runtime, compute and development libraries; versions vary by distribution and ABI. |
babelfish-17 | 5.4.0 | 5.7.0 | PG17.11; includes all four companion extensions |
babelfish-18 | 6.0.0 | 6.2.0 | PG18.6; includes all four companion extensions |
biscuit | 3.0.0 | 3.1.0 | PG16-18 PG16-18 |
cat_tools | 0.3.0 | 0.4.0 | SQL-only |
citus | 14.2.0 | 14.3.0 | PG16-18; includes citus_columnar |
cloudberry | 2.1.0 | 2.2.0 | Kernel and contrib |
cloudberry-backup | 2.1.0 | 2.2.0 | Six backup/restore tools |
cloudberry-pxf | 2.1.0 | 2.2.0 | For Cloudberry 2.2.0; includes pxf/pxf_fdw |
codesystem | - | RPM only: 0.2.1 | PG14-18; SQL version 0.2.0 |
colnames | - | 1.7.1 | PG14-18;SQL 1.7.0 PG14-18; SQL 1.7.0 |
credcheck | RPM only: 4.7 | 6.0 | PGDG packages in the PG18 snapshot; Pigsty fills EL8 gaps. |
ddlx | 0.30 | 0.31 | PG14-18; SQL-only |
documentdb | 0.114 | RPM: 1.0-2PGSTY / DEB: 1.0 | PG15-18;PostGIS 3.7 PG15-18; PostGIS 3.7 |
duckdb_fdw | 1.4.3 | 2.0.2 | PG15-18; DuckDB 2.0.0; conflicts with pg_duckdb |
edtf_postgres | - | 1.3.2 | PG18 release snapshot; extended date/time types. |
emaj | 5.0.0 | 5.0.1 | PG14-18; fixes emaj_adm privilege escalation and parallel rollback |
encsearch | - | RPM only: 0.1.1 | PG17; encrypted search |
graphblas | 10.5.0 | 10.5.2 | Runtime and development libraries, ABI 10; excluded from default groups and these offline archives. |
groonga | RPM: 15.1.8 / DEB: 15.1.7 / 15.1.9 / 16.0.0 | RPM: 16.1.5 / DEB: 16.0.5 / 16.1.3 | RPM 16.1.5; DEB runtime versions differ by distribution. |
groonga-tokenizer-mecab | RPM: 15.1.8 / DEB: 15.1.7 / 15.1.9 / 16.0.0 | RPM: 16.1.5 / DEB: 16.0.5 / 16.1.3 | MeCab tokenizer; versions follow the matching Groonga packages. |
haproxy | 3.4.4 | 3.4.7 | RPM includes the haproxy-doc subpackage |
hdr_histogram | - | 1.0.0 | PG14-18; SQL version 1.0 |
hypopg | 1.4.4 | 1.4.5 | PGDG packages |
is_jsonb_valid | - | 0.1.4 | PG14-18 PG14-18 |
istore | - | 0.1.12 | PG14-18 PG14-18 |
ivorysql-18 | 5.4 | 5.6 | PG18.6 kernel |
ivorysql-contrib | 5.4 | 5.6 | PG18 (IvorySQL); includes 38 extensions |
jev | - | 0.2.1 | PG14-17 PG14-17 |
jsonschema | 0.1.9 | 0.1.11 | PG14-18;pgrx 0.19.3 PG14-18; pgrx 0.19.3 |
kafgres | - | 0.3.2 | PG16 PG16 |
lagraph | 1.2.2 | 1.2.2 | Rebuilt against GraphBLAS 10.5.2; excluded from these offline archives. |
lead | - | 1.0.6 | PG17-18; extension tin; development snapshot |
libx509pq | - | 1.3 | PG14-18 PG14-18 |
log_fdw | 1.4 | 1.5 | PG14-18 PG14-18 |
login_hook | 1.8 | 1.9 | PG14-17 PGDG;PG18 Pigsty PG14-17 PGDG; PG18 Pigsty |
lolor | 1.2.2 | 1.2.3 | Updated with pgEdge 15-18 |
macavity | - | 0.2.0 | PG16-18; Fault injection; testing only |
mobilitydb | 1.3.0 | RPM: 1.3.1-2PGSTY / DEB: 1.3.1 | PG14-18;PostGIS 3.7 PG14-18; PostGIS 3.7 |
nominatim_fdw | 2.1.0 | 2.3 | PG14-18; PGDG is the principal RPM provider; same-version Pigsty supplements remain |
oai_fdw | - | 1.16.0 | PG14-18;OAI-PMH FDW;SQL 1.16 PG14-18; OAI-PMH FDW; SQL 1.16 |
onesparse | 1.0.0-1PGSTY | 1.0.0-2PGSTY | PG18; rebuilt with GraphBLAS/LAGraph; preload required; hidden from default groups. |
opencc | - | 0.1.0 | PG14–18; conversion between simplified and traditional Chinese. |
orioledb-16 | 1.8-beta16 | 1.10.3 | PG16.15 kernel; SQL 1.10 |
orioledb-17 | 1.8-beta16 | 1.10.3 | PG17.11 kernel; SQL 1.10 |
orioledb-18 | 1.8-beta16 | 1.10.3 | PG18.6 kernel; SQL 1.10 |
passwordcheck_cracklib | 3.2.0 | 3.2.1 | PG14-18 PG14-18 |
passwordpolicy | 2.0.5 | 2.0.6 | PGDG packages |
pg_adhoc | RPM only: 17.4 | RPM only: 19.0 | Includes pg_filedump |
pg_agent_gate | - | 0.4.1 | PG18; fixes agent-role escape; preload required |
pg_anon | 3.2.2 | 3.3.2 | PG14-18; pgrx 0.19.3; security update; drop/recreate required |
pg_background | 2.0.3 | 2.0.4-2PGSTY | PG14-18; remove downstream upgrade patch; built, import pending |
pg_circuit | - | 0.1.0 | PG16-18; preload |
pg_clickhouse | 0.10.0 | 0.11.1 | PG14-18;SQL 0.11 PG14-18; SQL 0.11 |
pg_curl | 2.4.5 | 2.5.0 | PG14-18;SQL 2.5 PG14-18; SQL 2.5 |
pg_currency | 0.0.4 | 0.0.6 | PG14-18; extension currency |
pg_duckdb | 1.1.1 | 1.2.0 | DuckDB 2.0.0; conflicts with duckdb_fdw |
pg_durable | 0.2.3 | 0.2.9 | PG14-18; preload required; imported locally |
pg_eviltransform | 0.0.5 | 0.0.7 | PG14-18 PG14-18 |
pg_fts | 0.2.0 | 1.16.0 | PG17-18; fixes top-k and delete performance |
pg_grammar_guard | - | 0.4.9 | PG14-18;Apache-2.0 PG14-18; Apache-2.0; built, import pending |
pg_graphql | 1.6.2 | 1.6.3 | Fixes quoted primary keys in nodeId |
pg_h3 | 4.2.3 | 4.5.0 | PG14-18; Includes h3_postgis; adds 50 DEBs; follow upstream migration guidance |
pg_hint_plan | 1.8.0/1.7.1/1.6.2/1.5.3/1.4.4 | 1.8.1/1.7.2/1.6.3/1.5.4/1.4.5 | PGDG PG18/17/16/15/14 release lines |
pg_icu_parser | - | 1.0.0 | PG14-18; EL8/9/10 x86_64/aarch64; PG18 compatibility fix; imported locally |
pg_improv | - | 0.14.0 | PG15-18;pgrx 0.19.3 PG15-18; pgrx 0.19.3 |
pg_incremental | 1.5.0 | RPM: 1.5.0 / DEB: 1.6.1 | DEB upgraded to 1.6.1; PG18 RPM remains at 1.5.0. |
pg_integrity_checksums | - | 2.2.0 | PG14-18;SQL 2.2 PG14-18; SQL 2.2 |
pg_ivm | 1.15 | 1.17 | PG14-18 PG14-18 |
pg_json_diff | - | 1.0 | PG14-18 PG14-18 |
pg_kv | - | 0.1.0 | PG15-18; non-persistent shared-memory KV |
pg_lake | 3.4.0 | 3.6.0 | PG16–18; eight extensions, SQL 3.6; EL9/10 and Debian/Ubuntu packages. |
pg_lease | - | RPM only: 0.1.0 | PG14-18; SQL-only |
pg_lexo | - | 0.6.1 | PG16-18; SQL 0.6.0; fix rank generation and ordering |
pg_lion | - | 0.3.0 | PG16-18; includes citext/vector companions |
pg_living_assertions | - | 0.5.10 | SQL-only rebuild |
pg_local_cache | 1.3.0 | 3.1.0 | PG14-18; OpenSSL dependency; built, import pending |
pg_mentat | 1.6.0 | 1.20.0 | PG14-18 PG14-18 |
pg_money | - | 0.3.0 | PG14-18 PG14-18 |
pg_mooncake | 0.2.0 | 0.3.0-1PGSTY | PGSTY fork; pg_duckdb 1.2.0 / DuckDB 2.0.0; no 0.2.0 upgrade script |
pg_nanotime | - | 0.3.0 | PG18 release snapshot; nanosecond timestamps. |
pg_parquet | 0.5.1-3PIGSTY | 0.5.1-4PGSTY | Fixes streaming COPY temporary-file leaks |
pg_pinyin | 0.0.6 | 0.0.8 | PG14-18 PG14-18 |
pg_profile | 4.11 | 4.16 | PG14–18; missing RPM coverage restored; SQL-only. |
pg_regresql | 2.0.0 | 2.1.0 | PG14-18; SQL version 2.0 |
pg_relusage | 0.0.1 | 1.0.2 | PG14-18; loading required |
pg_rusage | - | 1.0 | PG14-18 PG14-18 |
pg_search | 0.25.2 | 0.26.6 | PG15-18; preload; known MPP JoinScan crash risk |
pg_semver | 0.41.0 | 0.42.0 | PG14-18 PG14-18; imported locally |
pg_stat_ch | 0.3.6 | 0.4.0 | PG16–18; both RPM and DEB use 0.4.0 in the PG18 snapshot. |
pg_stat_kcache | 2.3.1 | 2.3.2 | PGDG packages |
pg_stat_monitor | 2.3.2 | 2.4.0 | PG14-18; preload |
pg_stat_tcpinfo | - | 1.1 | PG14-18; PGDG primary, Pigsty supplement |
pg_statecharts | - | 0.1.0 | PG16-18; includes pg_statecharts_dev |
pg_statkit | - | 1.1.0 | PG14-17 PG14-17 |
pg_statvfs | - | 1.0 | PG14-18 PG14-18 |
pg_statviz | RPM: 0.9 / 1.2 / DEB: 1.2.1 | 1.2.1 | PG14-18; Production RPMs switch from older PGDG builds to Pigsty 1.2.1; SQL version 1.2; fills 30 RPM coordinates |
pg_synonym | - | 1.0.0 | PG15-18; SQL version 1.0 |
pg_table_range | - | RPM only: 0.1.2 | PG16-18; range pruning |
pg_task | 2.1.29 | 3.0.0 | PG14-18; preload |
pg_textsearch | 1.4.0 | 1.5.1 | PG17-18; RPMs from PGDG; DEBs from Pigsty |
pg_tle | 1.5.2 | RPM: 1.5.2 / DEB: 1.5.3 | The PG18 snapshot retains different RPM and DEB versions. |
pg_tokenizer | 0.1.1 | 1.1.0 | PG14-18; native tsvector |
pg_tre | - | 4.6.2 | PG17-18 PG17-18 |
pg_trickle | 0.81.0 | 0.108.3 | PG18;pgrx 0.19.3 PG18; pgrx 0.19.3; built, import pending |
pg_try_cast | - | 1.0.0 | PG16-18; SQL version 1.0 |
pg_turbovec | 2.2.2 | 2.15.0 | PG14-18 PG14-18 |
pg_utl_smtp | DEB only: 1.0.0 | DEB only: 2.0.0 | PGDG covers EL8/9/10 |
pg_vault_tde | 1.7.0 | 1.7.2 | PG17-18;EL9/10 PG17-18; EL9/10 |
pg_vectorsearch | - | 0.1.0 | PG18;Alpha PG18; alpha; imported locally |
pg_warren | - | 0.8.0 | PG15-18 |
pgaudit | RPM only: 1.6.3 / 1.7.1 | RPM only: 1.6.3-1PGSTY / 1.7.1-1PGSTY | Pigsty unifies PG14/15 package names; PG16–18 use PGDG packages, with 18.0 for PG18. |
pgbson | 2.1.0 | 2.2.0 | PG14-18; RPM package postgresbson |
pgdog | 0.1.57 | 0.1.63 | PostgreSQL connection pooler |
pgedge-15 | 15.19-1PGSTY | 15.19-3PGSTY | Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
pgedge-16 | 16.15-1PGSTY | 16.15-3PGSTY | Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
pgedge-17 | 17.11-1PGSTY | 17.11-3PGSTY | Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
pgedge-18 | 18.6-1PGSTY | 18.6-3PGSTY | Includes Spock 5.0.13 and LOLOR 1.2.3; imported locally |
pgexporter_ext | - | 0.2.5 | New DEB coverage; RPM continues to use PGDG. |
pgextwlist | 1.19 | 1.20 | PG14-18; RPM recipe updated; production packages from PGDG |
pggraph | 1.2.0 | 1.2.1 | PG14-18; Extension graph; fix DEB SQL payload checks |
pghydro | RPM only: 6.6-1PIGSTY | RPM only: 6.6-2PGSTY | PG14-18;PostGIS 3.7;noarch PG14-18; PostGIS 3.7; noarch |
pgmb | RPM only: 1.0.0-1PIGSTY | RPM only: 1.0.0-2PGSTY | PG14-18; fix schema creation and pgsql_http dependency |
pgmnemo | 0.20.0 | 0.21.0 | PG17-18; preserves corpus tables and sequences in pg_dump |
pgmq | 1.12.0 | 1.13.1 | PG14-18; SQL-only |
pgmqtt | 0.5.0 | 0.5.1 | PG14-18; Preload required; CDC requires logical WAL |
pgrdf | 0.6.20 | 0.6.40 | PG14-18;pgrx 0.19.3 PG14-18; pgrx 0.19.3; built, import pending |
pgroonga | 4.0.8 | RPM: 4.1.0-4PGSTY.el9 / DEB: 4.1.0 | PG14-18; EL9 release; EL8/10 rebuilt at 2PGSTY; Groonga 16.1.5 |
pgrouting | 4.0.1 | 4.0.2 | PGDG packages |
pgs3 | 0.1.1 | 0.1.1 | PG17-18; First full production packaging of an existing extension; 32 main packages; alpha |
pgsentinel | 1.5.0 | 1.5.2 | PGDG packages |
pgsodium | 3.1.9 | RPM: 3.1.9 / DEB: 3.1.11 | DEB upgraded with matching libsodium; PG18 RPM remains at 3.1.9. |
pgsql_tweaks | 1.0.5 | 1.1.0 | PG14-18; SQL-only |
pgtde-18 | 18.4 | 18.6 | Percona 18.6.1;pg_tde 2.2.2 Percona 18.6.1; pg_tde 2.2.2 |
pgtde-18-contrib | 18.4 | 18.6 | pg_stat_monitor 2.4.0;vector 0.8.6 pg_stat_monitor 2.4.0; vector 0.8.6 |
pgtelemetry | - | 1.7 | PG14-18; SQL-only; requires pg_stat_statements |
pgvector | 0.8.6 | 0.8.7 | Both RPM and DEB use PGDG 0.8.7 in the PG18 offline snapshot. |
pgvectorscale | 0.9.1 | 0.9.1 | PG14-18; Extension vectorscale; same-version rebuild and correction of stale catalog label |
plpgsql_check | 2.10.4 | 2.10.16 | PG18 release snapshot; SQL version 2.10. |
plphp | - | 2.6 | PG14-18; fix embedded runtime dependencies |
plprql | 18.0.1 | 18.0.2 | PG14-18 PG14-18 |
plv8 | 3.2.4 | 3.2.5 | PG14-18; Fix EL10 LTO builds |
polardb-17 | 17.10.1.0 | 17.11.1.0-2PGSTY | PG17.11 kernel/contrib; rebuilt with updated PolarStore SDK |
polarstore | 1.2.42-2PGSTY | 1.2.42-3PGSTY | Rebuilt with zlog 1.2.20 |
postgis | RPM: 3.6.4 / DEB: 3.7.0 | RPM: 3.7.0-1PGSTY / DEB: 3.7.0 | PostGIS 3.7; Pigsty fills EL8 gaps; EL9/10 use PGDG. The PG18 archives contain one PostGIS branch. |
postgis_tiger_geocoder | - | RPM: 2025.2-1PGSTY / DEB: 2025.2 | EL8 PG16-18 gap fill; standalone noarch package |
provsql | 1.12.0 | 1.13.1 | Fixes circuit sizes/cancellation; preload required |
psql_bm25s | 0.4.13 | 0.4.14 | PG17-18 PG17-18 |
q3c | RPM only: 2.0.5 | RPM only: 2.0.6 | PGDG packages |
rdf_fdw | 2.7.0 | 3.1.0 | PG18 release snapshot; RDF foreign data access. |
rdkit | RPM: 202303.3 / 202503.6 / DEB: 202503.6 | 202609.2 | EL9/10; D13/U24/U26; older OS packages retained |
redis | 7.2.16 | 7.2.17-1PGSTY | Includes devel package |
repmgr | RPM only: 5.5.0 | RPM only: 5.5.1 | PGDG packages |
session_variable | 3.5 | 3.6 | PG14-18 PG14-18 |
set_user | 4.2.0 | 4.3.0 | PGDG packages |
snowflake | 2.6.0 | 2.6.0 | PG15-18; Rebuilt with pgEdge; correct stale 2.5.0 catalog label |
spock | 5.0.11 | 5.0.13 | Updated with pgEdge 15-18; preload required |
stannum | - | 0.1.0 | PG17-18; development snapshot |
supautils | 3.4.3 | 4.0.0 | PG18 release snapshot. |
textsearch_intl | - | 1.0.1 | Both RPM and DEB use 1.0.1 in the PG18 snapshot; SQL version 1.0. |
timescaledb | 2.29.1 | 2.31.0 | PG16-18;TSL PG16-18; TSL |
timescaledb_toolkit | 1.26.0 | 1.27.0 | PG15-18; older PG14 packages retained |
ulak | 0.0.2 | 0.2.0 | PG14-18; preload |
valkey | 9.1.1 | 9.1.3-1PGSTY | Security update; includes devel package |
vchord | 1.1.1 | 1.3.0-1PGSTY | PG14-18 PG14-18 |
vchord_bm25 | 0.3.0 | 1.1.0 | PG14-18; native tsvector |
vectorize | 0.26.2 | 0.27.1 | PG14-18; SQL 0.23.0; multi-row fix |
vgram | - | 1.0 | PG14-18 PG14-18 |
wal2json | 2.6 | 2.7 | PGDG packages |
wrappers | 0.6.2 | 0.6.4 | PG18 release snapshot. |
zlog | 1.2.18 | 1.2.20 | Rebuilds PolarStore and PolarDB |
INFRA, PIG and upstream updates
This table consolidates the INFRA and PIG changes since v4.5.0. UPSTREAM rows belong to the separate Docker/Nginx repository modules. Toolchains, applications and optional services remain opt-in.
| Repo | Package | Versions | Notes |
|---|---|---|---|
| INFRA | agentsview | 0.40.1 → 0.47.0 | Repacked for both architectures |
| INFRA | alertmanager | 0.33.1 → 0.35.0 | Repacked for both architectures |
| INFRA | barn | — → 1.2.0 | Official native packages |
| INFRA | blackbox-exporter | 0.28.0 → 0.29.1 | |
| INFRA | caddy | 2.11.4 → 2.11.9 | FastCGI security fixes |
| INFRA | cargo-pgrx-0192 / cargo-pgrx-0193 | Added 0.19.2 / 0.19.3 | Separate version slots; built from source for both EL8 architectures. |
| INFRA | claude / claude-code | 2.1.227 → 2.1.322 | Switch to the official signed claude-code package; the old claude package remains at 2.1.319. |
| INFRA | cloudflared | 2026.7.3 → 2026.10.7 | Repacked upstream executable. |
| INFRA | code | 1.133.0 → 1.146.0 | Official DEB/RPM packages; repository RPM copies are signed. |
| INFRA | code-server | 4.132.0 → 4.145.2 | Upstream native packages |
| INFRA | codex | 0.147.0 → 0.167.2 | Complete canonical runtime preserved, including bundled bwrap |
| INFRA | crush | 0.88.1 → 0.100.0 | Repacked official tarball with licenses preserved. |
| INFRA | dblab | 0.47.4 → 0.55.2 | Repacked for both architectures |
| INFRA | duckdb | 1.5.5 → 2.0.0 | Major version update. |
| INFRA | etcd | 3.7.1 → 3.7.3 | |
| INFRA | garage | 2.3.0 → 2.5.0 | |
| INFRA | golang | 1.26.5 → 1.27.4 | Repacked for both architectures |
| INFRA | grafana | 13.1.3 → 13.3.1 | Official native packages |
| INFRA | grafana-infinity-ds | 3.11.3 → 4.1.6 | Security / gRPC fixes |
| INFRA | grafana-plugins | 13.0.0 → 13.3.0 | Plugin bundle; includes JSON datasource 1.4.4 and ECharts 7.3.0. |
| INFRA | grafana-victorialogs-ds | 0.31.0 → 0.34.0 | Repacked for both architectures |
| INFRA | grafana-victoriametrics-ds | 0.25.2 → 1.0.1 | POST/WITH / security fixes |
| INFRA | headscale | 0.29.3 → 0.29.7 | |
| INFRA | hugo | 0.164.0 → 0.169.0 | Extended build. |
| INFRA | ivorysql | 5.4 → 5.6 | New native recipe; DEB ivorysql-5 / RPM ivorysql5; PostgreSQL 18.6 |
| INFRA | jmx-exporter | 1.6.0 → 1.7.0 | noarch Noarch; imported locally |
| INFRA | juicefs | 1.4.1 → 1.4.2 | |
| INFRA | k3s / k3s-images | 1.36.3 → 1.37.2 | Matching binary and air-gap image packages, revision 2PGSTY. |
| INFRA | kafka | 4.3.1 → 4.4.0 | Noarch RPM and all DEB; upstream SHA512 verified; imported locally |
| INFRA | kafka-exporter | 1.9.0 → 1.11.0 | |
| INFRA | kes | — → 20261026000000.0.0 | Key management service |
| INFRA | logcli / loki / loki-canary | 3.7.6 → 3.7.9 | Loki components updated together. |
| INFRA | maddy | 0.9.5 → 0.9.7 | DMARC/IMAP fixes |
| INFRA | mcli | 20260806000000.0.0 → 20261112000000.0.0 | Native pgsty packages; executable at /usr/local/bin/mcli. |
| INFRA | mcp-toolbox | 1.8.0 → 1.16.0 | CGO; glibc 2.28 |
| INFRA | mongodb-exporter | 0.52.0 → 0.54.0 | |
| INFRA | mtail | 3.4.7 → 3.4.20 | Repacked for both architectures |
| INFRA | mysqld-exporter | 0.19.0 → 0.21.0 | Metric type changes |
| INFRA | nginx-exporter | 1.5.1 → 1.5.3 | Dual-architecture RPM/DEB built |
| INFRA | nodejs | 24.19.0 → 26.13.1 | Node.js 26 LTS; RPM epoch 2. |
| INFRA | openbao | — → 2.7.2 | New official packages for both architectures; used by the VAULT module. |
| INFRA | opencode | 1.18.16 → 1.19.5 | Updated to 1.19.5; package revision 2PGSTY includes Bun security fixes. |
| INFRA | opentofu | — → 1.13.9 | New default IaC tool, package name tofu; includes state persistence fixes. |
| INFRA | pev2 | 1.23.0 → 1.25.0 | noarch RPM / all DEB noarch RPM / all DEB |
| INFRA | pg-exporter | 1.4.1 → 1.6.1 | Connection governance, failure cooldown and additional PostgreSQL 19 metrics. |
| INFRA | pg-hardstorage | 1.2.1 → 1.7.0 | Repacked for both architectures |
| INFRA | pg-timetable | 7.0.0 → 7.1.0 | Dual-architecture RPM/DEB built |
| INFRA | pgbackrest-exporter | 0.24.0 → 0.25.0 | Source build |
| INFRA | pgbot | — → 0.9.0 | New; beta |
| INFRA | pgext | — → 1.7.1 | Official native packages |
| INFRA | pggo | — → 0.1.1 | New |
| INFRA | pgschema | 1.12.2 → 1.14.1 | Repacked for both architectures |
| INFRA | pgstream | 1.3.1 → 1.6.0 | Source build from pinned commit |
| INFRA | pgsync | — → 0.1.1 | New; beta |
| INFRA | pgterm | — → 0.4.0 | New; beta |
| INFRA | pi-coding-agent | — → 1.5.2 | New package; complete upstream runtime |
| INFRA | pig | 1.8.0 → 1.11.0 | Pigsty 4.6.0 support; embedded catalog contains 625 available extensions. |
| INFRA | postgrest | 16.1 → 16.5 | Requires PostgreSQL 14 or newer. |
| INFRA | prometheus | 3.13.2 → 3.16.0 | TLS / Remote Write changes |
| INFRA | promtail | 3.6.7 → 3.6.11 | EOL artifact backfill |
| INFRA | pushgateway | 1.11.3 → 1.11.4 | Both architectures; imported locally |
| INFRA | rainfrog | 0.4.3 → 0.4.7 | Repacked for both architectures |
| INFRA | rclone | 1.75.0 → 1.76.0 | Repacked for both architectures |
| INFRA | redis-exporter | 1.89.0 → 1.97.0 | Redis 8 KEYSIZES |
| INFRA | rust-toolchain | 1.97.1 → 1.99.1 | Upstream signatures and dual-architecture ELF ABI checks passed; imported locally |
| INFRA | rustfs | 1.0.0-rc.1 → 1.0.5 | Available as an optional repository package; not a MINIO module backend. |
| INFRA | sabiql | 1.15.1 → 3.0.3 | Repacked for both architectures |
| INFRA | sealos | 5.0.1 → 5.1.1 | Official packages; upstream source uses the Sealos Sustainable Use License. |
| INFRA | seaweedfs | 4.41 → 4.53 | Package version: 4.53.0 |
| INFRA | silo | 20260806000000.0.0 → 20261112000000.0.0 | Native release packages, revision 1PGSTY, with Console 2.7.2 embedded. |
| INFRA | silo-console | — → 2.7.2 | New standalone console package, paired with Silo 20261112. |
| INFRA | sow | 0.3.0 → 0.7.1 | Existing 0.3/0.4 workspaces require an explicit migration. |
| INFRA | sql-studio | 0.1.51 → 0.1.53 | Dual-architecture RPM/DEB built |
| INFRA | stalwart | 0.16.17 → 1.1.0 | Major update to 1.x; migration required from 0.16.x. |
| INFRA | tailcat | — → 0.7.0 | Verified and built dual-architecture RPM/DEB |
| INFRA | timescaledb-tools | 0.19.0 → 0.19.1 | tune 0.19.1 + parallel-copy 0.13.2; Go 1.27.4 source builds |
| INFRA | uv | 0.12.3 → 0.13.7 | |
| INFRA | v2ray | 5.52.0 → 5.53.0 | Dual-architecture RPM/DEB built |
| INFRA | vector | 0.57.0 → 0.61.0 | Official native DEB/RPM packages. |
| INFRA | victoria-logs / vlogscli / vlagent | 1.52.0 → 1.53.0 | Logs components updated together. |
| INFRA | victoria-metrics / victoria-metrics-cluster / vmutils | 1.149.0 → 1.156.0 | Single-node, cluster and utility packages updated together. |
| INFRA | victoria-traces | 0.10.0 → 0.13.0 | gRPC TLS now opt-in |
| INFRA | xray | 26.3.27 → 26.11.9 | Repacked for both architectures |
| PIG | v1.8.1 | v1.8.0 → v1.8.1 | Go 1.27.1; CLI, repository and build safety improvements. |
| PIG | v1.9.0 | v1.8.1 → v1.9.0 | Xray client/server, repository signing keys, pgrx 0.19.3 and a 600-entry catalog. |
| PIG | v1.10.0 – v1.10.4 | v1.9.0 → v1.10.4 | Safer PG targets and recovery, inventory preservation, category aliases and Go 1.27.3. |
| PIG | v1.11.0 | v1.10.4 → v1.11.0 | Pigsty 4.6.0 support, kernel-specific configuration isolation, stricter backup/recovery/cleanup boundaries and a 625-entry catalog. |
| UPSTREAM | containerd.io | - → 2.4.2-3 | Official packages; separate docker repository module. |
| UPSTREAM | docker-buildx-plugin | - → 0.38.1 | Official packages; separate docker repository module. |
| UPSTREAM | docker-ce | - → 29.9.2 | Official packages; separate docker repository module. |
| UPSTREAM | docker-ce-cli | - → 29.9.2 | Official packages; separate docker repository module. |
| UPSTREAM | docker-ce-rootless-extras | - → 29.9.2 | Official packages; separate docker repository module. |
| UPSTREAM | docker-compose-plugin | - → 5.7.0 | Official packages; separate docker repository module. |
| UPSTREAM | nginx | - → 1.31.8 | Official packages; separate nginx repository module. |
| UPSTREAM | nginx-module-acme | - → 1.31.8+0.4.1 | Official packages; separate nginx repository module. |
Offline packages and validation
The release provides 14 complete .tgz offline archives, each below 2 GiB, with no reassembly required. Each contains an indexed local repository, repo_complete checksums and the same pigsty-v4.6.0.tgz source archive. Source, package manifests, offline notes and checksum files are attached separately.
| OS | x86_64(GiB) | ARM64(GiB) | Full offline deployment |
|---|---|---|---|
| EL 9 | 1.917 | 1.775 | PASS |
| EL 10 | 1.942 | 1.795 | PASS |
| Debian 12 | 1.753 | 1.599 | PASS |
| Debian 13 | 1.781 | 1.625 | PASS |
| Ubuntu 22.04 | 1.765 | 1.631 | PASS |
| Ubuntu 24.04 | 1.774 | 1.639 | PASS |
| Ubuntu 26.04 | 1.782 | 1.649 | PASS |
Validation results
- 14/14 fresh-VM installations passed: no preinstalled Ansible, Pigsty checkout or local repository; external access, host proxies and other guest services were blocked. Every VM independently ran the stock
richtemplate. Real Ansible deployments finished with zero failed, unreachable, ignored or rescued tasks. - Checks passed for the PG18 primary, the four rich extensions, 16 core services, HTTP health endpoints and a full pgBackRest backup to Silo. No unintended PG14, HDFS/Java, OneSparse/GraphBLAS/LAGraph or duplicate PostGIS branch was installed.
- Archive integrity, file/package membership, architecture, embedded source and transferred SHA-256 digests were verified. APT/DNF dependency closure also passed against an empty installed state using only the local repository. EL10 archives use an EPEL 10.2 snapshot matching Rocky 10.2.
- Cold-start Ansible
--checkremains limited by the not-yet-generated CA CSR; real deployment passes. Validation covers the enabled rich modules, not commented optional application examples.
Source archive and tag
Use the attached pigsty-v4.6.0.tgz, or its identical embedded copy, for installation. It is based on tag commit d71d9de86bf63aa4aa2886baeb542af66dbdfba6 and additionally includes the complete-set dependency solver and regenerated package maps. These fixes remain uncommitted and the tag has not moved, so GitHub’s automatic Source code (zip/tar.gz) archives do not contain them. The tag comparison covers only committed changes.
Source archive SHA-256:
Download SHA256SUMS from the same release and verify the files in your download directory:
See the offline installation guide for the installation workflow, and PACKAGE-MANIFEST.json / OFFLINE-NOTES.txt for exact contents and platform differences.
v4.5.0
Pigsty v4.5.0 adds pilot modules, replaceable data services, and orchestration based on cluster identity. It also improves observability and the software supply chain. The release adds Kafka KRaft, MySQL 8.4, and Valkey support, and makes Silo the MINIO backend. The packaged extension catalog grows from 531 to 575 extensions. Released on 2026-08-15. See the GitHub release and full source comparison at v4.4.0...v4.5.0.
Package, extension, and template counts below are snapshots from the release.
Highlights
- 575 extensions: Adds 46 entries and removes 2 from the 531 entries in v4.4.0, for a net increase of 44. The catalog now contains 575 extensions across 406 non-contrib package families. It tracks RPM/DEB coverage for each platform.
- Kafka KRaft module: Adds native Pigsty orchestration for Kafka and supports multiple clusters. It includes dynamic member enrollment and retirement, SCRAM/TLS, secure credential rotation, monitoring metrics, and Grafana dashboards.
- MySQL 8.4 module: Adds standalone and three-node InnoDB Cluster deployments. It includes MySQL Router, XtraBackup, user and database provisioning, monitoring, alerting, and idempotent reconciliation.
- Valkey and Silo: REDIS adds
redis_type: valkey; the final MINIO source accepts onlyminio_type: silo. The RustFS integration developed during this cycle was fully withdrawn before the candidate baseline. - 51 standalone configuration templates: Adds
demo/kafka,demo/mysql, and the eight-nodeha/octosimulation template to the 48 standalone templates in v4.4.0. The compatibility symlinkconf/app/supa.yml→../supabase.ymlremains available. - Safer cluster-identity orchestration: PGSQL, REDIS, MINIO, KAFKA, and MYSQL initialization playbooks skip unrelated hosts by explicit cluster identity. Their removal playbooks do the same, except
mysql-rm.yml. That playbook stops with an error for any incorrectly selected host. etcd delegation and DBSU key exchange now use actual cluster members. - Observability and supply chain: Re-exports Grafana dashboards to Dashboard API v2 and moves MinIO/Silo collection to Metrics V3. Generates local repositories atomically with SOW and removes synthetic ModuleMD metadata.
- Kernel and toolchain updates: Completes pgBackRest support for PostgreSQL 19 Beta templates and enables cluster mode for Percona PostgreSQL TDE. Fixes IvorySQL initialization and WAL compression. Updates extension package maps, exporters, and build tooling.
New Modules and Data Services
- The Kafka module uses node state as the source of truth for dynamic KRaft orchestration. It manages one or more clusters in one inventory. It supports a
kafka.ymlrun without a limit and rejects partial--limitselections. The destructivekafka-rm.ymlrequires a non-empty-l/--limit. Before partial retirement can stop services, it validates a safe absolute data path and surviving broker/controller anchors. Nodes retain authoritative manifests and secrets. Supported operations include dynamic controller joins, broker admission, member retirement, and three-step dead-node replacement. The module supports SCRAM-SHA-512/TLS, credential and certificate rotation, and self-tested partition health checks. - The MySQL pilot module uses a fixed MySQL 8.4 LTS platform. It accepts a standalone node or a three-node InnoDB Cluster. It includes MySQL Shell and Router, scheduled full XtraBackup backups, TLS, and account and database provisioning. It also includes primary-key policy checks, conservative member removal, and idempotent reconciliation.
- The REDIS module retains
redisas its default engine and supports Valkey throughredis_type: valkey. Service units now useType=notifywith a 1,800-second startup timeout. This release also improves topology validation, password handling, tag-scoped removal behavior, and rebuild protection. - The MINIO module now deploys only Silo.
minio_typeremains an extension point, but this release accepts onlysilo. At startup, the module checks the systemd Invocation ID andActiveState=activefor the current restart. It waits about 600 seconds by default, then runs the Silo cluster health check. Infra packages addsiloandmcli. They preserve the S3/Admin APIs,/minio/*routes,MINIO_*environment variables, and disk format. minio_clustergroups the object-storage topology. Its inventory group name can differ, and one inventory can contain multiple object-storage clusters. Use distinctminio_alias,minio_domain, andminio_endpointvalues for each cluster. This prevents shared client aliases on INFRA nodes from being overwritten.demo/minionow selects Silo explicitly and limits its local repository to theinfra,nodemodules.- The standalone FERRET module is replaced by PostgreSQL Mongo mode and the FerretDB Docker APP. PostgreSQL provides the DocumentDB data layer, while Docker Compose provides the FerretDB protocol layer.
Orchestration, Security, and Tooling
deploy.yml,slim.yml, and PGSQL, REDIS, MINIO, KAFKA, and MYSQL initialization playbooks now skip unrelated hosts by their*_clusteridentity. PGSQL, REDIS, MINIO, and KAFKA removal playbooks do the same.mysql-rm.ymldoes not skip hosts without identity. It stops with an error inmysql_rm_check. Every host that enters a role still receives an internal identity check.- PGSQL configuration, PITR, and removal workflows delegate only if the canonical
etcdgroup exists and has at least one member. They no longer silently fall back to localhost when no etcd target exists. DBSU SSH key exchange uses the actualpg_cluster_members. This supports topologies that cross inventory groups, such as Citus. - PGSQL PITR and removal now delete only the etcd subtree bounded by
/<cluster>/. This protects adjacent clusters whose names share a prefix. Pigsty writes the initial pgBackRest marker/etc/pgbackrest/initial.doneonly after the backup command succeeds. - HAProxy uses the fixed
/etc/haproxy/haproxy.cfgand/etc/haproxy/conf.dlayout, upstream master-worker mode, a master socket, andType=notify. dnsmasq now binds dynamically, answers private reverse lookups locally, and handles node addresses added after INFRA initialization. - Pigsty places its rendered systemd units under
/etc/systemd/system. This release further restricts permissions on sensitive configuration and privileged files. Removal workflows stop services before data cleanup. - REPO and CACHE now use
sow create --pigstyto generate RPM/APT metadata and the SHA-256repo_completemarker atomically. They no longer generate synthetic ModuleMD metadata.pg_idalso compares cluster size as an explicit integer for older Ansible releases. - RPM exporter package names move from underscores to hyphens, for example
node_exporter→node-exporter. Debian repository naming and PGDG YUM extension package mappings are corrected as well. - Tuned profiles use
/etc/tuned/profileson EL 10, Debian 13, and Ubuntu 26. They use/etc/tunedon EL 8/9, Debian 12, and Ubuntu 22/24. Debian/Ubuntu package installation also prevents premature starts of Silo, Redis/Valkey, and legacy log services. - This release updates China-region repository routing. OS, Docker, Grafana, Percona, supported MongoDB APT, and uv/PyPI paths prefer Tencent Cloud. EL and Docker entries retain Huawei Cloud and Aliyun fallbacks where appropriate. MySQL and Kubernetes use USTC mirrors, and ClickHouse uses Huawei Cloud. MongoDB RPM no longer advertises an unavailable China-region alternative.
roles/node_id/vars/<os>.<arch>.ymldefines the final choices for each platform. - The Docker image moves to Debian 13.6 and Pigsty v4.5.0. Vagrant adds
root_disk, defaulting to 64 GiB or 128 GiB in the build matrix, accepts pinned box versions, and adds the eight-nodeha/octolab.docker/Makefilefixes its data directory at./data, andmake purgedeletes that directory directly. - GitHub Actions for checkout, CodeQL, Docker build/login, and Cosign are upgraded in one batch. Release, bootstrap, install, and validation scripts also tighten file and argument handling. Release archives now derive top-level
pigsty.ymlfromconf/meta.yml, include the Kafka/MySQL playbooks, and drop the legacy Mongo playbook. - The Cosign workflow in the source must run from
mainand handles onlypigsty-<tag>.tgz. The GitHub release separately provides GPG detached signatures for the source archive, 14 offline bundles, andchecksums, for 32 uploaded assets in total. See offline installation for downloads and verification. The build-host matrix matchesconf/build/oss.yml: EL 9/10, Debian 12/13, and Ubuntu 22/24/26.
Observability
- Re-exports the dashboard set through the Pig/Grafana tooling to Dashboard API v2. Adds four Kafka and five MySQL dashboards, and refreshes links, variables, and layouts across Node, PostgreSQL, Redis, and Infra dashboards.
- Migrates the MinIO/Silo Overview and Instance dashboards to Metrics V3. Victoria scrapes the
/minio/metrics/v3root endpoint and drops high-cardinality samples carrying a non-emptybucketlabel. - Updates the
pg_exporterconfiguration to 1.4.0. Fixes duplicate time series from the 1.4.1pg_subrelquery. PG19 gainspg_sub_19,pg_recovery_state,pg_wal_19,pg_lock_stat, andpg_vacuum_score. PG10+ gains thepg_xact_agetransaction-age histogram. The update also covers replication-slotidle_timeoutand WAL Receiverconnectingstate encoding. Kafka JMX/protocol exporters and the MySQL exporter join the standard target and alert pipelines.
PostgreSQL Kernels and Extension Packages
PostgreSQL 19 beta3 templates now include pgBackRest packages and backup support.
All four standard Patroni templates add the PostgreSQL 18.6 logical-decoding allowlist
output_plugin_libraries: 'pgoutput, test_decoding, wal2json'. Patroni filters it on older PostgreSQL versions that do not support this setting.Percona PostgreSQL 18 TDE now uses cluster mode and retains Pigsty-prefixed packages to avoid conflicts with native PostgreSQL packages.
IvorySQL now initializes its default database correctly and enables compatible WAL compression in workload templates.
Updates the PostgreSQL fact loader, per-platform
package_map, and default extension groups. These changes fill package gaps and correct PGDG/YUM naming. Compared with the v4.4.0 PIG v1.5.1 catalog, the current catalog adds 46 names and removes 2:- 32 new primary extensions:
argm,cat_tools,cron_utils,fbsql,oidc_validator,online_advisor,pg_cjk_parser,pg_column_tetris,pg_describe,pg_disorder,pg_fts,pg_jieba,pg_kpart,pg_lake,pg_local_cache,pg_mentat,pg_oidc_validator,pg_policy,pg_roast,pg_tiktoken_c,pg_turbovec,pg_vault_tde,pgcontext,pgfr_record,pgmemento,pgmonitor,pgsqlmock,pgwasm,plruby,plx,postbis, andqdgc. - 13 child extensions from those package families:
hstore_plruby,jsonb_plruby,ltree_plruby,pg_extension_base,pg_extension_updater,pg_lake_copy,pg_lake_engine,pg_lake_iceberg,pg_lake_table,pg_map,pgcontext_pgvector,pgfr_analyze, andqdgc_postgis. - One new PGDG extension,
pg_statviz. Its package is hidden from the default install group, but the extension remains in the online catalog. - Two catalog removals:
pg_analyticsandspat. The total therefore rises from 531 to 575, a net gain of 44.
- 32 new primary extensions:
Cumulative notable upgrades include
citus14.2.0,pg_search0.25.2,timescaledb2.29.1,vector0.8.6,documentdb0.114,pg_partman5.5.0,pgmnemo0.16.1,plpgsql_check2.10.4,provsql1.12.0, andpgbson2.1.0, plus a broad pgrx 0.19.1 rebuild.The merged table below and the original RPM changelog and DEB changelog give full build records and platform differences. New catalog entries include
pg_local_cacheandpg_policy. Changelog dates identify package batches. They do not necessarily match the current CSVmtimefor each entry.pg_statvizis excluded only from the default install group indb/reload.sql; its detail page, platform coverage, and package-name differences remain in the online catalog.
Extension Package Update Log
The table below merges the RPM changelog and DEB changelog after v4.4.0. It has 231 rows aligned by batch and extension name. Identical RPM and DEB records share a row. Version or note differences appear separately. An unchanged version still indicates a rebuild, package-name change, license-metadata change, or platform-coverage change.
The first extension batch after July 10 is July 24. The original batch covers July 7–24 without dates for individual items. The full batch appears here to retain post-release pgrx rebuilds and package-matrix fixes. “RPM only” or “DEB only” means the other changelog has no row for that extension in the same batch.
| Batch | Extension | Version Change | Notes |
|---|---|---|---|
| 2026-08-14 | asn1oid | RPM only: 1.6 → 1.6 | License metadata: GPL-3.0-or-later; r2; PG14-18 |
| 2026-08-14 | emailaddr | 0 → 0 | License metadata: LicenseRef-Upstream-No-License; r3; PG14-18 |
| 2026-08-14 | explain_ui | 0.0.2 → 0.0.2 | License metadata: LicenseRef-Upstream-No-License; r4; PG14-18 |
| 2026-08-14 | numeral | RPM only: 1.3 → 1.3 | License metadata: GPL-2.0-or-later; r6; PG14-18 |
| 2026-08-14 | oidc_validator | 0.1.0 → 0.1.0 | Rust module; LicenseRef-Upstream-No-License; r2; PG18 |
| 2026-08-14 | pg_failover_slots | 1.2.1 → 1.2.1 | License metadata: PostgreSQL; r2; preload; PG14-18 |
| 2026-08-14 | pg_geohash | 1.0 → 1.0 | License metadata: MIT; r4; fix SQL filename and target-PG ABI; PG14-18 |
| 2026-08-14 | pg_oidc_validator | 0.2 → 1.1.0 | RPM: PG18 OAuth validator module; add discovery_url_override; EL10 onlyDEB: PG18 OAuth validator module; add discovery_url_override and GSSAPI build dependency |
| 2026-08-14 | pg_relation_sql | - → 0.2.2 | RPM: Standalone SQL; no CREATE EXTENSION; noarch; PG14-18DEB: Standalone SQL; no CREATE EXTENSION; Architecture: all; PG14-18 |
| 2026-08-14 | pg_summarize | 0.0.1 → 0.0.1 | License metadata: LicenseRef-Upstream-No-License; r6; PG14-18 |
| 2026-08-14 | pg_when | 0.1.9 → 0.1.10 | GitHub/PGXN release; upstream pgrx 0.18.1, packaged with 0.19.1; PG14-18 |
| 2026-08-14 | pre_prepare | RPM only: 0.9 → 0.9 | License metadata: PostgreSQL; r2; PG14-18 |
| 2026-08-14 | smlar | 1.0 → 1.0 | License metadata: LicenseRef-Upstream-No-License; r2; PG14-18 |
| 2026-08-14 | unit | 7.10 → 7.10 | License metadata: GPL-3.0-or-later; r7; PG14-18 |
| 2026-08-12 | biscuit | 2.4.3 → 3.0.0 | PG16-18; 2.x indexes require REINDEX |
| 2026-08-12 | cat_tools | - → 0.3.0 | SQL-only; PG14-18 |
| 2026-08-12 | citus | 14.1.0 → 14.2.0 | Includes citus_columnar; PG16-18 |
| 2026-08-12 | pg_clickhouse | 0.3.2 → 0.10.0 | PG14-18 |
| 2026-08-12 | pg_describe | - → 1.0.0 | PG17-18 |
| 2026-08-12 | pg_disorder | - → 0.1.0 | PG14-18 |
| 2026-08-12 | pg_local_cache | - → 1.3.0 | PG14-18; preload; single-primary |
| 2026-08-12 | pg_mentat | - → 1.5.7 | PG14-18 |
| 2026-08-12 | pg_policy | - → 0.1.0 | SQL-only; PG14-18 |
| 2026-08-12 | pg_rational | 0.0.2 → 0.0.3 | RPM: PIGSTY; PG14-18 DEB: PGDG; PG14-18 |
| 2026-08-12 | pg_readme | 0.7.0 → 0.7.1 | RPM: Catalog 0.7.1; RPM remains PGDG 0.7.0 DEB: Includes pg_readme_test_extension; PG14-18 |
| 2026-08-12 | pg_search | 0.25.0 → 0.25.2 | PG15-18; pgrx 0.19.1; preload |
| 2026-08-12 | pg_squeeze | 1.9.2 → 1.9.4 | PGDG; PG14-18 |
| 2026-08-12 | pg_statviz | RPM: - → 0.9DEB: - → 1.1 | RPM: PGDG; PG14-16 and EL10 PG18; no PG17; not in default groups DEB: PGDG; PG14-18 except Ubuntu 22.04; not in default groups |
| 2026-08-12 | pg_turbovec | - → 1.29.0 | PG14-18; pgrx 0.19.1 |
| 2026-08-12 | pg_uuid_v8 | 1.0.0 → 1.1.0 | PG14-18; includes 1.0-to-1.1 upgrade script |
| 2026-08-12 | pg_vault_tde | - → 1.7.0 | RPM: PG17-18; EL9/10; preload DEB: PG17-18; preload |
| 2026-08-12 | pgbson | 2.0.4 → 2.1.0 | RPM: RPM package postgresbson; PG14-18 DEB: Source package postgresbson; PG14-18 |
| 2026-08-12 | pgmnemo | 0.15.0 → 0.16.1 | PG17-18 |
| 2026-08-12 | plpgsql_check | 2.10.3 → 2.10.4 | PG14-18 |
| 2026-08-12 | plruby | - → 2.5.0 | Includes jsonb_plruby, hstore_plruby, ltree_plruby; PG14-18 |
| 2026-08-12 | polardb-17 | 17.10.1.0-1PIGSTY → 17.10.1.0-2PGSTY | Rebuild; PG17 |
| 2026-08-12 | polarstore | 1.2.42-1PIGSTY → 1.2.42-2PGSTY | Rebuild |
| 2026-08-12 | provsql | 1.11.0 → 1.12.0 | PG14-18 |
| 2026-08-12 | q3c | RPM: 2.0.2 → 2.0.5DEB: 2.0.4 → 2.0.5 | RPM: PGDG; PIGSTY remains 2.0.2; PG14-18 DEB: PGDG; PG14-18 |
| 2026-08-12 | timescaledb | 2.29.0 → 2.29.1 | PG16-18 |
| 2026-08-12 | vector | 0.8.6 → 0.8.6 | PGDG repository refresh; PG14-18 |
| 2026-08-12 | zlog | 1.2.18-1PIGSTY → 1.2.18-2PGSTY | Rebuild |
| 2026-07-30 | emaj | RPM: - → 5.0.0DEB: 4.7.1 → 5.0.0 | RPM: Renamed to e-maj; Provides/Obsoletes emaj; r2DEB: PG14-18 |
| 2026-07-30 | graph | 0.1.8 → 1.0.0 | pggraph; PG14-18; pgrx 0.19.1 |
| 2026-07-30 | nominatim_fdw | 2.0.0 → 2.1.0 | PG14-18 |
| 2026-07-30 | numeral | RPM only: 1.3 → 1.3 | Renamed to postgresql-numeral; Provides/Obsoletes numeral; r3 |
| 2026-07-30 | pg_ai_query | RPM only: 0.1.1 → 0.1.1 | EL9/10 only (GCC 13/OpenSSL 3); r2 not indexed |
| 2026-07-30 | pg_column_tetris | - → 0.1.0 | SQL-only; PG14-18 |
| 2026-07-30 | pg_net | 0.20.5 → 0.20.5 | RPM: EL8/9: 0.9.2; EL10: 0.20.5; r3 not indexed DEB: D12/D13/U24/U26: 0.20.5; U22: 0.9.2; r2 not indexed |
| 2026-07-30 | pg_partman | RPM: 5.4.0 → 5.5.0DEB: 5.4.2 → 5.5.0 | RPM: PG14-18 DEB: Use postgresql-PGVERSION-partman package name |
| 2026-07-30 | pg_search | 0.24.3 → 0.25.0 | PG15-18; pgrx 0.19.1; add pgvector/OpenBLAS dependencies |
| 2026-07-30 | pgcontext | - → 0.2.0 | PG17-18; pgrx 0.19.1; optional pgvector bridge |
| 2026-07-30 | pgedge | RPM only: 18.4 → 18.4 | PG15-18 ABI fix; r2 not indexed |
| 2026-07-30 | pgmnemo | 0.13.0 → 0.15.0 | PG17-18; requires pgvector >= 0.7.0 |
| 2026-07-30 | pgmp | - → 1.0.6 | PG14-18; GMP dependency |
| 2026-07-30 | pgpcre | RPM only: 0.20190509 → 0.20190509 | EL8/9 only; r2 not indexed |
| 2026-07-30 | pgwasm | - → 0.1.0 | PG14-18 |
| 2026-07-30 | plpgsql_check | 2.10.1 → 2.10.3 | PG14-18; optional preload |
| 2026-07-30 | postbis | - → 1.0 | PG14-18 compatibility patch; r2 |
| 2026-07-30 | qdgc | - → 0.1.0 | PG14-18; includes qdgc_postgis |
| 2026-07-30 | rdf_fdw | 2.6.0 → 2.7.0 | PG14-18 |
| 2026-07-30 | timescaledb | 2.28.3 → 2.29.0 | PG16-18 |
| 2026-07-30 | uri | RPM only: 1.20251029 → 1.20251029 | Renamed to pguri; Provides/Obsoletes pg_uri; r2 |
| 2026-07-30 | vector | 0.8.5 → 0.8.6 | PG14-18; 0.8.6 not indexed |
| 2026-07-30 | pg_rewrite | DEB only: 2.0.0 → 2.2 | Renamed to postgresql-PGVERSION-pg-rewrite; PG14-18 |
| 2026-07-30 | pgactive | DEB only: 2.1.7 → 2.1.7 | PG14-18 build fix; r2 not indexed |
| 2026-07-30 | pgzint | DEB only: - → 0.2.0 | D13/U26 only; requires Zint >= 2.14; not indexed |
| 2026-07-30 | timeseries | DEB only: 0.2.1 → 0.2.1 | Fix partman/cron Recommends and docs; r3 |
| 2026-07-24 | argm | - → 1.1.1 | PG14-18 |
| 2026-07-24 | cron_utils | - → 0.1.0 | SQL-only; PG14-18 |
| 2026-07-24 | fbsql | - → 0.1.0 | PL/R; PG16-18 |
| 2026-07-24 | oidc_validator | - → 0.1.0 | Rust OIDC; PG18 |
| 2026-07-24 | online_advisor | - → 1.0 | PG14-18 |
| 2026-07-24 | pg_cjk_parser | - → 0.1.0 | PG14-18 |
| 2026-07-24 | pg_extension_base | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_extension_updater | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_fts | - → 0.2.0 | PG17-18 |
| 2026-07-24 | pg_jieba | - → 1.1.0 | pkg 2.0.1; SQL 1.1.0; PG14-18 |
| 2026-07-24 | pg_kpart | - → 1.0 | PG14-18 |
| 2026-07-24 | pg_lake | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_lake_copy | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_lake_engine | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_lake_iceberg | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_lake_table | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_map | - → 3.4 | pg_lake 3.4; PG16-18; RPM EL9/10 |
| 2026-07-24 | pg_oidc_validator | - → 0.2 | Percona OIDC; PG18; DEB all, RPM EL10 |
| 2026-07-24 | pg_roast | - → 1.0 | PG14-18 |
| 2026-07-24 | pg_tiktoken_c | - → 1.1 | PG14-18 |
| 2026-07-24 | pgfr_analyze | - → 2.29.2 | pg_flight_recorder; PG15-18 |
| 2026-07-24 | pgfr_record | - → 2.29.2 | pg_flight_recorder; PG15-18 |
| 2026-07-24 | pgmemento | - → 0.7.4 | SQL-only; PG14-18 |
| 2026-07-24 | pgmonitor | - → 2.2.0 | PG14-18 |
| 2026-07-24 | pgsqlmock | - → 1.0.1 | PG14-18 |
| 2026-07-24 | plx | - → 1.3.1 | PG14-18 |
| 2026-07-24 | anon | 3.1.1 → 3.1.3 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | block_copy_command | 0.1.5 → 0.1.5 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | convert | 0.1.0 → 0.1.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | etcd_fdw | 0.0.1 → 0.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | explain_ui | 0.0.2 → 0.0.2 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | graph | 0.1.7 → 0.1.8 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | jsonschema | 0.1.9 → 0.1.9 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_base58 | 0.0.1 → 0.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_bestmatch | 0.0.2 → 0.0.2 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_cardano | 1.2.0 → 1.2.0 | pgrx 0.19.1; PG15-18 |
| 2026-07-24 | pg_command_fw | 0.1.0 → 0.1.0 | pgrx 0.19.1; PG15-18 |
| 2026-07-24 | pg_durable | 0.2.2 → 0.2.3 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_enigma | 0.5.0 → 0.5.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_eviltransform | 0.0.2 → 0.0.4 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_graphql | 1.6.1 → 1.6.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_idkit | 0.4.0 → 0.4.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_jsonschema | 0.3.4 → 0.3.4 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_kazsearch | 2.2.0 → 2.3.0 | pgrx 0.19.1; PG16-18 |
| 2026-07-24 | pg_later | 0.4.0 → 0.4.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_mooncake | 0.2.0 → 0.2.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_parquet | 0.5.1 → 0.5.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_pinyin | 0.0.4 → 0.0.5 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_polyline | 0.0.1 → 0.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_render | 0.1.3 → 0.1.3 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_rrf | 0.0.3 → 0.0.3 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_search | 0.24.0 → 0.24.3 | pgrx 0.19.1; PG15-18 |
| 2026-07-24 | pg_session_jwt | 0.5.0 → 0.5.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_smtp_client | 0.2.1 → 0.2.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_strict | 1.0.5 → 1.0.5 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_summarize | 0.0.1 → 0.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_tiktoken | 0.0.1 → 0.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_tokenizer | 0.1.1 → 0.1.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pg_trickle | 0.81.0 → 0.81.0 | pgrx 0.19.1; PG18 |
| 2026-07-24 | pg_when | 0.1.9 → 0.1.9 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pgdd | 0.6.1 → 0.6.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pglinter | 2.0.0 → 2.0.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pglite_fusion | 0.0.6 → 0.0.6 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pgmqtt | 0.3.0 → 0.4.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pgrdf | 0.6.4 → 0.6.20 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pgsmcrypto | 0.1.1 → 0.1.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | pgx_ulid | 0.2.3 → 0.2.3 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | plprql | 18.0.1 → 18.0.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | timescaledb_toolkit | 1.23.0 → 1.23.0 | pgrx 0.19.1; PG15-18 |
| 2026-07-24 | typeid | 0.3.0 → 0.3.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | tzf | 0.3.0 → 0.3.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | vchord | 1.1.1 → 1.1.1 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | vchord_bm25 | 0.3.0 → 0.3.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | vectorize | 0.26.2 → 0.26.2 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | vectorscale | 0.9.0 → 0.9.0 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | wrappers | 0.6.1 → 0.6.2 | pgrx 0.19.1; PG14-18 |
| 2026-07-24 | age | RPM only: 1.7.0 → 1.8.0 | PG18: 1.8.0-rc0; PG17: 1.7.0 |
| 2026-07-24 | babelfishpg_tsql | 5.5.0 → 5.4.0 | Catalog fix: 5.4.0; PG17-18 |
| 2026-07-24 | biscuit | 2.4.1 → 2.4.3 | pkg 2.4.3; SQL 2.4.1; PG16-18 |
| 2026-07-24 | decoderbufs | 3.5.0 → 3.6.0 | DEB 3.6.0; RPM 3.5.0; PG14-18 |
| 2026-07-24 | documentdb | 0.113 → 0.114 | PG15-18; 16 targets |
| 2026-07-24 | documentdb_core | 0.113 → 0.114 | PG15-18; 16 targets |
| 2026-07-24 | documentdb_distributed | 0.113 → 0.114 | PG15-18; 16 targets |
| 2026-07-24 | documentdb_extended_rum | 0.113 → 0.114 | PG15-18; 16 targets |
| 2026-07-24 | http | 1.7.1 → 1.7.2 | PG14-18 |
| 2026-07-24 | jdbc_fdw | 0.4.0 → 0.5.0 | pkg 0.5.0; SQL 1.2; PG14-18; 16 targets |
| 2026-07-24 | nominatim_fdw | 1.3 → 2.0.0 | PG14-18; 16 targets |
| 2026-07-24 | odbc_fdw | 0.5.1 → 0.6.1 | pkg 0.6.1; SQL 0.5.2; PG14-18 |
| 2026-07-24 | ogr_fdw | 1.1.8 → 1.1.9 | PG14-18 |
| 2026-07-24 | pg_csv | RPM only: 1.0.1 → 1.0.2 | +RPM; pkg 1.0.2; SQL 1.0.1; PG14-18 |
| 2026-07-24 | pg_dbms_errlog | 2.2 → 2.4 | PG14-18 |
| 2026-07-24 | pg_ivm | 1.14 → 1.15 | PG14-18 |
| 2026-07-24 | pg_net | 0.20.3 → 0.20.5 | RPM: pkg 0.20.5; SQL 0.20.4; PG14-18; RPM EL10 DEB: D12/D13/U24/U26: 0.20.5; U22: 0.9.2 (libcurl); PG14-18 |
| 2026-07-24 | pg_rewrite | RPM only: 2.0.0 → 2.2 | PG14-18 |
| 2026-07-24 | pg_statement_rollback | 1.5 → 1.6 | PG14-18 |
| 2026-07-24 | pg_tde | 2.1 → 2.2 | Percona; PG17-18 |
| 2026-07-24 | pgnodemx | RPM only: 1.7 → 2.0.1 | pkg 2.0.1; SQL 2.0; PG14-18; cgroup-safe |
| 2026-07-24 | pgauditlogtofile | 1.8.4 → 1.8.5 | PG14-18 |
| 2026-07-24 | pgbson | 2.0.2 → 2.0.4 | pkg 2.0.4; SQL 2.0; PG14-18 |
| 2026-07-24 | pgclone | 4.3.2 → 4.4.2 | PG14-18 |
| 2026-07-24 | pgextwlist | 1.19 → 1.20 | PG14-18 |
| 2026-07-24 | pgmnemo | 0.12.1 → 0.13.0 | PG17-18 |
| 2026-07-24 | pgmq | 1.11.1 → 1.12.0 | PG14-18 |
| 2026-07-24 | pgsentinel | 1.4.1 → 1.4.2 | RPM 1.4.2; DEB 1.4.0; U26 1.4.1; PG14-18 |
| 2026-07-24 | plpgsql_check | 2.9.2 → 2.10.1 | PG14-18 |
| 2026-07-24 | plproxy | 2.11.0 → 2.12.0 | PG14-18 |
| 2026-07-24 | powa | 5.1.2 → 5.2.0 | DEB 5.2.0; RPM 5.1.0; PG14-18 |
| 2026-07-24 | provsql | 1.10.0 → 1.11.0 | PG14-18 |
| 2026-07-24 | re2 | 0.3.0 → 0.4.1 | PG16-18 |
| 2026-07-24 | snowflake | 2.4 → 2.5.0 | pgEdge; PG15-18 |
| 2026-07-24 | spock | 5.0.6 → 5.0.10 | pgEdge; PG15-18 |
| 2026-07-24 | tdigest | 1.4.3 → 1.4.4 | PG14-18 |
| 2026-07-24 | timescaledb | 2.28.2 → 2.28.3 | PG15-18: 2.28.3; PG14: 2.19.3; 6 EL |
| 2026-07-24 | vector | 0.8.4 → 0.8.5 | PG14-18 |
| 2026-07-24 | babelfishpg_money | 1.1.0 → 1.1.0 | Babelfish: +PG18 |
| 2026-07-24 | babelfishpg_tds | 1.0.0 → 1.0.0 | Babelfish: +PG18 |
| 2026-07-24 | citus | 14.1.0 → 14.1.0 | Citus 13.0.0; EL10 RPM PG14, 2 arch |
| 2026-07-24 | dbt2 | 0.61.7 → 0.61.7 | +DEB PG14-18; +EL8 RPM PG17-18, 2 arch |
| 2026-07-24 | decoder_raw | 1.0 → 1.0 | EL10/D13; PG14-16; 2 arch |
| 2026-07-24 | faker | 0.5.3 → 0.5.3 | RPM: +DEB PG14-18 DEB: +DEB PG14-18; D12/U22: python3-fake-factory 22.0.0 |
| 2026-07-24 | gb18030_2022 | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | h3 | 4.2.3 → 4.2.3 | EL8 x86_64 RPM PG17-18 |
| 2026-07-24 | hdfs_fdw | 2.3.3 → 2.3.3 | +DEB PG14-18 |
| 2026-07-24 | hstore_pllua | 2.0.12 → 2.0.12 | +RPM 6 EL PG14-18 |
| 2026-07-24 | hstore_plluau | 2.0.12 → 2.0.12 | +RPM 6 EL PG14-18 |
| 2026-07-24 | hunspell_cs_cz | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_de_de | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_en_us | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_fr | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_ne_np | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_nl_nl | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_nn_no | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_pt_pt | 1.0 → 1.0 | 16 targets; pt_pt.stop avoids core conflict |
| 2026-07-24 | hunspell_ru_ru | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | hunspell_ru_ru_aot | 1.0 → 1.0 | hunspell bundle; 10 dictionaries; 16 targets; PG14-18 |
| 2026-07-24 | imgsmlr | 1.0 → 1.0 | EL10/D13; PG14-18; 2 arch |
| 2026-07-24 | ivorysql_ora | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | mobilitydb | 1.3.0 → 1.3.0 | +RPM 6 EL PG14-18; +U22 DEB PG18 |
| 2026-07-24 | mobilitydb_datagen | 1.3.0 → 1.3.0 | mobilitydb bundle; +RPM 6 EL; +U22 DEB PG18 |
| 2026-07-24 | omni | 0.2.14 → 0.2.14 | omnigres 20251108; EL10 PG14-18; EL8/9,D12/U22 PG18 |
| 2026-07-24 | ora_btree_gin | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | ora_btree_gist | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | pg_dbms_job | 2.0 → 2.0 | +DEB PG14-18 |
| 2026-07-24 | pg_dbms_lock | 2.0 → 2.0 | +DEB PG14-18 |
| 2026-07-24 | pg_dbms_metadata | 1.0.0 → 1.0.0 | +DEB PG14-18; +EL8 aarch64 RPM PG15 |
| 2026-07-24 | pg_fact_loader | 2.0.1 → 2.0.1 | U26 DEB PG14-18 |
| 2026-07-24 | pg_get_functiondef | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | pg_strom | 6.1 → 6.1 | pg_strom 3.5; EL10 x86_64 PG14 |
| 2026-07-24 | pgautofailover | 2.2 → 2.2 | 6 EL RPM: +PG18 |
| 2026-07-24 | pgbouncer_fdw | 1.4.0 → 1.4.0 | +DEB PG14-18 |
| 2026-07-24 | pg_wait_sampling | RPM only: 1.1.11 → 1.1.11 | +RPM PG14-18; SQL 1.1 |
| 2026-07-24 | pgl_ddl_deploy | 2.2.1 → 2.2.1 | RPM: +RPM PG14-18; +U26 DEB PG14-17 DEB: 10 DEB: +PG18; U26 PG14-17 |
| 2026-07-24 | pglogical_ticker | 1.4.1 → 1.4.1 | 6 EL RPM PG14-17 |
| 2026-07-24 | pgmemcache | 2.3.0 → 2.3.0 | EL8 aarch64 RPM PG14-15 |
| 2026-07-24 | pgml | 2.10.0 → 2.10.0 | EL10/D13/U26; PG14-17; 2 arch |
| 2026-07-24 | pgspider_ext | 1.3.0 → 1.3.0 | RPM: +RPM PG14-18; PG18 compatible DEB: 10 DEB: +PG18; PG15-18 |
| 2026-07-24 | plisql | 1.0 → 1.0 | IvorySQL 5.4; PG18; 16 targets |
| 2026-07-24 | pllua | 2.0.12 → 2.0.12 | 6 EL: +PG18; EL8 aarch64: +PG14-15 |
| 2026-07-24 | rdkit | 202503.6 → 202503.6 | RPM: 202303.3; EL8/9, D12/U22; PG14-18 DEB: D12/U22 PG17-18: 202303.3; U26 PG14-17: 202503.6; runtimes unchanged |
| 2026-07-24 | sqlite_fdw | 2.5.0 → 2.5.0 | RPM: RPM r3: +PG18, EL8 SQLite; PG14-18 DEB: 10 DEB: +PG18; PG14-18 |
| 2026-07-24 | sslutils | 1.4 → 1.4 | EL8 RPM PG18, 2 arch |
| 2026-07-24 | wal2mongo | 1.0.7 → 1.0.7 | RPM: +RPM PG14-18; PG17-18 compatible DEB: 10 DEB: +PG17-18; PG14-18 |
| 2026-07-24 | system_stats | DEB only: 4.0 → 4.1 | PG14-18; 10 DEB targets |
Infrastructure Package Update Log
The following table contains all 144 Infra log records after v4.4.0, from 2026-07-16 through the latest batch on 2026-08-12. It also includes the ferretdb2 rebuild and RPM exporter package-name migration from the changelog prose. Consecutive upgrades of the same package remain separate batch entries.
Build, download, and verification status uses the original log wording. It does not confirm repository indexing, signing, synchronization, or offline-bundle acceptance. For full context, see the Infra changelog.
| Batch | Package | Old Version | New Version | Notes |
|---|---|---|---|---|
| 2026-08-12 | claude | 2.1.226 | 2.1.227 | Official manifest verified via proxy; dual-arch RPM/DEB built |
| 2026-08-12 | code-server | 4.131.0 | 4.132.0 | Official dual-architecture RPM/DEB downloaded and verified |
| 2026-08-12 | grafana-infinity-ds | 3.11.2 | 3.11.3 | Built as dual-architecture RPM/DEB |
| 2026-08-12 | mtail | 3.4.6 | 3.4.7 | Built as dual-architecture RPM/DEB |
| 2026-08-12 | opencode | 1.18.15 | 1.18.16 | Built as dual-architecture RPM/DEB |
| 2026-08-12 | pg-hardstorage | 1.1.1 | 1.2.1 | Official dual-architecture RPM/DEB downloaded and verified |
| 2026-08-12 | pig | 1.6.1 | 1.8.0 | Official dual-architecture RPM/DEB downloaded and verified |
| 2026-08-12 | postgrest | 16.0 | 16.1 | Static dual-architecture RPM/DEB; requires PostgreSQL 14+ |
| 2026-08-12 | redis-exporter | 1.88.0 | 1.89.0 | Built as dual-architecture RPM/DEB |
| 2026-08-12 | sow | 0.2.0 | 0.3.0 | Official dual-architecture RPM/DEB downloaded and verified |
| 2026-08-12 | stalwart | 0.16.16 | 0.16.17 | Built as dual-architecture RPM/DEB |
| 2026-08-08 | claude | 2.1.223 | 2.1.226 | Official manifest verified via proxy; dual-arch built |
| 2026-08-08 | codex | 0.146.1 | 0.147.0 | Stable tag rust-v0.147.0; dual-arch built |
| 2026-08-08 | crush | 0.88.0 | 0.88.1 | Official tarballs repacked as 1PGSTY with license |
| 2026-08-08 | grafana | 13.1.2 | 13.1.3 | Official dual-architecture RPM/DEB artifacts |
| 2026-08-08 | opencode | 1.18.14 | 1.18.15 | Built as dual-architecture RPM/DEB |
| 2026-08-08 | postgrest | 14.16 | 16.0 | Static dual-architecture assets; requires PostgreSQL 14+ |
| 2026-08-08 | rainfrog | 0.4.2 | 0.4.3 | Built as dual-architecture RPM/DEB |
| 2026-08-08 | rustfs | 1.0.0-b12 | 1.0.0-rc1 | Upstream rc.1-preview.1; dual-arch RPM/DEB built |
| 2026-08-08 | uv | 0.12.2 | 0.12.3 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | claude | 2.1.222 | 2.1.223 | Official manifest verified via proxy; built |
| 2026-08-07 | codex | 0.146.0 | 0.146.1 | Stable tag rust-v0.146.1; built |
| 2026-08-07 | code | 1.131.0 | 1.132.0 | Official dual-architecture RPM/DEB verified |
| 2026-08-07 | dblab | 0.47.2 | 0.47.4 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | grafana-infinity-ds | 3.11.1 | 3.11.2 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | grafana-victorialogs-ds | 0.30.1 | 0.31.0 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | k3s | 1.36.2 | 1.36.3 | Official stable channel v1.36.3+k3s1; built |
| 2026-08-07 | k3s-images | 1.36.2 | 1.36.3 | Exact-match dual-architecture airgap images; built |
| 2026-08-07 | mcli | 20260804000000 | 20260806000000 | Official pgsty fork dual-architecture RPM/DEB verified |
| 2026-08-07 | opencode | 1.18.13 | 1.18.14 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | pgschema | 1.12.1 | 1.12.2 | Official dual-architecture RPM/DEB verified |
| 2026-08-07 | seaweedfs | 4.40 | 4.41 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | silo | minio 20260804000000 | 20260806000000 | Official replacement; dual-architecture RPM/DEB verified |
| 2026-08-07 | uv | 0.12.1 | 0.12.2 | Built as dual-architecture RPM/DEB |
| 2026-08-07 | victoria-metrics | 1.148.0 | 1.149.0 | Main, cluster, and vmutils packages built for both arches |
| 2026-08-07 | ferretdb2 | 2.7.0 | 2.7.0 | Rebuilt at the current version for dual-architecture RPM/DEB |
| 2026-08-05 | agentsview | 0.39.0 | 0.40.1 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | claude | 2.1.220 | 2.1.222 | Official manifest verified via proxy; built |
| 2026-08-05 | code-server | 4.130.0 | 4.131.0 | Official artifacts downloaded and verified |
| 2026-08-05 | crush | 0.87.0 | 0.88.0 | Official links only; redistribution blocked |
| 2026-08-05 | grafana | 13.1.1 | 13.1.2 | Official artifacts verified; security fix |
| 2026-08-05 | juicefs | 1.4.0 | 1.4.1 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | mcli | 20260417000000 | 20260804000000 | pgsty fork artifacts downloaded and verified |
| 2026-08-05 | minio | 20260618000000 | 20260804000000 | pgsty fork artifacts downloaded and verified |
| 2026-08-05 | mongodb-exporter | 0.51.0 | 0.52.0 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | mtail | 3.0.8 | 3.4.6 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | nodejs | 24.18.1 | 24.19.0 | Node.js 24.x LTS; built |
| 2026-08-05 | opencode | 1.18.9 | 1.18.13 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | pg-hardstorage | 1.0.17 | 1.1.1 | Official artifacts downloaded and verified |
| 2026-08-05 | pgbackrest-exporter | 0.23.0 | 0.24.0 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | pgstream | 1.2.5 | 1.3.1 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | rclone | 1.74.4 | 1.75.0 | Official artifacts downloaded and verified |
| 2026-08-05 | rustfs | 1.0.0-b11 | 1.0.0-b12 | Beta line; built as dual-architecture RPM/DEB |
| 2026-08-05 | stalwart | 0.16.15 | 0.16.16 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | uv | 0.12.0 | 0.12.1 | Built as dual-architecture RPM/DEB |
| 2026-08-05 | vray | 5.51.2 | 5.52.0 | Latest stable; built as dual-architecture RPM/DEB |
| 2026-08-05 | xray | 26.3.27 | 26.7.28 | Latest dated release; built as dual-architecture RPM/DEB |
| 2026-08-05 | prometheus | 3.13.1 | 3.13.2 | Security and stability release |
| 2026-08-05 | pig | 1.6.0 | 1.6.1 | Refreshed extension catalog |
| 2026-07-30 | agentsview | 0.38.1 | 0.39.0 | |
| 2026-07-30 | claude | 2.1.218 | 2.1.220 | |
| 2026-07-30 | cloudflared | 2026.7.2 | 2026.7.3 | |
| 2026-07-30 | code | 1.130.0 | 1.131.0 | |
| 2026-07-30 | code-server | 4.129.0 | 4.130.0 | |
| 2026-07-30 | codex | 0.145.0 | 0.146.0 | Release tag rust-v0.146.0 |
| 2026-07-30 | crush | 0.86.0 | 0.87.0 | |
| 2026-07-30 | dblab | 0.46.0 | 0.47.2 | |
| 2026-07-30 | etcd | 3.7.0 | 3.7.1 | |
| 2026-07-30 | genai-toolbox | 1.7.0 | 1.8.0 | Source build; Rocky 8/9 and Debian 12 verified |
| 2026-07-30 | headscale | 0.29.2 | 0.29.3 | |
| 2026-07-30 | nodejs | 24.18.0 | 24.18.1 | Security release |
| 2026-07-30 | opencode | 1.18.4 | 1.18.9 | |
| 2026-07-30 | pg-exporter | 1.4.0 | 1.4.1 | Official release artifacts |
| 2026-07-30 | pg-hardstorage | 1.0.13 | 1.0.17 | |
| 2026-07-30 | pgschema | 1.12.0 | 1.12.1 | |
| 2026-07-30 | pgstream | 1.2.2 | 1.2.5 | |
| 2026-07-30 | pig | 1.5.1 | 1.6.0 | |
| 2026-07-30 | postgrest | 14.15 | 14.16 | |
| 2026-07-30 | rainfrog | 0.3.20 | 0.4.2 | |
| 2026-07-30 | redis-exporter | 1.87.0 | 1.88.0 | |
| 2026-07-30 | rustfs | 1.0.0-beta.10 | 1.0.0-beta.11 | Preview releases excluded |
| 2026-07-30 | stalwart | 0.16.14 | 0.16.15 | |
| 2026-07-30 | uv | 0.11.31 | 0.12.0 | |
| 2026-07-30 | victoria-traces | 0.9.4 | 0.10.0 | |
| 2026-07-23 | claude | 2.1.215 | 2.1.218 | Verified against the official manifest via proxy |
| 2026-07-23 | codex | 0.144.6 | 0.145.0 | Release tag rust-v0.145.0 |
| 2026-07-23 | dblab | 0.44.1 | 0.46.0 | |
| 2026-07-23 | duckdb | 1.5.4 | 1.5.5 | |
| 2026-07-23 | grafana-infinity-ds | 3.8.0 | 3.11.1 | |
| 2026-07-23 | grafana-victorialogs-ds | 0.30.0 | 0.30.1 | |
| 2026-07-23 | opencode | 1.18.3 | 1.18.4 | |
| 2026-07-23 | pg-timetable | 6.3.0 | 7.0.0 | Major release |
| 2026-07-23 | pgstream | 1.2.0 | 1.2.2 | |
| 2026-07-23 | stalwart | 0.16.13 | 0.16.14 | |
| 2026-07-23 | uv | 0.11.29 | 0.11.31 | |
| 2026-07-23 | grafana | 13.1.0 | 13.1.1 | Direct-download artifacts |
| 2026-07-23 | pg-hardstorage | 1.0.12 | 1.0.13 | Direct-download artifacts |
| 2026-07-23 | crush | 0.85.0 | 0.86.0 | Direct-download artifacts |
| 2026-07-23 | code | 1.129.1 | 1.130.0 | Direct-download artifacts |
| 2026-07-20 | RPM exporter package names | xxx_exporter | xxx-exporter | Renamed underscore-style RPM packages to hyphenated names to match DEB naming |
| 2026-07-20 | pg-exporter | 1.3.0 | 1.4.0 | Repackaged from the upstream Linux tarball |
| 2026-07-20 | victoria-metrics | 1.147.0 | 1.148.0 | VictoriaMetrics main package |
| 2026-07-20 | victoria-metrics-cluster | 1.147.0 | 1.148.0 | VictoriaMetrics companion package |
| 2026-07-20 | vmutils | 1.147.0 | 1.148.0 | VictoriaMetrics companion package |
| 2026-07-20 | victoria-logs | 1.51.0 | 1.52.0 | VictoriaLogs main package |
| 2026-07-20 | vlogscli | 1.51.0 | 1.52.0 | VictoriaLogs companion package |
| 2026-07-20 | vlagent | 1.51.0 | 1.52.0 | VictoriaLogs companion package |
| 2026-07-20 | grafana-victorialogs-ds | 0.29.0 | 0.30.0 | |
| 2026-07-20 | seaweedfs | 4.39 | 4.40 | |
| 2026-07-20 | rustfs | 1.0.0-b9 | 1.0.0-b10 | Prerelease line; preview releases excluded |
| 2026-07-20 | sabiql | 1.14.0 | 1.15.1 | |
| 2026-07-20 | timescaledb-tools | 0.19.0-1 | 0.19.0-2 | Bundles timescaledb-parallel-copy 0.13.0 |
| 2026-07-20 | claude | 2.1.211 | 2.1.215 | Downloaded through the 8118 proxy and verified |
| 2026-07-20 | codex | 0.144.4 | 0.144.6 | Release tag rust-v0.144.6 |
| 2026-07-20 | genai-toolbox | 1.6.0 | 1.7.0 | External build from official GCS binary and arm64 container artifact |
| 2026-07-20 | opencode | 1.18.2 | 1.18.3 | |
| 2026-07-20 | pg-hardstorage | 1.0.10 | 1.0.12 | Direct-download artifacts |
| 2026-07-20 | code | 1.129.0 | 1.129.1 | Direct-download artifacts |
| 2026-07-20 | code-server | 4.128.0 | 4.129.0 | Direct-download artifacts |
| 2026-07-20 | pev2 | 1.22.0 | 1.23.0 | Noarch package |
| 2026-07-20 | k3s | - | 1.36.2 | Upstream v1.36.2+k3s1; amd64 and arm64 |
| 2026-07-20 | k3s-images | - | 1.36.2 | Exact-match system image package for both architectures |
| 2026-07-16 | jmx-exporter | - | 1.6.0 | New noarch package |
| 2026-07-16 | node_exporter | 1.11.1 | 1.12.1 | |
| 2026-07-16 | redis_exporter | 1.86.0 | 1.87.0 | |
| 2026-07-16 | etcd | 3.6.13 | 3.7.0 | |
| 2026-07-16 | dblab | 0.43.0 | 0.44.1 | |
| 2026-07-16 | pgstream | 1.1.1 | 1.2.0 | |
| 2026-07-16 | rainfrog | 0.3.19 | 0.3.20 | |
| 2026-07-16 | rustfs | 1.0.0-b8 | 1.0.0-b9 | Prerelease line |
| 2026-07-16 | agentsview | 0.37.5 | 0.38.1 | |
| 2026-07-16 | claude | 2.1.206 | 2.1.211 | Downloaded through the 8118 proxy and verified |
| 2026-07-16 | codex | 0.144.1 | 0.144.4 | Release tag rust-v0.144.4 |
| 2026-07-16 | stalwart | 0.16.12 | 0.16.13 | |
| 2026-07-16 | npgsqlrest | 3.20.0 | 3.21.0 | |
| 2026-07-16 | postgrest | 14.14 | 14.15 | |
| 2026-07-16 | opencode | 1.17.18 | 1.18.2 | |
| 2026-07-16 | uv | 0.11.28 | 0.11.29 | |
| 2026-07-16 | vector | 0.56.0 | 0.57.0 | Direct-download artifacts |
| 2026-07-16 | pg-hardstorage | 1.0.8 | 1.0.10 | Direct-download artifacts |
| 2026-07-16 | crush | 0.84.0 | 0.85.0 | Direct-download artifacts |
| 2026-07-16 | code | 1.128.0 | 1.129.0 | Direct-download artifacts |
| 2026-07-16 | code-server | 4.127.0 | 4.128.0 | Direct-download artifacts |
| 2026-07-16 | cloudflared | 2026.7.1 | 2026.7.2 | Direct-download artifacts |
Compatibility Changes and Upgrade Notes
- Existing FERRET deployments should remove the legacy
ferretdbsystemd service. Redeploy the protocol layer withdocker.ymlandapp.yml. This release removes the oldmongo.ymlplaybook,mongo_*parameters, scrape job, and dedicated dashboard. - Pigsty no longer renders
/etc/default/haproxyfor the HAProxy unit. The unit can still read this file when present. Use onlyEXTRAOPTSfor process arguments, notOPTIONS. AnyEXTRAOPTSoverride must retain-S /run/haproxy-master.sockand must not include-f. - New module playbooks require each target host to define its
pg_cluster,redis_cluster,minio_cluster,kafka_cluster, ormysql_clusterexplicitly. If a custom inventory uses fixed group names without these identity variables, add the variables first. - The MINIO role accepts only
minio_type: silo. Valuesminioandrustfsfail identity validation. Silo retains MinIO protocol and disk-format compatibility, but package, binary, and systemd service names change. Back up existing object storage before upgrading. Validate in-place compatibility and rollback before upgrading. Package replacement alone does not establish migration acceptance. - Valkey remains optional.
redis_type: valkeyinstallsvalkey-serverandvalkey-cli. Configuration paths, service names, monitoring jobs, and other module interfaces remain underredisfor compatibility. - Pigsty core REPO/CACHE roles require SOW. They use
sow create --pigstyto generate local repositories. Older offline bundles or local repositories without SOW 0.3.0 must first install or update it from the Pigsty INFRA repository.pig repo createis a separate CLI operation. Its fallback behavior depends on the CLI version. - MySQL
mysql_databasesentries accept onlyname,encoding, andcollate. Pigsty creates databases withDEFAULT ENCRYPTION='N'.mysql_parameterscannot bypass protection for platform-owned, replication, or TLS options throughloose_,skip_,disable_, orenable_prefixes. - Custom RPM repositories and external automation must replace underscore package names with hyphenated names. For example, replace
node_exporterandredis_exporterwithnode-exporterandredis-exporter. docker/Makefileno longer acceptsDATAto redirect the cleanup target.make purgeimmediately deletes repository-local./data, without a countdown. Preserve required data first.- New
ha/triodeployments use a three-node Silo pool with one data disk per node and EC:1. An existing single-node pool cannot be expanded directly into this topology; create a new pool and migrate the objects. - KAFKA and MYSQL remain pilot modules. Kafka clients must resolve and reach each broker directly. Do not put the data plane behind HAProxy, a VIP, or an L4 load balancer. MySQL currently accepts exactly one or three members.
GitHub publishes all 14 validated offline artifacts for this release, one per recommended OS version and architecture. A checksums manifest accompanies them. Each file has a detached PGP signature (.asc).
Checksums
v4.4.0
Pigsty v4.4.0 is a maintenance release with PostgreSQL 18.4 and PostgreSQL 19 beta support. It includes 531 extensions, updated kernel variants, and broader platform coverage.
Released on 2026-07-10. See the GitHub release and all changes since v4.3.0.
Highlights
- PostgreSQL 18.4 / 19 beta: PostgreSQL 18.4 is now the production default, with a minimal PostgreSQL 19 beta template for evaluation.
- 531 extensions and refreshed kernels: The catalog adds 21 extensions and updates major PostgreSQL variants across the supported platform matrix.
- Safer operations with Pig 1.5.1: Adds clone, fork, and PITR workflows. Also adds automatic VIP discovery, Zstandard pgBackRest compression, and dedicated Patroni log collection.
- Security, applications, and tooling: Improves secret handling and repository automation. Adds app templates, a redesigned portal, and optional Codex support.
- Platform validation: All 14 offline deployment tests pass across seven OS baselines on both
x86_64andaarch64. - Offline artifacts: The Community Edition publishes six dual-architecture offline packages for Debian 13, EL 10, and Ubuntu 24.04 on GitHub. Prebuilt packages for the other validated baselines are available with the Professional Edition.
Upgrade Notes
- Generated pgBackRest configurations now use
compress-type=zst. Before rendering them again, preserve any intentional local overrides. #744 - Patroni logs now use
/pg/log/patroniandjob=patroni. Update custom log queries and alert rules that use the old syslog selector. - VIP interfaces now default to
auto. dnsmasq records move to/etc/dnsmasq.d/pigsty, and Pigsty manages/etc/default/haproxy. Preserve explicit network overrides where needed. - The default etcd backend quota drops from 16 GiB to 8 GiB. Check existing backend usage before applying the new configuration.
pigautomation must use-y/--yesfor destructive commands.pig pb restoreandpig pitrrequire one explicit recovery target. See thepigv1.5 notes.- Supabase analytics moves to the
_supabasedatabase and_analyticsschema. Existing deployments should create them before switching stacks.
Security and Operations
- The
pg-pitrwrapper adds safer target selection, timelines, dry runs, and stronger checks against unsafe recovery targets. - Ansible output hides application secrets. Generated
.envfiles use mode0600. Grafana no longer prints the administrator password. - The
dbsusudo policy adds controlled journal access. The repository adds a security policy, CodeQL, Dependabot, pinned actions, and release-signing automation.
Applications and Tooling
- Added Immich, Maybe, and JumpServer templates; refreshed Supabase, Dify, InsForge, Registry, Jupyter, Kong, Odoo, Teable, Mattermost, and related launch helpers.
- Rebuilt the bilingual infrastructure portal. Added optional Codex CLI support to the experimental VIBE module. Claude Code remains its default managed coding agent.
- Removed the legacy FerretDB Compose template; the FERRET module remains available.
Bug Fixes
- Fixed EL10 PostgreSQL/libpq provider conflicts, EPEL path handling, and PGDG minor-version repository rules. #752
- Reused an existing
/wwwdirectory during bootstrap and fixed Redis Sentinel HA password rendering. #753 #748 - Corrected RPM naming and package groups for
pg_http,pg_gzip,apache-age, andodbc_fdw. #750 - Prevented unexpected service starts during Debian and Ubuntu package installation, and improved EL9 aarch64 Patroni package handling.
- Fixed VirtualBox private-network routing and default NIC selection.
- Fixed shell portability and Vector log lifecycle issues, along with PG19
io_workers, Teable HBA, and application runtime defaults.
PostgreSQL and Extension Package Changes
The release adds 21 extensions and updates the PostgreSQL 18.4 package graph. It introduces a PostgreSQL 19 beta template and updates major kernel variants. The versions below were verified against final repository metadata and the v4.4.0 artifacts where bundled. PG major ranges describe catalog and repository coverage.
PostgreSQL RPM changes · PostgreSQL DEB changes · Infrastructure package changes
| Package | Old Version | New Version | Notes |
|---|---|---|---|
polardb-17 | 17.9.1.0 | 17.10.1.0 | PG 17; RPM added |
agensgraph-17 | 2.16.0 | 2.17.0 | PG 17.10 |
openhalodb-14 | 1.0-beta | 1.0-2 | OpenHaloDB |
babelfish-17 | 5.4.0 | 5.4.0 | PG 17.7; rebuild |
babelfish-18 | - | 6.0.0 | PG 18.3 |
pgedge | 17.9 / 18.3 | 15.18 / 16.14 / 17.10 / 18.4 | PG 15/16 added; PG 17/18 updated; Spock 5.0.10 |
ivorysql-18 | 5.0 | 5.4 | PG 18; RPM added |
cloudberry | 2.1.0-1 | 2.1.0-2 / 2.1.0-3 | DEB/RPM rebuild; RPM path /usr/cloudberry |
cloudberry-backup | 2.1.0-1 | 2.1.0-2 / 2.1.0-3 | backup subpackage |
cloudberry-pxf | 2.1.0-1 | 2.1.0-2 / 2.1.0-3 | PXF subpackage |
pg_ducklake | - | 1.0.0 | PG 14-18 |
psql_bm25s | - | 0.4.13 | BM25 retrieval; PG 17-18 |
mongo_fdw | 5.5.3 | 5.5.3 | new DEB packaging; existing PGDG RPM, PG 14-18 |
multicorn | 3.2 | 3.2 | new DEB packaging; existing PGDG RPM, PG 14-18 |
pg_orca | - | 1.0.0 | PG 18 only |
pg_sorted_heap | - | 0.14.0 | PG 16-18 |
pg_stl | - | 1.0.0 | PG 16-18 |
fsm_core | - | 1.1.0 | PG 15-18 |
pg_projection | - | 1.0.0 | PG 14-18 |
graph | - | 0.1.7 | PG 14-18 |
jsonschema | - | 0.1.9 | PG 14-18 |
pg_durable | - | 0.2.2 | PG 14-18 |
pg_stat_log | - | 0.1 | PG 18 only |
pg_stat_plans | - | 2.1.0 | PG 16-18 |
pg_task | 1.0.0 | 2.1.29 | PG 14-18, pcre2grep fix |
pg_stat_backtrace | - | 1.0.0 | PG 14-18; libunwind |
pg_mockable | - | 1.1.0 | PG 14-18 |
db2fce | - | 0.0.17 | PG 14-18 |
pg_uuid_v8 | - | 1.0.0 | PG 14-18 |
pg_extra_time | 2.0.0 | 2.1.0 | PG 14-18 |
pg_pinyin | 0.0.2 | 0.0.4 | PG 14-18 |
passwordpolicy | - | 2.0.5 | PG 14-18 |
pgdisablelogerror | - | 1.0 | PG 14-18 |
plpgsql_wrap | - | 1.0 | PG 14-18 |
timescaledb | 2.26.4 | 2.28.2 | PG 15-18 |
documentdb | 0.110 | 0.113 | PG 15-18 |
citus | 14.0.0-4 | 14.1.0 | PG 16-18 |
pgvector | 0.8.2 | 0.8.4 | PG 14-18 |
orioledb | 1.7-beta15 | 1.8-beta16 | Build for PG 16, 17, 18 |
pg_search | 0.23.1 | 0.24.0 | PG 15-18 |
pg_textsearch | 1.1.0 | 1.2.0 | BM25 full-text search, PG 17-18 |
storage_engine | 1.3.4 | 2.4.0 | PGXN 2.x bump, PG 15-18 |
pg_clickhouse | 0.2.0 | 0.3.2 | PGXN bump, ClickHouse integration |
provsql | 1.2.3 | 1.10.0 | PGXN bump, PG 14-18 |
pgclone | 4.0.0 | 4.3.2 | PGXN bump, PG 14-18 |
biscuit | 2.2.2 | 2.4.0 DEB / 2.4.1 RPM | PG 16-18 |
pgmnemo | 0.7.2 | 0.12.1 | PG 14-18 |
rdf_fdw | 2.5.0 | 2.6.0 | PG 14-18, libcurl compatibility patch |
roaringbitmap | 1.1.0 | 1.2.0-2 | PG 14-18, llvm-lto packaging fix |
plpgsql_check | 2.9.0 | 2.9.2 | PG 14-18 |
timescaledb_toolkit | 1.22.0 | 1.23.0 | PG 15-18, pgrx 0.18.1 |
wrappers | 0.6.0 | 0.6.1 | PG 14-18, pgrx 0.18.1 |
pgrdf | 0.5.0 | 0.6.4 | PG 14-17, pgrx 0.18.1 |
pg_graphql | 1.5.12 | 1.6.1 | PG 14-18, pgrx 0.18.1 |
pg_anon | 3.0.13 | 3.1.1 | PG 14-18, pgrx 0.18.1 |
pg_kazsearch | 2.0.0 | 2.2.0 | PG 16-18, pgrx 0.18.1 |
pg_session_jwt | 0.4.0 | 0.5.0 | PG 14-18, pgrx 0.18.1 |
pg_tzf | 0.2.4 | 0.3.0 | PG 14-18, pgrx 0.18.1 |
pg_vectorize | 0.26.1 | 0.26.2 | PG 14-18, pgrx 0.18.1 |
pglinter | 1.1.2 | 2.0.0 | PG 14-18, pgrx 0.18.1 |
pgmqtt | 0.1.0 | 0.3.0 | PG 14-18, pgrx 0.18.1 |
etcd_fdw | 0.0.0 | 0.0.1 | PG 14-18, pgrx 0.18.1 |
pg_http | 1.7.0 | 1.7.1 | PG 14-18, RPM rename to pgsql_http_$v |
pg_gzip | 1.0.0 | 1.1.0 | PG 14-18, RPM rename to pgsql_gzip_$v |
age | 1.7.0 | 1.7.0 | PG 17-18, RPM rename to age_$v |
pg_trickle | 0.40.0 | 0.81.0 | PG 18 only |
re2 | 0.1.1 | 0.4.0 | PG 16-18 |
pg_background | 1.9.2 | 2.0.2 DEB / 2.0 RPM | PG 14-18 |
firebird_fdw | 1.4.1 | 1.4.2 | PG 14-18 |
pg_net | 0.20.2 | 0.20.3 | DEB + EL10 RPM; EL8/9 RPM stays on 0.9.2 |
pg_dirtyread | 2.7 | 2.8 | PG 14-18 |
pg_stat_ch | 0.3.6 | 0.3.6 | PG 16-18, rebuild |
pggraph | 0.1.5 | 0.1.7 | PG 14-18 |
pgsql_tweaks | 1.0.2 | 1.0.5 | PG 14-18; PGDG RPM also carries 1.0.3 |
pgfincore | 1.3.1 | 1.4.0 | PG 14-18 |
toastinfo | 1.5 | 1.7 | PG 14-18 |
pg_ivm | 1.14 | 1.15 DEB / 1.14 RPM | PG 14-18 |
timeseries | 0.2.0 | 0.2.1 | PG 14-18 |
Infrastructure Package Changes
| Package | Old Version | New Version | Notes |
|---|---|---|---|
pig | 1.4.1 | 1.5.1 | |
pg_exporter | 1.2.2 | 1.3.0 | |
pgschema | 1.9.0 | 1.12.0 | |
pgstream | 1.0.1 | 1.1.1 | |
pg-hardstorage | - | 1.0.8 | |
codex | 0.125.0 | 0.144.1 | |
claude | 2.1.123 | 2.1.206 | |
opencode | 1.14.30 | 1.17.18 | |
agentsview | 0.26.0 | 0.37.5 | |
genai-toolbox | 1.1.0 | 1.6.0 | packaged as mcp-toolbox |
crush | 0.64.0 | 0.84.0 | |
code | 1.118.1 | 1.128.0 | |
code-server | 4.117.0 | 4.127.0 | |
victoria-metrics | 1.142.0 | 1.147.0 | |
victoria-metrics-cluster | 1.142.0 | 1.147.0 | |
vmutils | 1.142.0 | 1.147.0 | |
victoria-logs | 1.50.0 | 1.51.0 | |
vlagent | 1.50.0 | 1.51.0 | |
vlogscli | 1.50.0 | 1.51.0 | |
victoria-traces | 0.8.2 | 0.9.4 | |
prometheus | 3.11.3 | 3.13.1 | |
alertmanager | 0.32.1 | 0.33.1 | |
pushgateway | 1.11.2 | 1.11.3 | |
node_exporter | 1.11.1 | 1.11.1 | tarball cache; version metadata fix |
redis_exporter | 1.82.0 | 1.86.0 | |
mongodb_exporter | 0.50.0 | 0.51.0 | |
grafana | 13.0.1 | 13.1.0 | |
grafana-victorialogs-ds | 0.26.3 | 0.29.0 | |
grafana-victoriametrics-ds | 0.24.0 | 0.25.2 | |
vector | 0.55.0 | 0.56.0 | |
minio | 20260417000000 | 20260618000000 | |
seaweedfs | 4.22 | 4.39 | |
rustfs | 1.0.0-b1 | 1.0.0-b8 | prerelease line |
duckdb | 1.5.2 | 1.5.4 | |
kafka | 4.2.0 | 4.3.1 | |
etcd | 3.6.10 | 3.6.13 | |
restic | 0.18.1 | 0.19.1 | |
juicefs | 1.3.1 | 1.4.0 | |
tigerbeetle | 0.17.2 | 0.17.9 | |
tigerfs | 0.6.0 | 0.7.0 | |
caddy | 2.11.2 | 2.11.4 | |
cloudflared | 2026.2.0 | 2026.7.1 | |
headscale | 0.28.0 | 0.29.2 | |
v2ray | 5.48.0 | 5.51.2 | |
nodejs | 24.15.0 | 24.18.0 | |
golang | 1.26.2 | 1.26.5 | |
hugo | 0.161.1 | 0.164.0 | |
uv | 0.11.8 | 0.11.28 | |
rclone | 1.73.5 | 1.74.4 | |
asciinema | 3.2.0 | 3.2.1 | |
stalwart | 0.16.2 | 0.16.12 | |
maddy | 0.9.3 | 0.9.5 | |
dblab | 0.38.0 | 0.43.0 | |
npgsqlrest | 3.12.0 | 3.20.0 | |
postgrest | 14.10 | 14.14 | |
sabiql | 1.11.1 | 1.14.0 | |
pev2 | 1.21.0 | 1.22.0 | |
rainfrog | 0.3.18 | 0.3.19 |
The MD5 list below covers all 14 validated artifacts. GitHub publishes six Community Edition artifacts. The Professional Edition provides the remaining eight. GitHub records SHA-256 digests for the uploaded Community Edition artifacts.
Checksums
v4.3.0
Highlights
- Added about 50 PostgreSQL extensions, bringing the total available extension count to 510.
- Added Ubuntu 26.04 x86_64/arm64 support and deprecated Ubuntu 20.04 support. Updated OS minor versions to Debian 13.4 / Ubuntu 24.04.4.
- Kernel updates: Supabase is updated to the latest version, pgEdge to PG 18, and PolarDB to PG 17.
- Grafana is updated to 13.0.1, and MinIO now uses the pgsty branch with CVE fixes.
- Vagrant templates now consistently use cloud-image series images.
Bug Fixes
- Relaxed PostgreSQL username validation to allow
@.-in usernames. - Fixed IPv6 nameserver parsing so DNS configuration is not limited to legacy IPv4 DNS server extraction.
- Changed the VictoriaTraces Grafana datasource path to
/select/jaeger. - Made Vagrant disk probing more robust and added
bin/el-fix, a guest-network fix script for EL Vagrant images.
PostgreSQL and Extension Package Changes
| Package | Old Version | New Version | Notes |
|---|---|---|---|
block_copy_command | - | 0.1.5 | New; PG 14-18; Rust/pgrx 0.17.0 |
cloudberry | 2.0.0 | 2.1.0 | Kernel package group; RPM release 2 fixes initdb errno issue |
cloudberry-backup | - | 2.1.0 | New Cloudberry backup tool package |
cloudberry-pxf | - | 2.1.0 | New Cloudberry PXF package |
credcheck | 4.6 | 4.7 | Upgrade; PG 14-18; PGDG |
datasketches | - | 1.7.0 | New; PG 14-18 |
ddl_historization | 0.0.7 | 0.2 | Upgrade |
documentdb | 0.109 | 0.110 | Upgraded to upstream version; PG 15-18 |
external_file | - | 1.2 | New; PG 14-18 |
logical_ddl | - | 0.1.0 | New; PG 14-18 |
nominatim_fdw | 1.1.0 | 1.2 | Upgrade |
onesparse | - | 1.0.0 | New; PG 18 only |
orioledb | beta15 1.7 | beta15 1.7 | Paired with OriolePG 17.18 |
oriolepg | 17.16 | 17.18 | Kernel patch set update |
parray_gin | - | 1.5.0 | Added, then upgraded; PG 14-18 |
pg_accumulator | - | 1.1.3 | New; PG 14-18 |
pg_anon | 3.0.1 | 3.0.13 | Upgrade; Rust/pgrx 0.16.1 -> 0.17.0 |
pg_background | 1.8 | 1.9.2 | DEB only |
pg_bikram_sambat | - | 0.1.0 | New; Bikram Sambat date type and AD/BS conversion functions |
pg_byteamagic | - | 0.2.4 | New; PG 14-18 |
pg_cardano | 1.1.1 | 1.2.0 | Upgrade; Rust/pgrx 0.17.0 |
pg_clickhouse | 0.1.5 | 0.2.0 | Upgrade |
pg_datasentinel | - | 1.0 | New; PG 15-18 |
pg_dbms_job | 1.5 | 2.0 | Upgrade; PG 14-18; PGDG |
pg_dispatch | - | 0.1.5 | New; PG 14-18 |
pg_failover_slots | 1.2.0 | 1.2.1 | Upgrade |
pg_fsql | - | 1.1.0 | New; PG 14-18 |
pg_incremental | 1.4.1 | 1.5.0 | Upgrade |
pg_isok | - | 1.4.1 | New; PG 14-18 |
pg_ivm | 1.13 | 1.14 | Upgrade; PG 14-18 |
pg_kazsearch | - | 2.0.0 | New; PG 16-18; Rust/pgrx 0.17.0 |
pg_liquid | - | 0.1.7 | New; PG 14-18 |
pg_pathcheck | - | 0.9.1 | New; PG 17-18; requires shared_preload_libraries |
pg_query_rewrite | - | 0.0.5 | New; PG 14-18 |
pg_regresql | - | 2.0.0 | New; PG 14-18 |
pg_rrf | - | 0.0.3 | New; PG 14-17; Rust/pgrx 0.16.1 -> 0.17.0 |
pg_savior | 0.0.1 | 0.1.0 | Upgrade; high-risk DDL/DML guard hook; requires preload or LOAD |
pg_search | 0.22.2 | 0.23.1 | Upgrade; PG 15-18; pgrx 0.18.0 |
pg_slug_gen | - | 1.0.0 | New; PG 15-18 |
pg_stat_ch | - | 0.3.6 | Added, then upgraded; PG 16-18; EL8 break |
pg_store_plans | 1.9 | 1.10 | Upgrade |
pg_strict | 1.0.3 | 1.0.5 | Upgrade; Rust/pgrx 0.16.1 -> 0.17.0 |
pg_text_semver | - | 1.2.1 | New; PG 14-18 |
pg_textsearch | 0.5.0 | 1.1.0 | Upgrade; PG 17-18; requires shared_preload_libraries |
pg_trickle | 0.16.0 | 0.40.0 | Upgrade; PG 18 only; pgrx 0.18.0 |
pg_tzf | 0.2.3 | 0.2.4 | Upgrade; Rust/pgrx 0.17.0 |
pg_vectorize | 0.26.0 | 0.26.1 | Upgrade; Rust/pgrx 0.16.1 -> 0.17.0 |
pg_variables | - | 1.2.5 | New; PG 14-18 |
pg_when | - | 0.1.9 | New; PG 14-18; Rust/pgrx 0.17.0 |
pgxicor | 0.1.0 | 0.1.1 | Upgrade |
pgcalendar | - | 1.1.0 | New; PG 14-18 |
pgclone | - | 4.0.0 | Added, then upgraded; PG 14-18 |
pgelog | - | 1.0.2 | New; PG 14-18 |
pglinter | 1.1.1 | 1.1.2 | Upgrade; Rust/pgrx 0.16.1 -> 0.17.0 |
pglock | - | 1.0.0 | New; PG 14-18 |
pgmq | 1.11.0 | 1.11.1 | Upgrade; PG 14-18 |
pgmqtt | - | 0.1.0 | New; PG 14-18; Rust/pgrx 0.16.1 -> 0.17.0 |
pgproto | - | 0.5.0 | Added, then upgraded; native Protobuf support |
pghydro | - | 6.6 | New; PG 14-18 |
pgx_ulid | 0.2.2 | 0.2.3 | Upgrade; Rust/pgrx 0.17.0 |
plv8 | 3.2.4 | 3.2.4-2 | RPM only; EL10 build fix |
PolarDB | 15.15 | 17.9.1.0 | PG 15 -> 17 |
postgresbson | - | 2.0.2 | New; PG 14-18 |
postgis | 3.6.2 | 3.6.3 | DEB only |
prefix | 1.2.10 | 1.2.11 | Upgrade; PG 14-18; PGDG |
provsql | - | 1.2.3 | New; PG 14-18 |
rdf_fdw | - | 2.5.0 | Added, then upgraded; PG 14-18 |
rdkit | - | 202503.6 | New; PG 14-18 |
re2 | - | 0.1.1 | New; PG 16-18 |
storage_engine | - | 1.3.4 | Added, then upgraded; columnar and row-compression table access methods |
supautils | 3.1.0 | 3.2.1 | Upgrade |
system_stats | 3.2 | 4.0 | Upgrade |
timescaledb | 2.25.2 | 2.26.4 | Upgrade; TSL minor update |
ulak | - | 0.0.2 | New; PG 14-18 |
wrappers | 0.5.7 | 0.6.0 | Upgrade; Rust/pgrx 0.16.1 -> 0.17.0 |
Infrastructure Package Updates
| Package | Old Version | New Version | Notes |
|---|---|---|---|
alertmanager | 0.31.1 | 0.32.1 | |
agentsview | 0.15.0 | 0.26.0 | |
claude | 2.1.81 | 2.1.123 | Downloaded through the 8118 proxy and verified |
code | 1.112.0 | 1.118.1 | Direct-link metadata update |
code-server | 4.112.0 | 4.117.0 | Direct-link metadata update |
codex | 0.116.0 | 0.125.0 | Moved from prerelease track to stable, then upgraded further |
crush | 0.51.2 | 0.64.0 | Direct-link metadata update |
dblab | 0.34.3 | 0.38.0 | |
duckdb | 1.5.0 | 1.5.2 | |
etcd | 3.6.9 | 3.6.10 | Unified package version |
garage | 2.2.0 | 2.3.0 | |
genai-toolbox | 0.27.0 | 1.1.0 | Upstream renamed to mcp-toolbox |
golang | 1.26.1 | 1.26.2 | |
grafana | 12.4.1 | 13.0.1 | Metadata refreshed after major upgrade |
grafana-infinity-ds | 3.7.4 | 3.8.0 | |
grafana-plugins | 12.3.0 | 13.0.0 | Noarch plugin bundle, manually collected |
grafana-victoriametrics-ds | 0.23.1 | 0.24.0 | |
hugo | 0.158.0 | 0.161.1 | |
maddy | 0.8.2 | 0.9.3 | |
mcli | 20260321000000 | 20260417000000 | pgsty branch, CVE fixed |
minio | 20260325000000 | 20260417000000 | pgsty branch, CVE fixed |
mongodb_exporter | 0.49.0 | 0.50.0 | |
node_exporter | 1.10.2 | 1.11.1 | |
nodejs | 24.14.0 | 24.15.0 | Stays on the 24.x policy line |
npgsqlrest | 3.11.1 | 3.12.0 | |
opencode | 1.2.27 | 1.14.30 | Switched to versioned cache and rebuilt |
pg_exporter | 1.2.1 | 1.2.2 | Direct-link metadata update |
pgflo | 0.0.15 | - | Removed |
pgschema | 1.7.4 | 1.9.0 | |
pig | 1.3.2 | 1.4.1 | Metadata only |
postgrest | 14.7 | 14.10 | |
prometheus | 3.10.0 | 3.11.3 | |
rainfrog | 0.3.17 | 0.3.18 | |
rclone | 1.73.2 | 1.73.5 | Direct-link metadata update |
rustfs | 1.0.0-alpha.89 | 1.0.0-b1 | Prerelease line |
sabiql | 1.8.2 | 1.11.1 | |
seaweedfs | 4.17 | 4.22 | |
sqlcmd | 1.9.0 | 1.10.0 | |
stalwart | 0.15.5 | 0.16.2 | |
tigerbeetle | 0.16.77 | 0.17.2 | |
tigerfs | 0.5.0 | 0.6.0 | |
timescaledb-tools | 0.18.2 | 0.19.0 | Rebuilt timescaledb-tune |
uv | 0.10.12 | 0.11.8 | |
victoria-logs | 1.48.0 | 1.50.0 | Main package |
victoria-metrics | 1.138.0 | 1.142.0 | |
victoria-metrics-cluster | 1.138.0 | 1.142.0 | VictoriaMetrics companion component |
victoria-traces | 0.8.0 | 0.8.2 | |
vip-manager | 4.0.0 | 4.2.0 | Direct-link metadata update |
vlagent | 1.48.0 | 1.50.0 | VictoriaLogs companion component |
vlogscli | 1.48.0 | 1.50.0 | VictoriaLogs companion component |
vmutils | 1.138.0 | 1.142.0 | VictoriaMetrics companion component |
vector | 0.54.0 | 0.55.0 | Direct-link metadata update |
v2ray | 5.47.0 | 5.48.0 | |
xray | 26.2.6 | 26.3.27 |
Checksums
v4.2.2
Highlights
- Insforge 2.0.1 self-hosted template
- Batch infra package updates, MinIO/MCLI updated to 20260321
- New infra packages: tigerfs, pgstream, sql-studio, rainfog, crush
- New PG tools: data recovery pdu, connection pooler pgdog
- Update PG extensions: pg_search, pgsentinel, pg_track_optimizer, pgcollection, pg_ttl_index, pg_clickhouse
- Update PG Kernel: ivorysql 5.1 -> 5.3
PostgreSQL Package Updates
| Name | Old Ver | New Ver | Note |
|---|---|---|---|
| pg_search | 0.21.12 | 0.22.2 | |
| pgsentinel | 1.4.0 | 1.4.1 | rpm only |
| pg_track_optimizer | 0.9.1 | 0.9.2 | |
| pgcollection | 1.0.0 | 2.0.0 | |
| pg_ttl_index | 2.0.0 | 3.0.0 | |
| pg_clickhouse | 0.1.4 | 0.1.5 | |
| pdu | 3.0.25.12 | new | |
| pgdog | 0.1.32 | new |
Infrastructure Package Updates
| Name | Old Ver | New Ver | Note |
|---|---|---|---|
grafana | 12.4.0 | 12.4.1 | |
pgbackrest_exporter | 0.22.0 | 0.23.0 | |
redis_exporter | 1.81.0 | 1.82.0 | |
victoria-logs | 1.47.0 | 1.48.0 | |
vlagent | 1.47.0 | 1.48.0 | |
vlogscli | 1.47.0 | 1.48.0 | |
victoria-traces | 0.7.1 | 0.8.0 | |
duckdb | 1.4.4 | 1.5.0 | |
pg_timetable | 6.2.0 | 6.3.0 | |
pgschema | 1.4.2 | 1.7.4 | |
pgstream | - | 1.0.1 | new |
tigerbeetle | 0.16.75 | 0.16.77 | |
grafana-victorialogs-ds | 0.26.2 | 0.26.3 | |
grafana-infinity-ds | 3.7.3 | 3.7.4 | |
caddy | 2.11.1 | 2.11.2 | |
npgsqlrest | 3.10.0 | 3.11.1 | |
postgrest | 14.5 | 14.7 | |
opencode | 1.2.17 | 1.2.27 | |
pev2 | 1.20.2 | 1.21.0 | |
golang | 1.26.0 | 1.26.1 | |
vector | 0.53.0 | 0.54.0 | |
rclone | 1.73.1 | 1.73.2 | |
code-server | 4.109.5 | 4.112.0 | |
code | 1.109.4 | 1.112.0 | |
seaweedfs | 4.15 | 4.17 | |
uv | 0.10.8 | 0.10.12 | |
codex | 0.110.0 | 0.116.0 | |
v2ray | 5.44.1 | 5.47.0 | |
sabiql | 1.6.2 | 1.8.2 | |
sql-studio | - | 0.1.51 | new |
rainfrog | - | 0.3.17 | new |
agentsview | 0.10.0 | 0.15.0 | |
crush | - | 0.51.2 | new |
tigerfs | - | 0.5.0 | new |
victoria-metrics | 1.137.0 | 1.138.0 | |
victoria-metrics-cluster | 1.137.0 | 1.138.0 | |
vmutils | 1.137.0 | 1.138.0 | |
hugo | 0.157.0 | 0.158.0 | |
rustfs | 1.0.0-alpha.85 | 1.0.0-alpha.89 | |
mysqld_exporter | 0.18.0 | 0.19.0 | |
pg_exporter | 1.2.0 | 1.2.1 | |
pig | 1.3.1 | 1.3.2 | |
minio | 20260214 | 20260321 | |
mcli | 20260213 | 20260321 | |
claude | 2.1.68 | 2.1.81 | |
ivroysql | 5.1 | 5.3 |
Checksums
v4.2.1
This maintenance release adds 3 extensions.
Major Changes
- New Extensions: Added
pg_eviltransformto the GIS package group,pg_pinyinto FTS, andpg_qosto admin. All three support PG 14–18. - PG13 Removed: Removed all
pgdg13andpgdg13-nonfreerepository entries and PG13 package aliases (pg13-*). This affects every platform variant: EL7/8/9/10, Debian 12/13, and Ubuntu 22/24/26, on both x86_64 and aarch64. - Config templates (
fat.yml,pro.yml,dev.yml,el.yml,debian.yml) no longer reference PG13 packages or repos. Extension version comments are updated to reflect PG 14–18 coverage only. - Percona Repo: Origin URL updated from
ppg-18.1toppg-18.3to track the latest Percona PostgreSQL distribution. - Nginx Repo: Module tag for the Nginx upstream APT repo corrected from
infratonginxon Debian/Ubuntu platforms. - UV Venv Fix:
roles/node/tasks/pkg.ymlchecks for an existing virtualenv before runninguv venv. This prevents unnecessary re-creation and potential errors during repeat provisioning. - Docker Image:
lessis added to the Pigsty Docker image base packages. - Demo Config: Default firewall rules in
el.ymlanddebian.ymldemo configs now include port5432for direct PostgreSQL access.
Compatibility Notes
PostgreSQL 13 reached its end of life on 2025-11-13. The PGDG YUM repository has archived and removed the pg13 / pg12 directories. If you install Pigsty on EL systems (even without using PG 13), repo access failures may cause installation or update errors.
Upgrade directly to Pigsty v4.2.1, or remove the pg13 repository line manually. To remove it, edit repo_upstream_default in the file for your OS under roles/node_id/vars/.
EL8 remains a compatible Pigsty OS. Starting with this release, Pigsty no longer publishes offline packages for EL8.
This release has no other breaking API or configuration changes.
7 commits, 84 files changed, +4,925 / -5,351 lines (v4.2.0..v4.2.1, 2026-03-04 ~ 2026-03-06)
PostgreSQL Package Updates
| Package | Old Version | New Version | Notes |
|---|---|---|---|
| timescaledb | 2.25.1 | 2.25.2 | |
| vchord | 1.1.0 | 1.1.1 | Added clang build dependency, bug fixes |
| vchord_bm25 | 0.3.0-1 | 0.3.0-2 | Fix the CI version injection issue |
| aggs_for_vecs | 1.4.0 | 1.4.1 | |
| pg_search | 0.21.9 | 0.21.12 | |
| pg_pinyin | - | 0.0.2 | New extension |
| pg_eviltransform | - | 0.0.2 | New extension |
| pg_qos | - | 1.0.0 | New extension, QoS resource governance |
Infrastructure Package Updates
| Name | Old Version | New Version | Notes |
|---|---|---|---|
asciinema | 3.1.0 | 3.2.0 | |
grafana-infinity-ds | 3.7.2 | 3.7.3 | |
victoria-metrics | 1.136.0 | 1.137.0 | |
victoria-metrics-cluster | 1.136.0 | 1.137.0 | |
vmutils | 1.136.0 | 1.137.0 | |
hugo | 0.155.3 | 0.157.0 | |
opencode | 1.2.15 | 1.2.17 | |
rustfs | 1.0.0-alpha.83 | 1.0.0-alpha.85 | |
seaweedfs | 4.13 | 4.15 | |
tigerbeetle | 0.16.74 | 0.16.75 | |
uv | 0.10.4 | 0.10.8 | |
codex | 0.105.0 | 0.110.0 | |
claude | 2.1.59 | 2.1.68 | |
xray | - | 26.2.6 | New |
gost | - | 2.12.0 | New |
sabiql | - | 1.6.2 | New |
agentsview | - | 0.10.0 | New |
Checksums
v4.2.0
Highlights
- Aligned with PostgreSQL out-of-band minor updates: 18.3, 17.9, 16.13, 15.17, 14.22.
- Total PostgreSQL extension coverage reaches 461 packages.
- Kernel updates across Babelfish, AgensGraph, pgEdge, OriolePG, OpenHalo, and Cloudberry.
- Babelfish template now uses a Pigsty-maintained PG17-compatible build, with no WiltonDB repo dependency.
- Supabase images and self-hosted templates are refreshed to the latest stack, using Pigsty-maintained pgsty/minio.
Major Changes
mssqlnow defaults to Babelfish PG17 (pg_version: 17,pg_packages: [babelfish, pgsql-common, sqlcmd]) and no longer requires an extramssqlrepo.- Kernel install paths are normalized in
pg_home_map:mssql -> /usr/babelfish-$v/,gpsql -> /usr/local/cloudberry. package_mapadds a dedicatedcloudberrymapping and fixesbabelfish*aliases to versioned RPM/DEB package names.- The Redis data root default changes from
/datato/data/redis. Deployment blocks legacy defaults, butredis_removeretains backward-compatible cleanup. configuresupports absolute-ooutput paths and creates parent directories automatically. It adds tri-state region detection (CN/global/offline fallback) and fixesbehind_gfw()hangs.- Debian/Ubuntu default repo URL mappings (
updates/backports/security) and China mirror components are corrected to prevent bootstrap package failures. - Supabase stack is updated (including PostgREST
14.5and Vector0.53.0) and now includes missing S3 protocol credential variables. - Rich/Sample templates explicitly define
dbuser_metadefaults. This release also simplifiesnode.shsystemd completion. pgbackreststanza initialization now retries (2 attempts, 5-second interval) to reduce lock contention witharchive-push.- Vibe template now ships
@anthropic-ai/claude-code,@openai/codex, andhappy-coder, and includesagein the default example.
PG Software Updates
- PostgreSQL 18.3, 17.9, 16.13, 15.17, 14.22
- RPM Changelog 2026-02-27
- DEB Changelog 2026-02-27
- Core upgrades:
timescaledb 2.25.0 -> 2.25.1,citus 14.0.0-3 -> 14.0.0-4,pg_search -> 0.21.9 - New/rebuilt:
pgedge 17.9,spock 5.0.5,lolor 1.2.2,snowflake 2.4,babelfish 5.5.0,cloudberry 2.0.0 - Kernel-side updates:
oriolepg 17.11 -> 17.16,orioledb beta12 -> beta14,openhalo 14.10 -> 1.0(14.18)
| Package | Old Version | New Version | Notes |
|---|---|---|---|
timescaledb | 2.25.0 | 2.25.1 | |
citus | 14.0.0-3 | 14.0.0-4 | Rebuilt from the latest official release |
age | 1.7.0 | 1.7.0 | Added PG 17 support for version 1.7.0 |
pgmq | 1.10.0 | 1.10.1 | Package currently unavailable |
pg_search | 0.21.7 / 0.21.6 | 0.21.9 | Previous RPM/DEB versions differ |
oriolepg | 17.11 | 17.16 | OriolePG kernel update |
orioledb | beta12 | beta14 | Matches OriolePG 17.16 |
openhalo | 14.10 | 1.0 | Updated and renamed, based on 14.18 |
pgedge | - | 17.9 | New multi-master edge-distributed kernel |
spock | - | 5.0.5 | New core pgEdge extension |
lolor | - | 1.2.2 | New core pgEdge extension |
snowflake | - | 2.4 | New core pgEdge extension |
babelfishpg | - | 5.5.0 | New BabelfishPG package group |
babelfish | - | 5.5.0 | New Babelfish compatibility package |
antlr4-runtime413 | - | 4.13 | New runtime dependency for Babelfish |
cloudberry | - | 2.0.0 | RPM build only |
pg_background | - | 1.8 | DEB build only |
Infrastructure Software Updates
| Name | Old Version | New Version |
|---|---|---|
grafana | 12.3.2 | 12.4.0 |
prometheus | 3.9.1 | 3.10.0 |
mongodb_exporter | 0.47.2 | 0.49.0 |
victoria-metrics | 1.135.0 | 1.136.0 |
victoria-metrics-cluster | 1.135.0 | 1.136.0 |
vmutils | 1.135.0 | 1.136.0 |
victoria-logs | 1.45.0 | 1.47.0 |
vlagent | 1.45.0 | 1.47.0 |
vlogscli | 1.45.0 | 1.47.0 |
loki | 3.6.5 | 3.6.7 |
promtail | 3.6.5 | 3.6.7 |
logcli | 3.6.5 | 3.6.7 |
grafana-victorialogs-ds | 0.24.1 | 0.26.2 |
grafana-victoriametrics-ds | 0.21.0 | 0.23.1 |
grafana-infinity-ds | 3.7.0 | 3.7.2 |
redis_exporter | 1.80.2 | 1.81.0 |
etcd | 3.6.7 | 3.6.8 |
dblab | 0.34.2 | 0.34.3 |
tigerbeetle | 0.16.72 | 0.16.74 |
seaweedfs | 4.09 | 4.13 |
rustfs | 1.0.0-alpha.82 | 1.0.0-alpha.83 |
uv | 0.10.0 | 0.10.4 |
kafka | 4.1.1 | 4.2.0 |
npgsqlrest | 3.7.0 | 3.10.0 |
postgrest | 14.4 | 14.5 |
caddy | 2.10.2 | 2.11.1 |
rclone | 1.73.0 | 1.73.1 |
pev2 | 1.20.1 | 1.20.2 |
genai-toolbox | 0.25.0 | 0.27.0 |
opencode | 1.1.59 | 1.2.15 |
claude | 2.1.37 | 2.1.59 |
codex | 0.104.0 | 0.105.0 |
code | 1.109.2 | 1.109.4 |
code-server | 4.108.2 | 4.109.2 |
nodejs | 24.13.1 | 24.14.0 |
pig | 1.1.2 | 1.3.0 |
stalwart | - | 0.15.5 |
maddy | - | 0.8.2 |
API Changes
pg_modenow includesagensandpgedge.mssqldefaults are updated topg_version: 17andpg_packages: [babelfish, pgsql-common, sqlcmd].- Kernel/package alias mappings are updated in
pg_home_mapandpackage_map(Babelfish, OpenHalo, IvorySQL, Cloudberry, pgEdge family). redis_fs_mainnow defaults to/data/redis, with deployment guardrails and backward-compatible cleanup behavior.configureoutput path handling and region detection logic are updated, with offline fallback warnings and unified SSH probe timeouts.grafana.ini.j2is updated for Grafana 12.4 config changes and deprecations.
Compatibility Notes
- If existing Redis configs still use
redis_fs_main: /data, migrate to/data/redisbefore deployment. - Grafana 12.4 changes how it merges data links. This release moves key links into field overrides. Review custom dashboards for these changes.
26 commits, 122 files changed, +2,116 / -2,215 lines (v4.1.0..v4.2.0, 2026-02-15 ~ 2026-02-28)
Checksums
v4.1.0
72 commits, 252 files changed, +5,744 / -5,015 lines (v4.0.0..v4.1.0, 2026-02-02 ~ 2026-02-13)
Highlights
- PostgreSQL minor update: 18.2, 17.8, 16.12, 15.16, 14.21.
- Default EL minors updated to
9.7 / 10.1, Debian minors updated to12.13 / 13.3. - Added 7 new extensions, bringing total support to 451 extensions.
pigmoved from a traditional script interface to an Agent-Native CLI (1.0.0 -> 1.1.0), with explicit context and JSON/YAML output.pignow provides unified major/minor upgrade workflows for PostgreSQL and OS lifecycle updates.pg_exporterupgraded to v1.2.0 (1.1.2 -> 1.2.0), with PG17/18 metric pipeline and unit fixes.- Updated the default firewall security policy.
node_firewall_modedefaults tozone. Thenode_firewall_public_portdefault changes from[22,80,443,5432]to[22,80,443]. - Focused PGSQL/PGCAT Grafana usability fixes: dynamic datasource
$dsn, schema-level drilldown, age metrics, link mapping consistency. - Added one-click Mattermost application template, including database/storage/portal and optional PGFS/JuiceFS options.
- Refactored
infra-rmuninstall flow with segmentedderegistercleanup for Victoria targets, Grafana datasources, and Vector logs. - Optimized default PostgreSQL autovacuum thresholds to reduce excessive vacuum/analyze on small tables.
- Fixed FD limit chain: added
fs.nr_open=8Mand unifiedLimitNOFILE=8Mto avoid startup failures from systemd/setrlimit. - Updated VIBE defaults: Jupyter disabled by default; Claude Code managed via npm package.
Version Updates
- Pigsty version:
v4.0.0 -> v4.1.0 pigCLI:1.0.0 -> 1.1.0(Agent-Native + major/minor upgrade support)pg_exporter:1.1.2 -> 1.2.0- Default EL minors:
9.6/10.0 -> 9.7/10.1 - Default Debian minors:
12.12/13.1 -> 12.13/13.3
Extension Updates
- RPM Changelog 2026-02-12
- DEB Changelog 2026-02-12
- timescaledb
2.24.0 -> 2.25.0 - pg_search
0.21.4 -> 0.21.7 - pgmq
1.9.0 -> 1.10.0 - pg_textsearch
0.4.0 -> 0.5.0 - pljs
1.0.4 -> 1.0.5 - pg_track_optimizer
0.9.1(new) - nominatim_fdw
1.1.0(new) - pg_utl_smtp
1.0.0(new) - pg_strict
1.0.2(new) - pgmb
1.0.0(new) - pg_pwhash (new support)
- informix_fdw (new support)
INFRA Component Versions
| Package | Version | Package | Version |
|---|---|---|---|
| victoria-metrics | 1.135.0 | victoria-logs | 1.45.0 |
| vector | 0.53.0 | grafana | 12.3.2 |
| alertmanager | 0.31.1 | etcd | 3.6.7 |
| duckdb | 1.4.4 | pg_exporter | 1.2.0 |
| pig | 1.1.0 | claude | 2.1.37 |
| opencode | 1.1.59 | uv | 0.10.0 |
| code-server | 4.108.2 | caddy | 2.10.2 |
| hugo | 0.155.2 | cloudflared | 2026.2.0 |
| headscale | 0.28.0 |
API Changes
- Corrected template guard for
io_method/io_workersfrompg_version >= 17topg_version >= 18. - Fixed PG18 guards for
idle_replication_slot_timeout/initdb --no-data-checksums. - Broadened
maintenance_io_concurrencyeffective range toPG13+. - Raised
autovacuum_vacuum_threshold:oltp/crit/tinyfrom 50 to 500,olapto 1000. - Raised
autovacuum_analyze_threshold:oltp/crit/tinyfrom 50 to 250,olapto 500. - Increased default
checkpoint_completion_targetfrom0.90to0.95. - Added
fs.nr_open=8388608in node tuned templates and alignedfs.file-max / fs.nr_open / LimitNOFILE. - Changed postgres/patroni/minio systemd
LimitNOFILEfrom16777216to8388608. - Added
fs.nr_open: 8388608into defaultnode_sysctl_params. - Changed the
node_firewall_modedefault fromnonetozone. The firewall is enabled by default and trusts the intranet. It exposes onlynode_firewall_public_portto public networks. For a fully self-managed firewall, setnone. - Changed the
node_firewall_public_portdefault from[22,80,443,5432]to[22,80,443]. Add5432explicitly only when public database access is required. Firewall rules only add permissions. On existing nodes that already expose5432, remove that rule manually. Single-node trial templates, such asmeta/vibe, explicitly retain5432for remote use. - Added
bin/validatechecks forpg_databases[*].parametersandpg_hba_rules[*].order. Fixed HBA validation that did not return failure correctly. - Added segmented tags in
infra-rm.yml:deregister,config,env, etc. - Updated VIBE defaults:
jupyter_enabled=false,npm_packagesinclude@anthropic-ai/claude-codeandhappy-coder, plusCLAUDE_CODE_EXPERIMENTAL_AGENT_TEAMS=1. - PgBouncer alias cleanup:
pool_size_reserve -> pool_reserve,pool_max_db_conn -> pool_connlimit.
Compatibility Fixes (Deduplicated)
- Note: repeated regressions/re-fixes of the same issue are counted once and merged by problem domain below.
- Fixed Redis
replicaofempty-guard logic and systemd stop behavior. - Fixed schema/table/sequence qualification, identifier quoting, and logging format safety in
pg_migration. - Fixed restart targets and variable usage in pgsql role handlers.
- Fixed blackbox config filename cleanup item and pgAdmin pgpass file format.
- Made
pg_exporterstartup non-blocking to avoid slowing main flow when exporter fails. - Simplified VIP CIDR parsing: default mask
24when omitted. - Increased MinIO health-check retries from
3to5. - Switched node hostname setup to Ansible hostname module instead of shell calls.
- Fixed
.envformat forapp/electricandapp/pg_exporterto standardKEY=VALUE. - Fixed
pg_crontabsyntax error inpigsty.yml. - Updated ETCD docs to clarify default TLS vs optional mTLS semantics.
- Fixed
repo-addargument passing, Debian CN mirror component compatibility, andbin/psql.pyPython 3 compatibility. - Hardened redis-exporter credential file permissions.
pgsql-user.ymlnow masks credential logs (no_log) on sensitive steps.- Fixed gate conditions when
pg_monitorregisters Victoria targets. - Changed
pg_removebackup cleanup to cluster-level directory to avoid deleting other cluster backups.
Commit List (v4.0.0..v4.1.0, 72 commits, 2026-02-02 ~ 2026-02-13)
Thanks
- Thanks to @l2dy for many valuable suggestions and issues.
Checksums
v4.0.0
318 commits, 604 files changed, +118,655 / -327,552 lines
Highlights
- Observability Revolution: Prometheus → VictoriaMetrics (10x perf), Loki+Promtail → VictoriaLogs+Vector
- Security Hardening: Auto-generated passwords, etcd RBAC, firewall/SELinux modes, permission tightening, Nginx Basic Auth
- Docker Support: Run Pigsty in Docker containers with full systemd support (macOS & Linux)
- New Module: JUICE - Mount PostgreSQL as filesystem with PITR recovery capability
- New Module: VIBE - AI coding sandbox with Claude Code, JupyterLab, VS Code Server, Node.js
- Database Management:
pg_databasesstate (create/absent/recreate), instant clone withstrategy - PITR & Fork:
/pg/bin/pg-forkfor instant CoW cloning, enhancedpg-pitrwith pre-backup - HA Enhancement:
pg_rto_planwith 4 RTO presets (fast/norm/safe/wide),pg_crontabscheduled tasks - Multi-Cloud Terraform: AWS, Azure, GCP, Hetzner, DigitalOcean, Linode, Vultr, TencentCloud templates
- License Change: AGPL-3.0 → Apache-2.0
Infra Software Versions - MinIO now uses pgsty/minio fork RPM/DEB.
| Package | Version | Package | Version |
|---|---|---|---|
| victoria-metrics | 1.134.0 | victoria-logs | 1.43.1 |
| vector | 0.52.0 | grafana | 12.3.1 |
| alertmanager | 0.30.1 | etcd | 3.6.7 |
| duckdb | 1.4.4 | pg_exporter | 1.1.2 |
| pgbackrest_exporter | 0.22.0 | blackbox_exporter | 0.28.0 |
| node_exporter | 1.10.2 | minio | 20251203 |
| pig | 1.0.0 | claude | 2.1.19 |
| opencode | 1.1.34 | uv | 0.9.26 |
| asciinema | 3.1.0 | prometheus | 3.9.1 |
| pushgateway | 1.11.2 | juicefs | 1.4.0 |
| code-server | 4.100.2 | caddy | 2.10.2 |
| hugo | 0.154.5 | cloudflared | 2026.1.1 |
| headscale | 0.27.1 |
New Modules
- JUICE Module: Uses PostgreSQL as the metadata engine for the JuiceFS distributed filesystem. Supports filesystem PITR, multiple storage backends (PG large objects, MinIO, S3), and multi-instance deployment with Prometheus metrics. Adds the
node-juicedashboard. - VIBE Module: Provides an AI coding sandbox with Code-Server (VS Code in a browser), JupyterLab (interactive computing), and Node.js (JavaScript runtime). It also includes Claude Code, an AI coding assistant with OpenTelemetry observability. Adds the
claude-codedashboard for usage monitoring.
PostgreSQL Extension Updates
Major extensions add PG 18 support: age, citus, documentdb, pg_search, timescaledb, pg_bulkload, rum, etc.
New: pg_textsearch 0.4.0, pg_clickhouse 0.1.3, pg_ai_query 0.1.1, etcd_fdw, pg_ttl_index 0.1.0, pljs 1.0.4, pg_retry 1.0.0, pg_weighted_statistics 1.0.0, pg_enigma 0.5.0, pglinter 1.0.1, documentdb_extended_rum 0.109, mobilitydb_datagen 1.3.0
Updated: timescaledb 2.24.0, pg_search 0.21.4, citus 14.0.0, documentdb 0.109, age 1.7.0, pg_duckdb 1.1.1, vchord 1.0.0, vchord_bm25 0.3.0, pg_biscuit 2.2.2, pg_anon 2.5.1, wrappers 0.5.7, pg_vectorize 0.26.0, pg_session_jwt 0.4.0, pg_partman 5.4.0, pgmq 1.9.0, pg_bulkload 3.1.23, pg_timeseries 0.2.0, pg_convert 0.1.0, pgBackRest 2.58
Breaking Changes
| Before | After |
|---|---|
| Prometheus | VictoriaMetrics |
| Loki + Promtail | VictoriaLogs + Vector |
node_disable_firewall | node_firewall_mode |
node_disable_selinux | node_selinux_mode |
pg_pwd_enc | removed (always scram-sha-256) |
infra_pip_packages | node_pip_packages |
grafana_clean default | true → false |
install.yml | renamed to deploy.yml |
Observability
- VictoriaMetrics replaces Prometheus. It provides several times the performance with a fraction of the resources.
- VictoriaLogs + Vector replaces Promtail + Loki for log collection
- Unified the log format for all components. PG logs use UTC timestamps (log_timezone).
- PostgreSQL log rotation changed to weekly truncated rotation mode
- Added Vector parsing configs for Nginx/Syslog/PG CSV/Pgbackrest/Grafana/Redis/etcd/MinIO logs
- Datasource registration now runs on all Infra nodes. Grafana automatically registers Victoria datasources.
- New
grafana_pgurlparameter for using PG as Grafana backend storage - New
grafana_view_passwordparameter for Grafana Meta datasource password pg_exporterupdated to 1.1.2 with newpg_timelinecollector and numerous fixes- New dashboards:
node-vector,node-juice,claude-code
Interface Improvements
- Renamed the
install.ymlplaybook todeploy.yml. Added thevibe.ymlplaybook for the VIBE module. pg_databases: addedstatefield (create/absent/recreate),strategyfor cloning, newer locale params supportpg_users: addedadminparameter withADMIN OPTION,setandinheritoptionspg_hba: supportorderfield for priority, IPv6 localhost access- New
node_crontabauto-restores original crontab onnode-rm
Parameter Optimization
pg_io_method: auto, sync, worker, io_uring options, default workerpg_rto_plan: RTO presets (fast/norm/safe/wide) integrating Patroni & HAProxy configpg_crontab: scheduled tasks for postgres dbsuidle_replication_slot_timeout: default 7d, crit template 3dfile_copy_method: set toclonefor PG18 instant database cloning- Crit template enables Patroni strict sync mode
- PITR default
archive_modechanged topreserve
Architecture Improvements
- Fixed
/infrasymlink pointing to/data/infraon Infra nodes - Local repo at
/data/nginx/pigsty,/wwwsymlinks to/data/nginx - New scripts:
/pg/bin/pg-fork(CoW cloning),/pg/bin/pg-drop-role,bin/pgsql-ext - Enhanced
/pg/bin/pg-pitrfor instance-level PITR with pre-backup - UV Python manager moved from
infratonodemodule withnode_uv_envparameter - Terraform templates: AWS, Azure, GCP, Hetzner, DigitalOcean, Linode, Vultr, TencentCloud
- Reduced the Simu template from 36 to 20 nodes. Added 10-node and Citus templates.
Security Improvements
configure -gauto-generates strong random passwords- Replaced
node_disable_firewallwithnode_firewall_mode(off/none/zone) - Replaced
node_disable_selinuxwithnode_selinux_mode(disabled/permissive/enforcing) - Nginx Basic Auth support for optional HTTP authentication
- Enabled etcd RBAC. Each cluster can manage only its own PG cluster.
- etcd root password stored in
/etc/etcd/etcd.pass, admin-readable only - New
node_admin_sudoparameter for admin sudo mode (all/nopass) - Fixed ownca certificate validity for Chrome recognition
Bug Fixes
- Fixed ownca certificate validity for Chrome compatibility
- Fixed Vector 0.52 syslog_raw parsing issue
- Fixed pg_pitr multiple replica clonefrom timing issues
- Fixed Ansible SELinux race condition in dnsmasq
- Fixed EL9 aarch64 patroni & llvmjit issues
- Fixed pgbouncer pid path (
/run/postgresql) - Fixed HAProxy service template variable path
- Fixed MinIO reload handler ineffective
- Fixed vmetrics_port default value to 8428
- Fixed pg-failover-callback for all Patroni callback events
New Parameters
| Parameter | Type | Default | Description |
|---|---|---|---|
node_firewall_mode | enum | none (v4.0) | Firewall mode: off/none/zone (default is zone since v4.1) |
node_selinux_mode | enum | permissive | SELinux mode |
node_admin_sudo | enum | nopass | Admin sudo privilege level |
pg_io_method | enum | worker | I/O method: auto/sync/worker/io_uring |
pg_rto_plan | dict | - | RTO presets: fast/norm/safe/wide |
pg_crontab | list | [] | postgres dbsu scheduled tasks |
grafana_view_password | string | DBUser.Viewer | Grafana Meta datasource password |
juice_cache | path | /data/juice | JuiceFS cache directory |
juice_instances | dict | {} | JuiceFS instance definitions |
vibe_data | path | /fs | VIBE workspace directory |
code_enabled | bool | true | Enable Code-Server |
code_password | string | Vibe.Coding | Code-Server password |
jupyter_enabled | bool | true | Enable JupyterLab |
jupyter_password | string | Vibe.Coding | JupyterLab access token |
claude_enabled | bool | true | Enable Claude Code configuration |
nodejs_enabled | bool | true | Enable Node.js installation |
nodejs_registry | string | '' | npm registry, auto china mirror |
node_uv_env | path | /data/venv | Node UV venv path, empty to skip |
node_pip_packages | string | '' | pip packages for UV venv |
Removed Parameters: node_disable_firewall, node_disable_selinux, infra_pip_packages, pg_pwd_enc, pgbackrest_clean, code_home, jupyter_home
Checksums
v3.7.0
Highlights
- PostgreSQL 18 Deep Support: PostgreSQL 18 is now the default major version, with full extension support.
- Expanded OS Support: Added EL10 and Debian 13, bringing the total supported operating systems to 14.
- Extension Growth: The PostgreSQL extension library now includes 437 entries.
- Ansible 2.19 Compatibility: Full support for Ansible 2.19 following its breaking changes.
- Kernel Updates: Latest versions for Supabase, PolarDB, IvorySQL, and Percona kernels.
- Optimized Tuning: Improved default PG parameter logic to maximize resource use.
- PGEXT.CLOUD: Dedicated extension website open-sourced under Apache-2.0 license
Version Updates
- PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, 13.23
- Patroni 4.1.0
- Pgbouncer 1.25.0
- pg_exporter 1.0.3
- pgbackrest 2.57.0
- Supabase 2025-11
- PolarDB 15.15.5.0
- FerretDB 2.7.0
- DuckDB 1.4.2
- Etcd 3.6.6
- pig 0.7.4
For detailed version changes, see:
API Changes
- Improved parallel execution parameter tuning. See the Tuning Guide.
- The
citusextension is no longer installed by default inrichandfulltemplates (PG 18 support pending). - Added
duckdbextension stubs to PostgreSQL parameter templates. - Capped
min_wal_size,max_wal_size, andmax_slot_wal_keep_sizeat 200 GB, 2000 GB, and 3000 GB, respectively. - Capped
temp_file_limitat 200 GB (2 TB for OLAP workloads). - Increased the default connection count for the connection pool.
- Added
prometheus_port(default:9058) to avoid conflicts with the EL10 RHEL Web Console port. - Changed
alertmanager_portdefault to9059to avoid potential conflicts with Kafka SSL ports. - Added the
pg_presubtask topg_pkg. It removes conflicting LLVM packages (bpftool,python3-perf) on EL9+ before PG installation. - Added the
llvmmodule to the default repository definition for Debian/Ubuntu. - Fixed package removal logic in
infra-rm.yml.
Compatibility Fixes
- Ubuntu/Debian CA Trust: Fixed incorrect warning return codes when trusting Certificate Authorities.
- Ansible 2.19 Support: Fixed compatibility issues introduced by Ansible 2.19 to support stable operation across versions:
- Added explicit
inttype casting for sequence variables. - Migrated
with_itemssyntax toloop. - Nested key exchange variables in lists to prevent character iteration on strings in newer versions.
- Explicitly cast
rangeusage tolist. - Renamed reserved variables such as
nameandport. - Replaced
play_hostswithansible_play_hosts. - Added string casting for specific variables to prevent runtime errors.
- Added explicit
- EL10 Adaptation:
- Fixed missing
ansible-collection-community-cryptopreventing key generation. - Fixed missing
ansiblelogic packages. - Removed
modulemd_tools,flamegraph, andtimescaledb-tool. - Replaced
java-17-openjdkwithjava-21-openjdk. - Resolved aarch64 YUM repository naming issues.
- Fixed missing
- Debian 13 Adaptation:
- Replaced
dnsutilswithbind9-dnsutils.
- Replaced
- Ubuntu 24 Fixes:
- Temporarily removed
tcpdumpdue to upstream dependency crashes.
- Temporarily removed
Checksums
v3.6.1
Highlights
- Released PostgreSQL 17.6, 16.10, 15.14, 14.19, 13.22, and 18 Beta 3.
- PGDG APT/YUM mirror for Mainland China Users
- New home website https://pgsty.com
- Added EL10 and Debian 13 stubs, plus EL10 Terraform images.
Infra Package Updates
- Grafana 12.1.0
- pg_exporter 1.0.2
- pig 0.6.1
- vector 0.49.0
- redis_exporter 1.75.0
- mongo_exporter 0.47.0
- victoriametrics 1.123.0
- victorialogs: 1.28.0
- grafana-victoriametrics-ds 0.18.3
- grafana-victorialogs-ds 0.19.3
- grafana-infinity-ds 3.4.1
- etcd 3.6.4
- ferretdb 2.5.0
- tigerbeetle 0.16.54
- genai-toolbox 0.12.0
Extension Package Updates
- pg_search 0.17.3
API Changes
- Removed
br_filterfrom the defaultnode_kernel_modules. - Stopped using OS minor-version directories for PGDG YUM repositories.
Checksums
v3.6.0
Highlights
- New documentation site: https://doc.pgsty.com
- Added
pgsql-pitrplaybook and backup/restore tutorial, improved PITR experience - Added kernel support: Percona PG TDE (PG17)
- Improved self-hosted Supabase, updated it to the latest version, and fixed issues in the official template.
- Simplified installation. Online installation is now the default, and the installation script includes bootstrap.
Improvements
- Refactored
ETCDmodule with dedicated remove playbook and bin utils - Refactored
MinIOmodule with plain HTTP mode, better bucket provisioning options. - Reorganized and streamlined all configuration templates for easier use
- Faster Docker Registry mirror for users in mainland China
- Optimized tuned OS parameter templates for modern hardware and NVMe disks
- Added extension
pgactivefor multi-master replication and sub-second failover - Adjusted defaults for
pg_fs_main/pg_fs_backupand simplified the directory structure.
Bug Fixes
- Fixed pgbouncer configuration file error by @housei-zzy
- Fixed OrioleDB issues on Debian platform
- Fixed tuned shm configuration parameter issue
- Offline packages now use the PGDG source directly, avoiding out-of-sync mirror sites
- Fixed IvorySQL libxcrypt dependency issues.
- Replaced the slow, broken EPEL mirror.
- Fixed the
haproxy_enabledflag.
Infra Package Updates
Added Victoria Metrics / Victoria Logs related packages
- genai-toolbox 0.9.0 (new)
- victoriametrics 1.120.0 -> 1.121.0 (refactor)
- vmutils 1.121.0 (rename from victoria-metrics-utils)
- grafana-victoriametrics-ds 0.15.1 -> 0.17.0
- victorialogs 1.24.0 -> 1.25.1 (refactor)
- vslogcli 1.24.0 -> 1.25.1
- vlagent 1.25.1 (new)
- grafana-victorialogs-ds 0.16.3 -> 0.18.1
- prometheus 3.4.1 -> 3.5.0
- grafana 12.0.0 -> 12.0.2
- vector 0.47.0 -> 0.48.0
- grafana-infinity-ds 3.2.1 -> 3.3.0
- keepalived_exporter 1.7.0
- blackbox_exporter 0.26.0 -> 0.27.0
- redis_exporter 1.72.1 -> 1.77.0
- rclone 1.69.3 -> 1.70.3
Database Package Updates
- PostgreSQL 18 Beta2 update
- pg_exporter 1.0.1, updated to latest dependencies and provides Docker image
- pig 0.6.0, updated extension and repository list, with
pig installsubcommand - vip-manager 3.0.0 -> 4.0.0
- ferretdb 2.2.0 -> 2.3.1
- dblab 0.32.0 -> 0.33.0
- duckdb 1.3.1 -> 1.3.2
- etcd 3.6.1 -> 3.6.3
- ferretdb 2.2.0 -> 2.4.0
- juicefs 1.2.3 -> 1.3.0
- tigerbeetle 0.16.41 -> 0.16.50
- pev2 1.15.0 -> 1.16.0
Extension Package Updates
- OrioleDB 1.5 beta12
- OriolePG 17.11
- plv8 3.2.3 -> 3.2.4
- postgresql_anonymizer 2.1.1 -> 2.3.0
- pgvectorscale 0.7.1 -> 0.8.0
- wrappers 0.5.0 -> 0.5.3
- supautils 2.9.1 -> 2.10.0
- citus 13.0.3 -> 13.1.0
- timescaledb 2.20.0 -> 2.21.1
- vchord 0.3.0 -> 0.4.3
- pgactive 2.1.5 (new)
- documentdb 0.103.0 -> 0.105.0
- pg_search 0.17.0
API Changes
pg_fs_backup: Renamed topg_fs_backup, default value/data/backups.pg_rm_bkup: Renamed topg_rm_backup, default valuetrue.pg_fs_main: Default value adjusted to/data/postgres.nginx_cert_validity: New parameter to control Nginx self-signed certificate validity, default397d.minio_buckets: Default value adjusted to create three buckets namedpgsql,meta,data.minio_users: Removed thedbauser. Addeds3user_metafor themetabucket ands3user_datafor thedatabucket.minio_https: New parameter to allow MinIO to use HTTP mode.minio_provision: New parameter to allow skipping MinIO provisioning stage (skip bucket and user creation)minio_safeguard: New parameter, abortminio-rm.ymlwhen enabledminio_rm_data: New parameter, whether to remove minio data directory duringminio-rm.ymlminio_rm_pkg: New parameter, whether to uninstall minio package duringminio-rm.ymletcd_learner: New parameter to control whether to init etcd instance as learneretcd_rm_data: New parameter, whether to remove etcd data directory duringetcd-rm.ymletcd_rm_pkg: New parameter, whether to uninstall etcd package duringetcd-rm.yml
Checksums
v3.5.0
Highlights
- New website: https://pgsty.com
- PostgreSQL 18 (Beta) support: monitoring via
pg_exporter 1.0.0, installer alias viapig 0.4.2, and apg18template - 421 bundled extensions, now including OrioleDB and OpenHalo kernels on all platforms
pig doCLI replaces legacybin/scripts- Hardening for self-hosted Supabase (replication lag, key distribution, etc.)
- Code & architecture refactor — slimmer tasks, cleaner defaults for Postgres & PgBouncer
- Monitoring stack refresh — Grafana 12,
pg_exporter 1.0, new panels & plugins - Run vagrant on Apple Silicon
Module Changes
- Add PostgreSQL 18 support
- PG18 metrics support with pg_exporter 1.0.0+
- PG18 install support with pig 0.4.1+
- New config template
pg18.yml - Refactored
pgsqlmodule - Split monitoring into a new
pg_monitorrole; removedcleanlogic - Pruned duplicate tasks, dropped
dir/utilsblock, renamed templates (no.j2) - All extensions install in
extensionsschema (Supabase best-practice) - Added
SET search_path=''to every monitoring function - Tuned PgBouncer defaults (larger pool, cleanup query); new
pgbouncer_ignore_param - New
pg_keytask to generatepgsodiummaster keys - Enabled
sync_replication_slotsby default on PG 17 - Retagged subtasks for clearer structure
- Refactored
pg_removemodule - New flags
pg_rm_data,pg_rm_bkup, andpg_rm_pkgcontrol which resources to remove. - Clearer role layout & tagging
- Added new
pg_monitormodule - pgbouncer_exporter no longer shares configuration files with
pg_exporter - Added monitoring metrics for TimescaleDB and Citus
- Using
pg_exporter0.9.0 with updated replication slot metrics for PG16/17 - Using more compact, newly designed collector configuration files
- Supabase Enhancement (thanks @lawso017 for the contribution)
- update supabase containers and schemas to the latest version
- Support
pgsodiumserver key loading - fix logflare lag issue with
supa-kickcrontab - add
set search_pathclause for monitor functions - Added
pig doto the CLI. This command replaces Shell scripts inbin/.
Infra Package Updates
- pig 0.4.2
- duckdb 1.3.0
- etcd 3.6.0
- vector 0.47.0
- minio 20250422221226
- mcli 20250416181326
- pev 1.5.0
- rclone 1.69.3
- mtail 3.0.8 (new)
Observability Package Updates
- grafana 12.0.0
- grafana-victorialogs-ds 0.16.3
- grafana-victoriametrics-ds 0.15.1
- grafana-infinity-ds 3.2.1
- grafana_plugins 12.0.0
- prometheus 3.4.0
- pushgateway 1.11.1
- nginx_exporter 1.4.2
- pg_exporter 1.0.0
- pgbackrest_exporter 0.20.0
- redis_exporter 1.72.1
- keepalived_exporter 1.6.2
- victoriametrics 1.117.1
- victoria_logs 1.22.2
Database Package Updates
- PostgreSQL 17.5, 16.9, 15.13, 14.18, 13.21
- PostgreSQL 18beta1 support
- pgbouncer 1.24.1
- pgbackrest 2.55
- pgbadger 13.1
Extension Package Updates
- spat 0.1.0a4 new extension
- pgsentinel 1.1.0 new extension
- pgdd 0.6.0 (pgrx 0.14.1) new extension add back
- convert 0.0.4 (pgrx 0.14.1) new extension
- 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_idkit 0.3.0 (pgrx 0.14.1)
- pg_ivm 1.11.0
- orioledb 1.4.0 beta11 rpm & add debian/ubuntu support
- openhalo 14.10 add debian/ubuntu support
- omnigres 20250507 (miss on d12/u22)
- citus 12.0.3
- timescaledb 2.20.0 (DROP PG14 support)
- supautils 2.9.2
- pg_envvar 1.0.1
- pgcollection 1.0.0
- aggs_for_vecs 1.4.0
- pg_tracing 0.1.3
- pgmq 1.5.1
- tzf-pg 0.2.0 (pgrx 0.14.1)
- pg_search 0.15.18 (pgrx 0.14.1)
- anon 2.1.1 (pgrx 0.14.1)
- pg_parquet 0.4.0 (0.14.1)
- pg_cardano 1.0.5 (pgrx 0.12) -> 0.14.1
- pglite_fusion 0.0.5 (pgrx 0.12.8) -> 14.1
- vchord_bm25 0.2.1 (pgrx 0.13.1)
- vchord 0.3.0 (pgrx 0.13.1)
- pg_vectorize 0.22.1 (pgrx 0.13.1)
- wrappers 0.4.6 (pgrx 0.12.9)
- timescaledb-toolkit 1.21.0 (pgrx 0.12.9)
- pgvectorscale 0.7.1 (pgrx 0.12.9)
- pg_session_jwt 0.3.1 (pgrx 0.12.6) -> 0.12.9
- pg_timetable 5.13.0
- ferretdb 2.2.0
- documentdb 0.103.0 (+aarch64 support)
- pgml 2.10.0 (pgrx 0.12.9)
- sqlite_fdw 2.5.0 (fix pg17 deb)
- tzf 0.2.2 0.14.1 (rename src)
- pg_vectorize 0.22.2 (pgrx 0.13.1)
- wrappers 0.5.0 (pgrx 0.12.9)
Checksums
v3.4.1
GitHub Release Page: v3.4.1
- Added support for MySQL wire-compatible PostgreSQL kernel on EL systems: openHalo
- Added support for OLTP-enhanced PostgreSQL kernel on EL systems: orioledb
- Optimized pgAdmin 9.2 application template with automatic server list updates and pgpass password population
- Increased PG default max connections to 250, 500, 1000
- Removed the
mysql_fdwextension with dependency errors from EL8
Infra Updates
- pig 0.3.4
- etcd 3.5.21
- restic 0.18.0
- ferretdb 2.1.0
- tigerbeetle 0.16.34
- pg_exporter 0.8.1
- node_exporter 1.9.1
- grafana 11.6.0
- zfs_exporter 3.8.1
- mongodb_exporter 0.44.0
- victoriametrics 1.114.0
- minio 20250403145628
- mcli 20250403170756
Extension Update
- Bump pg_search to 0.15.13
- Bump citus to 13.0.3
- Bump timescaledb to 2.19.1
- Bump pgcollection RPM to 1.0.0
- Bump pg_vectorize RPM to 0.22.1
- Bump pglite_fusion RPM to 0.0.4
- Bump aggs_for_vecs RPM to 1.4.0
- Bump pg_tracing RPM to 0.1.3
- Bump pgmq RPM to 1.5.1
Checksums
v3.4.0
GitHub Release Page: v3.4.0
Introduction Blog: Pigsty v3.4 MySQL Compatibility and Overall Enhancements
New Features
- Added new pgBackRest backup monitoring metrics and dashboards
- Enhanced Nginx server configuration options, with support for automated Certbot issuance
- Now prioritizing PostgreSQL’s built-in
C/C.UTF-8locale settings - IvorySQL 4.4 is now fully supported across all platforms (RPM/DEB on x86/ARM)
- Added new software packages: Juicefs, Restic, TimescaleDB EventStreamer
- The Apache AGE graph database extension now fully supports PostgreSQL 13–17 on EL
- Improved the
app.ymlplaybook: launch standard Docker app without extra config - Updated Supabase, Dify, and Odoo app templates to their latest versions.
- Add electric app template, local-first PostgreSQL Sync Engine
Infra Packages
- +restic 0.17.3
- +juicefs 1.2.3
- +timescaledb-event-streamer 0.12.0
- Prometheus 3.2.1
- AlertManager 0.28.1
- blackbox_exporter 0.26.0
- node_exporter 1.9.0
- mysqld_exporter 0.17.2
- kafka_exporter 1.9.0
- redis_exporter 1.69.0
- pgbackrest_exporter 0.19.0-2
- DuckDB 1.2.1
- etcd 3.5.20
- FerretDB 2.0.0
- tigerbeetle 0.16.31
- vector 0.45.0
- VictoriaMetrics 1.113.0
- VictoriaLogs 1.17.0
- rclone 1.69.1
- pev2 1.14.0
- grafana-victorialogs-ds 0.16.0
- grafana-victoriametrics-ds 0.14.0
- grafana-infinity-ds 3.0.0
PostgreSQL Related
- Patroni 4.0.5
- PolarDB 15.12.3.0-e1e6d85b
- IvorySQL 4.4
- pgbackrest 2.54.2
- pev2 1.14
- Babelfish 13.17
PostgreSQL Extensions
- pgspider_ext 1.3.0 (new extension)
- apache age 13–17 el rpm (1.5.0)
- timescaledb 2.18.2 → 2.19.0
- citus 13.0.1 → 13.0.2
- documentdb 1.101-0 → 1.102-0
- pg_analytics 0.3.4 → 0.3.7
- pg_search 0.15.2 → 0.15.8
- pg_ivm 1.9 → 1.10
- emaj 4.4.0 → 4.6.0
- pgsql_tweaks 0.10.0 → 0.11.0
- pgvectorscale 0.4.0 → 0.6.0 (pgrx 0.12.5)
- pg_session_jwt 0.1.2 → 0.2.0 (pgrx 0.12.6)
- wrappers 0.4.4 → 0.4.5 (pgrx 0.12.9)
- pg_parquet 0.2.0 → 0.3.1 (pgrx 0.13.1)
- vchord 0.2.1 → 0.2.2 (pgrx 0.13.1)
- pg_tle 1.2.0 → 1.5.0
- supautils 2.5.0 → 2.6.0
- sslutils 1.3 → 1.4
- pg_profile 4.7 → 4.8
- pg_snakeoil 1.3 → 1.4
- pg_jsonschema 0.3.2 → 0.3.3
- pg_incremental 1.1.1 → 1.2.0
- pg_stat_monitor 2.1.0 → 2.1.1
- ddl_historization 0.7 → 0.0.7 (bug fix)
- pg_sqlog 3.1.7 → 1.6 (bug fix)
- pg_random removed development suffix (bug fix)
- asn1oid 1.5 → 1.6
- table_log 0.6.1 → 0.6.4
Interface Changes
- Added new Docker parameters:
docker_dataanddocker_storage_driver(#521 by @waitingsong) - Added new Infra parameter:
alertmanager_port, which lets you specify the AlertManager port - Added the Infra parameter
certbot_signto request certificates during Nginx initialization. The default is false. - Added new Infra parameter:
certbot_email, specifying the email used when requesting certificates via Certbot - Added new Infra parameter:
certbot_options, specifying additional parameters for Certbot - Updated IvorySQL to place its default binary under
/usr/ivory-4starting in IvorySQL 4.4 - Changed the default for
pg_lc_ctypeand other locale-related parameters fromen_US.UTF-8toC - On PostgreSQL 17, built-in localization rules take priority when using
UTF8encoding withCorC.UTF-8locales. configurechecks whether both the PG version and environment supportC.utf8. It adjusts locale options to match.- Set the default IvorySQL binary path to
/usr/ivory-4 - Updated the default value of
pg_packagestopgsql-main patroni pgbouncer pgbackrest pg_exporter pgbadger vip-manager - Updated the default value of
repo_packagesto[node-bootstrap, infra-package, infra-addons, node-package1, node-package2, pgsql-utility, extra-modules] - Removed
LANGandLC_ALLenvironment variable settings from/etc/profile.d/node.sh - Now using
bento/rockylinux-8andbento/rockylinux-9as the Vagrant box images for EL - Added a new alias,
extra_modules, which includes additional optional modules - Updated PostgreSQL aliases:
postgresql,pgsql-main,pgsql-core,pgsql-full - GitLab repositories are now included among available modules
- The Docker module has been merged into the Infra module
- The
node.ymlplaybook now includes anode_piptask to configure a pip mirror on each node - The
pgsql.ymlplaybook now includes apgbackrest_exportertask for collecting backup metrics - The
Makefilenow allows the use ofMETA/PKGenvironment variables - Added
/pg/spooldirectory as temporary storage for pgBackRest - Disabled pgBackRest’s
link-alloption by default - Enabled block-level incremental backups for MinIO repositories by default
Bug Fixes
- Fixed the exit status code in
pg-backup(#532 by @waitingsong) - In
pg-tune-hugepage, restricted PostgreSQL to use only large pages (#527 by @waitingsong) - Fixed logic errors in the
pg-roletask - Corrected type conversion for hugepage configuration parameters
- Fixed default value issues for
node_repo_modulesin theslimtemplate
Checksums
v3.3.0
- Increased available extensions to 404.
- PostgreSQL February Minor Updates: 17.4, 16.8, 15.12, 14.17, 13.20
- New Feature:
app.ymlscript for auto-installing apps like Odoo, Supabase, Dify. - New Feature: Further Nginx configuration customization in
infra_portal. - New Feature: Added Certbot support for quick free HTTPS certificate requests.
- New Feature: Pure-text extension list now supported in
pg_default_extensions. - New Feature: Default repositories now include mongo, redis, groonga, haproxy, etc.
- New Parameter:
node_aliasesto add command aliases for Nodes. - Fix: Resolved default EPEL repo address issue in Bootstrap script.
- Improvement: Added Aliyun mirror for Debian Security repository.
- Improvement: pgBackRest backup support for IvorySQL kernel.
- Improvement: ARM64 and Debian/Ubuntu support for PolarDB.
- pg_exporter 0.8.0 now supports new metrics in pgbouncer 1.24.
- New Feature: Auto-completion for common commands like
git,docker,systemctl#506 #524 by @waitingsong. - Improvement: Refined
ignore_startup_parametersinpgbouncerconfig template #488 by @waitingsong. - New homepage design: Redesigned the Pigsty website.
- Extension Directory: Detailed information and download links for RPM/DEB binary packages.
- Extension Build:
pigCLI now auto-sets PostgreSQL extension build environment.
New Extensions
Added 12 PostgreSQL extensions. The total is now 404 available extensions.
- documentdb 0.101-0
- VectorChord-bm25 (vchord_bm25) 0.1.0
- pg_tracing 0.1.2
- pg_curl 2.4
- pgxicor 0.1.0
- pgsparql 1.0
- pgjq 0.1.0
- hashtypes 0.1.5
- db_migrator 1.0.0
- pg_cooldown 0.1
- pgcollection 0.9.1
- pg_bzip 1.0.0
Bump Extension
- citus 13.0.0 -> 13.0.1
- pg_duckdb 0.2.0 -> 0.3.1
- pg_mooncake 0.1.0 -> 0.1.2
- timescaledb 2.17.2 -> 2.18.2
- supautils 2.5.0 -> 2.6.0
- supabase_vault 0.3.1 (become C)
- VectorChord 0.1.0 -> 0.2.1
- pg_bulkload 3.1.22 (+pg17)
- pg_store_plan 1.8 (+pg17)
- pg_search 0.14 -> 0.15.2
- pg_analytics 0.3.0 -> 0.3.4
- pgroonga 3.2.5 -> 4.0.0
- zhparser 2.2 -> 2.3
- pg_vectorize 0.20.0 -> 0.21.1
- pg_net 0.14.0
- pg_curl 2.4.2
- table_version 1.10.3 -> 1.11.0
- pg_duration 1.0.2
- pg_graphql 1.5.9 -> 1.5.11
- vchord 0.1.1 -> 0.2.1 ((+13))
- vchord_bm25 0.1.0 -> 0.1.1
- pg_mooncake 0.1.1 -> 0.1.2
- pgddl 0.29
- pgsql_tweaks 0.11.0
Infra Updates
- pig 0.1.3 -> 0.3.0
- pushgateway 1.10.0 -> 1.11.0
- alertmanager 0.27.0 -> 0.28.0
- nginx_exporter 1.4.0 -> 1.4.1
- pgbackrest_exporter 0.18.0 -> 0.19.0
- redis_exporter 1.66.0 -> 1.67.0
- mongodb_exporter 0.43.0 -> 0.43.1
- VictoriaMetrics 1.107.0 -> 1.111.0
- VictoriaLogs v1.3.2 -> 1.9.1
- DuckDB 1.1.3 -> 1.2.0
- Etcd 3.5.17 -> 3.5.18
- pg_timetable 5.10.0 -> 5.11.0
- FerretDB 1.24.0 -> 2.0.0-rc
- tigerbeetle 0.16.13 -> 0.16.27
- grafana 11.4.0 -> 11.5.2
- vector 0.43.1 -> 0.44.0
- minio 20241218131544 -> 20250218162555
- mcli 20241121172154 -> 20250215103616
- rclone 1.68.2 -> 1.69.0
- vray 5.23 -> 5.28
v3.2.2
- New Extension(s):
Omnigres33 extensions, postgres as platform - New Extension:
pg_mooncake: duckdb in postgres - New Extensions:
pg_xxhash - New Extension:
timescaledb_toolkit - New Extension:
pg_xenophile - New Extension:
pg_drop_events - New Extension:
pg_incremental - Bump
citusto 13.0.0 with PostgreSQL 17 support. - Bump
pgmlto 2.10.0 - Bump
pg_extra_timeto 2.0.0 - Bump
pg_vectorizeto 0.20.0
What’s Changed
- Bump IvorySQL to 4.2 (PostgreSQL 17.2)
- Add Arm64 and Debian support for PolarDB kernel
- Add certbot and certbot-nginx to default
infra_packages - Increase pgbouncer max_prepared_statements to 256
- remove
pgxxx-cituspackage alias - hide
pgxxx-olapcategory inpg_extensionsby default
v3.2.1
Highlights
- 351 PostgreSQL extensions, including postgresql-anonymizer 2.0.
- IvorySQL 4.0 support for EL 8/9
- Now use the Pigsty compiled Citus, TimescaleDB and pgroonga on all distros
- Add self-hosting Odoo template and support
Bump software versions
- pig CLI 0.1.2 self-updating capability
- prometheus 3.1.0
Add New Extension
- add pg_anon 2.0.0
- add omnisketch 1.0.2
- add ddsketch 1.0.1
- add pg_duration 1.0.1
- add ddl_historization 0.0.7
- add data_historization 1.1.0
- add schedoc 0.0.1
- add floatfile 1.3.1
- add pg_upless 0.0.3
- add pg_task 1.0.0
- add pg_readme 0.7.0
- add vasco 0.1.0
- add pg_xxhash 0.0.1
Update Extension
- lower_quantile 1.0.3
- quantile 1.1.8
- sequential_uuids 1.0.3
- pgmq 1.5.0 (subdir)
- floatvec 1.1.1
- pg_parquet 0.2.0
- wrappers 0.4.4
- pg_later 0.3.0
- topn fix for deb.arm64
- add age 17 on debian
- powa + pg17, 5.0.1
- h3 + pg17
- ogr_fdw + pg17
- age + pg17 1.5 on debian
- pgtap + pg17 1.3.3
- repmgr
- topn + pg17
- pg_partman 5.2.4
- credcheck 3.0
- ogr_fdw 1.1.5
- ddlx 0.29
- postgis 3.5.1
- tdigest 1.4.3
- pg_repack 1.5.2
v3.2.0
Highlights
- New CLI: Added the
pigcommand-line tool to manage extensions. - ARM64 Support: 390 extensions are now available for ARM64 across five major distributions.
- Supabase Update: Latest Supabase Release Week updates are now supported for self-hosting on all distributions.
- Grafana v11.4: Upgraded Grafana to 11.4 and added an Infinity datasource.
Package Changes
- New Extensions
- Added
timescaledb,timescaledb-loader,timescaledb-toolkit, andtimescaledb-toolto the PIGSTY repository. - Added a custom-compiled pg_timescaledb for EL.
- Added pgroonga, custom-compiled for all EL variants.
- Added vchord 0.1.0.
- Added pg_bestmatch.rs 0.0.1.
- Added pglite_fusion 0.0.3.
- Added pgpdf 0.1.0.
- Updated Extensions
- pgvectorscale: 0.4.0 → 0.5.1
- pg_parquet: 0.1.0 → 0.1.1
- pg_polyline: 0.0.1
- pg_cardano: 1.0.2 → 1.0.3
- pg_vectorize: 0.20.0
- pg_duckdb: 0.1.0 → 0.2.0
- pg_search: 0.13.0 → 0.13.1
- aggs_for_vecs: 1.3.1 → 1.3.2
- Infrastructure
- Added promscale 0.17.0
- Added grafana-plugins 11.4
- Added grafana-infinity-plugins
- Added grafana-victoriametrics-ds
- Added grafana-victorialogs-ds
- vip-manager: 2.8.0 → 3.0.0
- vector: 0.42.0 → 0.43.0
- grafana: 11.3 → 11.4
- prometheus: 3.0.0 → 3.0.1 (package name changed from
prometheus2toprometheus) - nginx_exporter: 1.3.0 → 1.4.0
- mongodb_exporter: 0.41.2 → 0.43.0
- VictoriaMetrics: 1.106.1 → 1.107.0
- VictoriaLogs: 1.0.0 → 1.3.2
- pg_timetable: 5.9.0 → 5.10.0
- tigerbeetle: 0.16.13 → 0.16.17
- pg_export: 0.7.0 → 0.7.1
- New Docker App
- Add mattermost the open-source Slack alternative self-hosting template
- Bug Fixes
- Added
python3-cdiffforel8.aarch64to fix missing Patroni dependency. - Added
timescaledb-toolsforel9.aarch64to fix missing package in official repo. - Added
pg_filedumpforel9.aarch64to fix missing package in official repo. - Removed Extensions
- pg_mooncake: Removed due to conflicts with
pg_duckdb. - pg_top: Removed because of repeated version issues and quality concerns.
- hunspell_pt_pt: Removed because of conflict with official PG dictionary files.
- pgml: Disabled by default (no longer downloaded or installed).
API Changes
repo_url_packagesnow defaults to an empty array. OS package managers install the packages.- Deprecated
grafana_plugin_cache. OS package managers now install Grafana plugins. grafana_plugin_listis deprecated for the same reason.- The 36-node “production” template has been renamed to
simu. - Auto-generated code under
node_id/varsnow includesaarch64support. infra_packagesnow includes thepigCLI tool.- The
configurecommand now updates the version numbers ofpgsql-xxxaliases in auto-generated config files. - Updated Terraform templates with Makefile shortcuts and improved provisioning.
Bug Fix
- Fix pgbouncer dashboard selector issue #474
- Add
--arg valuesupport forpg-pitrby @waitingsong - Fix redis log message typo by @waitingsong
Checksums
v3.1.0
2024-11-24 : ARM64 & Ubuntu24, PG17 by Default, Better Supabase & MinIO
https://github.com/pgsty/pigsty/releases/tag/v3.1.0
v3.0.4
2024-10-28 : PostgreSQL 17 Extensions, Better self-hosting Supabase
https://github.com/pgsty/pigsty/releases/tag/v3.0.4
v3.0.3
2024-09-27 : PostgreSQL 17, Etcd Enhancement, IvorySQL 3.4, PostGIS 3.5
https://github.com/pgsty/pigsty/releases/tag/v3.0.3
v3.0.2
2024-09-07 : Mini Install, PolarDB 15, Bloat View Update
https://github.com/pgsty/pigsty/releases/tag/v3.0.2
v3.0.1
2024-08-31 : Oracle Compatibility, Patroni 4.0, Routine Bug Fix
https://github.com/pgsty/pigsty/releases/tag/v3.0.1
v3.0.0
2024-08-30 : More extensions and pluggable kernels (MSSQL, Oracle)
https://github.com/pgsty/pigsty/releases/tag/v3.0.0
v2.7.0
2024-05-16 : More extensions and new Docker apps
https://github.com/pgsty/pigsty/releases/tag/v2.7.0
v2.6.0
2024-02-29 : PG 16 as default version, ParadeDB & DuckDB
https://github.com/pgsty/pigsty/releases/tag/v2.6.0
v2.5.1
2023-12-01 : Routine update, pg16 major extensions
https://github.com/pgsty/pigsty/releases/tag/v2.5.1
v2.5.0
2023-10-24 : Ubuntu/Debian Support: bullseye, bookworm, jammy, focal
https://github.com/pgsty/pigsty/releases/tag/v2.5.0
v2.4.1
2023-09-24 : Supabase/PostgresML support, graphql, jwt, pg_net, vault
https://github.com/pgsty/pigsty/releases/tag/v2.4.1
v2.4.0
2023-09-14 : PG16, RDS Monitor, New Extensions
https://github.com/pgsty/pigsty/releases/tag/v2.4.0
v2.3.1
2023-09-01 : PGVector with HNSW, PG16 RC1, Chinese Docs, Bug Fix
https://github.com/pgsty/pigsty/releases/tag/v2.3.1
v2.3.0
2023-08-20 : PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub
https://github.com/pgsty/pigsty/releases/tag/v2.3.0
v2.2.0
2023-08-04 : Dashboard & Provision overhaul, UOS compatibility
https://github.com/pgsty/pigsty/releases/tag/v2.2.0
v2.1.0
2023-06-10 : PostgreSQL 12 ~ 16beta support
https://github.com/pgsty/pigsty/releases/tag/v2.1.0
v2.0.2
2023-03-31 : Add pgvector support and fix MinIO CVE
https://github.com/pgsty/pigsty/releases/tag/v2.0.2
v2.0.1
2023-03-21 : v2 bug fixes, security improvements, and a Grafana version update
https://github.com/pgsty/pigsty/releases/tag/v2.0.1
v2.0.0
2023-02-28 : Compatibility, security, and maintainability improvements
https://github.com/pgsty/pigsty/releases/tag/v2.0.0
v1.5.1
2022-06-18 : Grafana Security Hotfix
https://github.com/pgsty/pigsty/releases/tag/v1.5.1
v1.5.0
2022-05-31 : Docker Applications
https://github.com/pgsty/pigsty/releases/tag/v1.5.0
v1.4.1
2022-04-20 : Bug fixes and complete English documentation translation.
https://github.com/pgsty/pigsty/releases/tag/v1.4.1
v1.4.0
2022-03-31 : MatrixDB Support, Separated INFRA, NODES, PGSQL, REDIS
https://github.com/pgsty/pigsty/releases/tag/v1.4.0
v1.3.0
2021-11-30 : PGCAT Overhaul & PGSQL Enhancement & Redis Support Beta
https://github.com/pgsty/pigsty/releases/tag/v1.3.0
v1.2.0
2021-11-03 : PostgreSQL 14 as the default, plus monitoring for existing PG instances
https://github.com/pgsty/pigsty/releases/tag/v1.2.0
v1.1.0
2021-10-12 : HomePage, JupyterLab, PGWEB, Pev2 & Pgbadger
https://github.com/pgsty/pigsty/releases/tag/v1.1.0
v1.0.0
2021-07-26 : v1 GA, Monitoring System Overhaul
https://github.com/pgsty/pigsty/releases/tag/v1.0.0
v0.9.0
2021-04-04 : Pigsty GUI, CLI, Logging Integration
https://github.com/pgsty/pigsty/releases/tag/v0.9.0
v0.8.0
2021-03-28 : Service Provision
https://github.com/pgsty/pigsty/releases/tag/v0.8.0
v0.7.0
2021-03-01 : Monitor only deployment
https://github.com/pgsty/pigsty/releases/tag/v0.7.0
v0.6.0
2021-02-19 : Architecture Enhancement
https://github.com/pgsty/pigsty/releases/tag/v0.6.0
v0.5.0
2021-01-07 : Database customization template
https://github.com/pgsty/pigsty/releases/tag/v0.5.0
v0.4.0
2020-12-14 : PostgreSQL 13 Support, Official Documentation
https://github.com/pgsty/pigsty/releases/tag/v0.4.0
v0.3.0
2020-10-22 : Provisioning Solution GA
https://github.com/pgsty/pigsty/releases/tag/v0.3.0
v0.2.0
2020-07-10 : PGSQL Monitoring v6 GA
https://github.com/pgsty/pigsty/commit/385e33a62a19817e8ba19997260e6b77d99fe2ba
v0.1.0
2020-06-20 : Validation in a test environment
https://github.com/pgsty/pigsty/commit/1cf2ea5ee91db071de00ec805032928ff582453b
v0.0.5
2020-08-19 : Offline Installation Mode
https://github.com/pgsty/pigsty/commit/0fe9e829b298fe5e56307de3f78c95071de28245
v0.0.4
2020-07-27 : Refactor playbooks into ansible roles
https://github.com/pgsty/pigsty/commit/90b44259818d2c71e37df5250fe8ed1078a883d0
v0.0.3
2020-06-22 : Interface enhancement
https://github.com/pgsty/pigsty/commit/4c5c68ccd57bc32a9e9c98aa3f264aa19f45c7ee
v0.0.2
2020-04-30 : First Commit
https://github.com/pgsty/pigsty/commit/dd646775624ddb33aef7884f4f030682bdc371f8
v0.0.1
2019-05-15 : POC
https://github.com/Vonng/pg/commit/fa2ade31f8e81093eeba9d966c20120054f0646b
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)