# Release Note > Pigsty historical version release notes --- LLMS index: [llms.txt](/llms.txt) --- The latest Pigsty release is [**v4.5.0**](#v450). | Version | Release Date | Summary | Release Page | |:---------------:|:------------:|---------------------------------------------------------------------------------|:-----------------------------------------------------------------------------------------:| | [v4.5.0](#v450) | 2026-08-15 | Silo, Kafka, MySQL, Valkey, 575 extensions, and safer orchestration | [v4.5.0](https://github.com/pgsty/pigsty/releases/tag/v4.5.0) | | [v4.4.0](#v440) | 2026-07-10 | PG 19 beta support, 531 extensions, kernel updates, pig CLI improvements | [v4.4.0](https://github.com/pgsty/pigsty/releases/tag/v4.4.0) | | [v4.3.0](#v430) | 2026-05-01 | 510 extensions, batch Infra / PGSQL / kernel package updates, Ubuntu 26 support | [v4.3.0](https://github.com/pgsty/pigsty/releases/tag/v4.3.0) | | [v4.2.2](#v422) | 2026-03-23 | Insforge template, pdu, pgdog, tigerfs, ivorysql 5.3 | [v4.2.2](https://github.com/pgsty/pigsty/releases/tag/v4.2.2) | | [v4.2.1](#v421) | 2026-03-06 | Maintenance release: 3 new extensions, drop PG13, bug fixes | [v4.2.1](https://github.com/pgsty/pigsty/releases/tag/v4.2.1) | | [v4.2.0](#v420) | 2026-02-28 | Routine minor release with six PG kernel updates | [v4.2.0](https://github.com/pgsty/pigsty/releases/tag/v4.2.0) | | [v4.1.0](#v410) | 2026-02-12 | Major/minor upgrade support, Agent-Native CLI, stricter default firewall policy | [v4.1.0](https://github.com/pgsty/pigsty/releases/tag/v4.1.0) | | [v4.0.0](#v400) | 2026-01-28 | Observability revolution, security hardening, JUICE/VIBE modules, Apache-2.0 | [v4.0.0](https://github.com/pgsty/pigsty/releases/tag/v4.0.0) | | [v3.7.0](#v370) | 2025-12-02 | PG18 default, 437 extensions, EL10 & Debian 13 support, PGEXT.CLOUD | [v3.7.0](https://github.com/pgsty/pigsty/releases/tag/v3.7.0) | | [v3.6.1](#v361) | 2025-08-15 | Routine PG minor updates, PGDG China mirror, EL10/D13 stubs | [v3.6.1](https://github.com/pgsty/pigsty/releases/tag/v3.6.1) | | [v3.6.0](#v360) | 2025-07-30 | pgactive, MinIO/ETCD improvements, simplified install, config cleanup | [v3.6.0](https://github.com/pgsty/pigsty/releases/tag/v3.6.0) | | [v3.5.0](#v350) | 2025-06-16 | PG18 beta, 421 extensions, monitoring upgrade, code refactor | [v3.5.0](https://github.com/pgsty/pigsty/releases/tag/v3.5.0) | | [v3.4.1](#v341) | 2025-04-05 | OpenHalo & OrioleDB, MySQL compatibility, pgAdmin improvements | [v3.4.1](https://github.com/pgsty/pigsty/releases/tag/v3.4.1) | | [v3.4.0](#v340) | 2025-03-30 | Backup improvements, auto certs, AGE, IvorySQL all platforms | [v3.4.0](https://github.com/pgsty/pigsty/releases/tag/v3.4.0) | | [v3.3.0](#v330) | 2025-02-24 | 404 extensions, extension directory, App playbook, Nginx customization | [v3.3.0](https://github.com/pgsty/pigsty/releases/tag/v3.3.0) | | [v3.2.2](#v322) | 2025-01-23 | 390 extensions, Omnigres, Mooncake, Citus 13 & PG17 support | [v3.2.2](https://github.com/pgsty/pigsty/releases/tag/v3.2.2) | | [v3.2.1](#v321) | 2025-01-12 | 350 extensions, Ivory4, Citus enhancements, Odoo template | [v3.2.1](https://github.com/pgsty/pigsty/releases/tag/v3.2.1) | | [v3.2.0](#v320) | 2024-12-24 | Extension CLI, Grafana enhancements, ARM64 extension completion | [v3.2.0](https://github.com/pgsty/pigsty/releases/tag/v3.2.0) | | [v3.1.0](#v310) | 2024-11-24 | PG17 default, config simplification, Ubuntu24 & ARM support | [v3.1.0](https://github.com/pgsty/pigsty/releases/tag/v3.1.0) | | [v3.0.4](#v304) | 2024-10-30 | PG17 extensions, OLAP suite, pg_duckdb | [v3.0.4](https://github.com/pgsty/pigsty/releases/tag/v3.0.4) | | [v3.0.3](#v303) | 2024-09-27 | PostgreSQL 17, Etcd improvements, IvorySQL 3.4, PostGIS 3.5 | [v3.0.3](https://github.com/pgsty/pigsty/releases/tag/v3.0.3) | | [v3.0.2](#v302) | 2024-09-07 | Mini install mode, PolarDB 15 support, monitoring view updates | [v3.0.2](https://github.com/pgsty/pigsty/releases/tag/v3.0.2) | | [v3.0.1](#v301) | 2024-08-31 | Routine bug fixes, Patroni 4 support, Oracle compatibility improvements | [v3.0.1](https://github.com/pgsty/pigsty/releases/tag/v3.0.1) | | [v3.0.0](#v300) | 2024-08-25 | 333 extensions, pluggable kernels, MSSQL/Oracle/PolarDB compatibility | [v3.0.0](https://github.com/pgsty/pigsty/releases/tag/v3.0.0) | | [v2.7.0](#v270) | 2024-05-20 | Extension explosion, 20+ new powerful extensions, Docker apps | [v2.7.0](https://github.com/pgsty/pigsty/releases/tag/v2.7.0) | | [v2.6.0](#v260) | 2024-02-28 | PG16 as default, ParadeDB & DuckDB extensions introduced | [v2.6.0](https://github.com/pgsty/pigsty/releases/tag/v2.6.0) | | [v2.5.1](#v251) | 2023-12-01 | Routine minor update, PG16 key extension support | [v2.5.1](https://github.com/pgsty/pigsty/releases/tag/v2.5.1) | | [v2.5.0](#v250) | 2023-09-24 | Ubuntu/Debian support: bullseye, bookworm, jammy, focal | [v2.5.0](https://github.com/pgsty/pigsty/releases/tag/v2.5.0) | | [v2.4.1](#v241) | 2023-09-24 | Supabase/PostgresML support with graphql, jwt, pg_net, vault | [v2.4.1](https://github.com/pgsty/pigsty/releases/tag/v2.4.1) | | [v2.4.0](#v240) | 2023-09-14 | PG16, RDS monitoring, new extensions: FTS/graph/HTTP/embedding | [v2.4.0](https://github.com/pgsty/pigsty/releases/tag/v2.4.0) | | [v2.3.1](#v231) | 2023-09-01 | PGVector with HNSW, PG16 RC1, doc refresh, Chinese docs, bug fixes | [v2.3.1](https://github.com/pgsty/pigsty/releases/tag/v2.3.1) | | [v2.3.0](#v230) | 2023-08-20 | Node VIP, FerretDB, NocoDB, MySQL stub, CVE fixes | [v2.3.0](https://github.com/pgsty/pigsty/releases/tag/v2.3.0) | | [v2.2.0](#v220) | 2023-08-04 | Dashboard & provisioning overhaul, UOS compatibility | [v2.2.0](https://github.com/pgsty/pigsty/releases/tag/v2.2.0) | | [v2.1.0](#v210) | 2023-06-10 | PostgreSQL 12-16beta support | [v2.1.0](https://github.com/pgsty/pigsty/releases/tag/v2.1.0) | | [v2.0.2](#v202) | 2023-03-31 | Added pgvector support, fixed MinIO CVE | [v2.0.2](https://github.com/pgsty/pigsty/releases/tag/v2.0.2) | | [v2.0.1](#v201) | 2023-03-21 | v2 bug fixes, security enhancements, Grafana upgrade | [v2.0.1](https://github.com/pgsty/pigsty/releases/tag/v2.0.1) | | [v2.0.0](#v200) | 2023-02-28 | Major architecture upgrade, compatibility/security/maintainability | [v2.0.0](https://github.com/pgsty/pigsty/releases/tag/v2.0.0) | | [v1.5.1](#v151) | 2022-06-18 | Grafana security hotfix | [v1.5.1](https://github.com/pgsty/pigsty/releases/tag/v1.5.1) | | [v1.5.0](#v150) | 2022-05-31 | Docker application support | [v1.5.0](https://github.com/pgsty/pigsty/releases/tag/v1.5.0) | | [v1.4.1](#v141) | 2022-04-20 | Bug fixes & full English documentation translation | [v1.4.1](https://github.com/pgsty/pigsty/releases/tag/v1.4.1) | | [v1.4.0](#v140) | 2022-03-31 | MatrixDB support, separated INFRA/NODES/PGSQL/REDIS modules | [v1.4.0](https://github.com/pgsty/pigsty/releases/tag/v1.4.0) | | [v1.3.0](#v130) | 2021-11-30 | PGCAT overhaul & PGSQL enhancement & Redis beta support | [v1.3.0](https://github.com/pgsty/pigsty/releases/tag/v1.3.0) | | [v1.2.0](#v120) | 2021-11-03 | Default PGSQL version upgraded to 14 | [v1.2.0](https://github.com/pgsty/pigsty/releases/tag/v1.2.0) | | [v1.1.0](#v110) | 2021-10-12 | Homepage, JupyterLab, PGWEB, Pev2 & pgbadger | [v1.1.0](https://github.com/pgsty/pigsty/releases/tag/v1.1.0) | | [v1.0.0](#v100) | 2021-07-26 | v1 GA, Monitoring System Overhaul | [v1.0.0](https://github.com/pgsty/pigsty/releases/tag/v1.0.0) | | [v0.9.0](#v090) | 2021-04-04 | Pigsty GUI, CLI, Logging Integration | [v0.9.0](https://github.com/pgsty/pigsty/releases/tag/v0.9.0) | | [v0.8.0](#v080) | 2021-03-28 | Service Provision | [v0.8.0](https://github.com/pgsty/pigsty/releases/tag/v0.8.0) | | [v0.7.0](#v070) | 2021-03-01 | Monitor only deployment | [v0.7.0](https://github.com/pgsty/pigsty/releases/tag/v0.7.0) | | [v0.6.0](#v060) | 2021-02-19 | Architecture Enhancement | [v0.6.0](https://github.com/pgsty/pigsty/releases/tag/v0.6.0) | | [v0.5.0](#v050) | 2021-01-07 | Database Customize Template | [v0.5.0](https://github.com/pgsty/pigsty/releases/tag/v0.5.0) | | [v0.4.0](#v040) | 2020-12-14 | PostgreSQL 13 Support, Official Documentation | [v0.4.0](https://github.com/pgsty/pigsty/releases/tag/v0.4.0) | | [v0.3.0](#v030) | 2020-10-22 | Provisioning Solution GA | [v0.3.0](https://github.com/pgsty/pigsty/releases/tag/v0.3.0) | | v0.2.0 | 2020-07-10 | PGSQL Monitoring v6 GA | [v0.2.0](https://github.com/pgsty/pigsty/commit/385e33a62a19817e8ba19997260e6b77d99fe2ba) | | v0.1.0 | 2020-06-20 | Validation on Testing Environment | [v0.1.0](https://github.com/pgsty/pigsty/commit/1cf2ea5ee91db071de00ec805032928ff582453b) | | v0.0.5 | 2020-08-19 | Offline Installation Mode | [v0.0.5](https://github.com/pgsty/pigsty/commit/0fe9e829b298fe5e56307de3f78c95071de28245) | | v0.0.4 | 2020-07-27 | Refactor playbooks into Ansible roles | [v0.0.4](https://github.com/pgsty/pigsty/commit/90b44259818d2c71e37df5250fe8ed1078a883d0) | | v0.0.3 | 2020-06-22 | Interface enhancement | [v0.0.3](https://github.com/pgsty/pigsty/commit/4c5c68ccd57bc32a9e9c98aa3f264aa19f45c7ee) | | v0.0.2 | 2020-04-30 | First Commit | [v0.0.2](https://github.com/pgsty/pigsty/commit/dd646775624ddb33aef7884f4f030682bdc371f8) | | v0.0.1 | 2019-05-15 | POC | [v0.0.1](https://github.com/Vonng/pg/commit/fa2ade31f8e81093eeba9d966c20120054f0646b) | {.full-width-full .release-index} ------ ## v4.5.0 Pigsty v4.5.0 is a feature release focused on new pilot modules, replaceable data services, cluster-identity-aware orchestration, observability, and the software supply chain. It introduces Kafka KRaft and MySQL 8.4 modules, adds Valkey to REDIS, converges the MINIO module on Silo, and expands the packaged extension catalog from 531 to 575 extensions. Released on **2026-08-15**. See the [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v4.5.0) and the complete source comparison at [`v4.4.0...v4.5.0`](https://github.com/pgsty/pigsty/compare/v4.4.0...v4.5.0). **Highlights** - **575 extensions:** Compared with v4.4.0's 531 entries, the current catalog adds 46 and removes 2, for a net gain of 44. It now contains 575 extensions across 406 non-contrib package families, with RPM/DEB coverage tracked per platform. - **Kafka KRaft module:** Adds native Pigsty orchestration for Kafka, with multi-cluster support, 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, MySQL Router, XtraBackup, user and database provisioning, monitoring and alerting, and idempotent reconciliation. - **Valkey and Silo:** REDIS adds `redis_type: valkey`; the final MINIO source accepts only `minio_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-node `ha/octo` simulation template to the 48 standalone templates in v4.4.0. The compatibility symlink `conf/app/supa.yml` → `../supabase.yml` remains available. - **Safer cluster-identity orchestration:** PGSQL, REDIS, MINIO, KAFKA, and MYSQL initialization playbooks, plus every corresponding removal playbook except `mysql-rm.yml`, skip unrelated hosts by explicit cluster identity. `mysql-rm.yml` instead fails closed for any wrongly selected host. etcd delegation and DBSU key exchange now use actual cluster members as well. - **Observability and supply chain:** Re-exports Grafana dashboards to Dashboard API v2, moves MinIO/Silo collection to Metrics V3, and generates local repositories atomically with SOW instead of synthetic ModuleMD metadata. - **Kernel and toolchain updates:** Completes pgBackRest support for PostgreSQL 19 beta2, enables cluster mode for Percona PostgreSQL TDE, fixes IvorySQL initialization and WAL compression, and refreshes extension package maps, exporters, and build tooling. **New Modules and Data Services** - The [Kafka module](/docs/kafka/) uses node state as the source of truth for dynamic KRaft orchestration. It manages one or more clusters in one inventory and also supports an unbounded `kafka.yml` run; partial `--limit` selections are rejected. The destructive `kafka-rm.yml` instead requires a non-empty `-l/--limit` and validates a safe absolute data path plus surviving broker/controller anchors before any partial retirement can stop services. Nodes retain authoritative manifests and secrets, with dynamic controller joins, broker admission, member retirement, three-step dead-node replacement, SCRAM-SHA-512/TLS, credential and certificate rotation, and self-tested partition health gates. - The [MySQL pilot module](/docs/mysql/) targets a fixed MySQL 8.4 LTS platform and accepts either a standalone node or a three-node InnoDB Cluster. It includes MySQL Shell and Router, scheduled full XtraBackup backups, TLS, account and database provisioning, primary-key policy checks, conservative member removal, and idempotent reconciliation. - The REDIS module retains `redis` as its default engine and can deploy Valkey with `redis_type: valkey`. Service units now use `Type=notify` with a 1,800-second startup timeout, plus stronger topology validation, password handling, tag-scoped removal semantics, and rebuild protection. - The MINIO module now deploys Silo and only Silo. `minio_type` remains an extension point, but `silo` is the sole accepted value in this release. Startup checks the systemd Invocation ID and `ActiveState=active` for the current restart, waits about 600 seconds by default, and then runs Silo's cluster health check. The Infra package line adds `silo` and `mcli` while preserving the S3/Admin APIs, `/minio/*` routes, `MINIO_*` environment variables, and disk format. - Object-storage topology is grouped by `minio_cluster`; its inventory group name may differ, and one inventory may declare multiple object-storage clusters. Use distinct `minio_alias`, `minio_domain`, and `minio_endpoint` values for each to avoid overwriting shared client aliases on INFRA nodes. `demo/minio` now selects Silo explicitly and trims its local repository to the `infra,node` modules. - The standalone FERRET module is replaced by [PostgreSQL Mongo mode](/docs/conf/mongo/) and the [FerretDB Docker APP](/docs/app/ferretdb/). PostgreSQL provides the DocumentDB data layer, while Docker Compose provides the FerretDB protocol layer. **Orchestration, Security, and Tooling** - `deploy.yml`, `slim.yml`, and the PGSQL, REDIS, MINIO, KAFKA, and MYSQL initialization playbooks now skip unrelated hosts according to the corresponding `*_cluster` identity. The PGSQL, REDIS, MINIO, and KAFKA removal playbooks do the same. MySQL removal is intentionally different: `mysql-rm.yml` does not skip hosts without identity and instead fails closed in `mysql_rm_check`. Every host that enters a role still receives an internal identity check. - PGSQL configuration, PITR, and removal workflows delegate only when the canonical `etcd` group exists and has at least one member; they no longer silently fall back to localhost when no etcd target exists. DBSU SSH keys are exchanged through the actual `pg_cluster_members`, correctly covering cross-inventory-group topologies such as Citus. - PGSQL PITR and removal now delete only the etcd subtree bounded by `//`, avoiding adjacent clusters whose names share a prefix. The initial pgBackRest marker `/etc/pgbackrest/initial.done` is written only after the backup command succeeds. - HAProxy uses the fixed `/etc/haproxy/haproxy.cfg` and `/etc/haproxy/conf.d` layout, upstream master-worker mode, a master socket, and `Type=notify`. dnsmasq now binds dynamically, answers private reverse lookups locally, and handles node addresses added after INFRA initialization. - Rendered systemd units managed by Pigsty are consistently placed under `/etc/systemd/system`; permissions on sensitive configuration and privileged files are tightened further. Removal workflows stop services before entering the data-cleanup phase. - The REPO and CACHE roles now use `sow create --pigsty` to atomically generate RPM/APT metadata and the SHA-256 `repo_complete` marker, and no longer generate synthetic ModuleMD metadata. `pg_id` also 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 now use the OS-specific directory: `/etc/tuned/profiles` on EL 10, Debian 13, and Ubuntu 26, and `/etc/tuned` on EL 8/9, Debian 12, and Ubuntu 22/24. Debian/Ubuntu package installation also suppresses premature starts of Silo, Redis/Valkey, and legacy log services. - China-region repository routing receives a systematic refresh. 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. The final per-platform choices remain defined in `roles/node_id/vars/..yml`. - The Docker image moves to Debian 13.6 and Pigsty v4.5.0. Vagrant enforces a 32 GiB root disk, accepts pinned box versions, and adds the eight-node `ha/octo` lab. `docker/Makefile` fixes its data directory at `./data`, and `make purge` deletes 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.yml` from `conf/meta.yml`, include the Kafka/MySQL playbooks, and drop the legacy Mongo playbook. - The release-signing workflow must be dispatched from `main` and signs only the `pigsty-.tgz` source archive; multi-gigabyte offline bundles are outside that workflow. The package-build bootstrap matrix now matches `conf/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/v3` root endpoint and drops high-cardinality samples carrying a non-empty `bucket` label. - Updates the `pg_exporter` configuration to 1.4.0 and fixes duplicate time series from the 1.4.1 `pg_subrel` query. For PG19 it adds `pg_sub_19`, `pg_recovery_state`, `pg_wal_19`, `pg_lock_stat`, and `pg_vacuum_score`; PG10+ gains the `pg_xact_age` transaction-age histogram, and replication-slot `idle_timeout` plus WAL Receiver `connecting` state encoding are covered. Kafka JMX/protocol exporters and the MySQL exporter also 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 the 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. - The PostgreSQL fact loader, per-platform `package_map`, and default extension groups are refreshed to fill package gaps and correct PGDG/YUM naming. Comparing names between the v4.4.0 PIG v1.5.1 catalog and the current catalog yields 46 additions and 2 removals: - 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`, and `qdgc`. - 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`, and `qdgc_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_analytics` and `spat`. The total therefore rises from 531 to 575, a net gain of 44. - Cumulative notable upgrades include `citus` 14.2.0, `pg_search` 0.25.2, `timescaledb` 2.29.1, `vector` 0.8.6, `documentdb` 0.114, `pg_partman` 5.5.0, `pgmnemo` 0.16.1, `plpgsql_check` 2.10.4, `provsql` 1.12.0, and `pgbson` 2.1.0, plus a broad pgrx 0.19.1 rebuild. - Full build records and platform differences appear in the merged table below and the original [RPM changelog](/docs/repo/pgsql/rpm/) and [DEB changelog](/docs/repo/pgsql/deb/). New catalog entries include [`pg_local_cache`](/ext/e/pg_local_cache/) and [`pg_policy`](/ext/e/pg_policy/). Changelog dates identify package batches and should not be equated one-for-one with the current CSV `mtime`. - `pg_statviz` is excluded only from the default install group in [`db/reload.sql`](https://github.com/pgsty/pgext/blob/main/db/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](/docs/repo/pgsql/rpm/) and [DEB changelog](/docs/repo/pgsql/deb/) after v4.4.0, with 231 rows aligned by batch and extension name. Records that are identical in RPM and DEB are merged; version or note differences are shown 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. That original batch covers July 7–24 without per-item dates, so it is included in full to avoid omitting post-release pgrx rebuilds and package-matrix fixes. “RPM only” or “DEB only” means only that the other changelog has no same-batch row for that extension. | 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 only
DEB: 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-18
DEB: 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.9`
DEB: `-` → `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.5`
DEB: `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.0`
DEB: `4.7.1` → `5.0.0` | RPM: Renamed to `e-maj`; Provides/Obsoletes `emaj`; r2
DEB: 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.0`
DEB: `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 | {.stretch-last} **Infrastructure Package Update Log** The following table contains all 144 Infra log records after v4.4.0, from 2026-07-16 through the latest 2026-08-12 batch. It also includes the `ferretdb2` rebuild and RPM exporter package-name migration recorded in the changelog prose. Consecutive upgrades of the same package are retained as separate batch entries. Build, download, and verification status follows the wording of the original log; it does not establish repository indexing, signing, synchronization, or offline-bundle acceptance. See the [Infra changelog](/docs/repo/infra/log/) for full context. | 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 | {.stretch-last} **Compatibility Changes and Upgrade Notes** - Existing FERRET deployments should remove the legacy `ferretdb` systemd service and redeploy the protocol layer with `docker.yml` and `app.yml`. The old `mongo.yml` playbook, `mongo_*` parameters, scrape job, and dedicated dashboard are no longer provided. - Pigsty no longer renders `/etc/default/haproxy` for the HAProxy unit, although the unit can read it when present. Use only `EXTRAOPTS` for process arguments, not `OPTIONS`. Any `EXTRAOPTS` override must retain `-S /run/haproxy-master.sock` and must not include `-f`. - New module playbooks require target hosts to define the corresponding `pg_cluster`, `redis_cluster`, `minio_cluster`, `kafka_cluster`, or `mysql_cluster` explicitly. Custom inventories that relied on fixed group names without cluster identity variables must add those identities first. - The MINIO role now accepts only `minio_type: silo`; `minio` and `rustfs` fail during identity validation. Silo retains MinIO protocol and on-disk compatibility, but the package, binary, and systemd service names change. Back up existing object storage and validate in-place compatibility and rollback before upgrading; do not treat package replacement as a migration that has already passed acceptance. - Valkey remains opt-in. `redis_type: valkey` installs `valkey-server` and `valkey-cli`, while configuration paths, service names, monitoring jobs, and other module-facing interfaces remain under `redis` for compatibility. - Pigsty's core REPO/CACHE roles require SOW and use `sow create --pigsty` to generate local repositories. Older offline bundles or local repositories without SOW 0.3.0 must first install or refresh it from the Pigsty INFRA repository. `pig repo create` is a separate CLI path whose fallback behavior depends on its own version. - MySQL `mysql_databases` entries accept only `name`, `encoding`, and `collate`, and databases are created with `DEFAULT ENCRYPTION='N'`. `mysql_parameters` cannot use `loose_`, `skip_`, `disable_`, or `enable_` prefixes to bypass platform-owned, replication, or TLS option protection. - Custom RPM repositories and external automation that still reference underscore names such as `node_exporter` or `redis_exporter` must move to the hyphenated `node-exporter` and `redis-exporter` package names. - `docker/Makefile` no longer accepts `DATA` to redirect the cleanup target. `make purge` deletes repository-local `./data` immediately without a countdown; preserve any required data first. - KAFKA and MYSQL remain pilot modules. Kafka clients must resolve and reach each broker directly rather than putting the data plane behind HAProxy, a VIP, or an L4 load balancer. MySQL currently accepts exactly one or three members. All 14 validated offline artifacts are published on GitHub for this release, one per [**recommended OS version**](/docs/ref/linux/) and architecture, alongside a `checksums` manifest and a detached PGP signature (`.asc`) for every file. **Checksums** ```bash e042059379bdfae8f774022b89e8d1e3 pigsty-pkg-v4.5.0.el9.aarch64.tgz 997e812a433a6b969b976fad2c023a1f pigsty-pkg-v4.5.0.el9.x86_64.tgz 1e1045db965282d564680534bd7d72e2 pigsty-pkg-v4.5.0.el10.aarch64.tgz 9a53f1e85cbb2d4f85969a6112ae4b05 pigsty-pkg-v4.5.0.el10.x86_64.tgz b7501783c90311176f21bdd35390c746 pigsty-pkg-v4.5.0.d12.aarch64.tgz f3ecaa449a0bf8e0f01907f83831e74a pigsty-pkg-v4.5.0.d12.x86_64.tgz 863165dba76b044ed8615d6743710005 pigsty-pkg-v4.5.0.d13.aarch64.tgz d86655361ccad7aa95a345a82bb37d10 pigsty-pkg-v4.5.0.d13.x86_64.tgz 017f2d7931eb644d2d0fa2f71930134e pigsty-pkg-v4.5.0.u26.aarch64.tgz 61451ee610134423ff08f1a69dfced33 pigsty-pkg-v4.5.0.u26.x86_64.tgz 5d9cfc52a25545b56e73e94ab5b5e175 pigsty-pkg-v4.5.0.u24.aarch64.tgz dba0eef49899509d1524b3a1c37d0ddc pigsty-pkg-v4.5.0.u24.x86_64.tgz 5564841c7c099489708cd1fe49ffa1b9 pigsty-pkg-v4.5.0.u22.aarch64.tgz dc52b6cee50cf6226e23b065e5aa8395 pigsty-pkg-v4.5.0.u22.x86_64.tgz afb5cd77903613cb945bd519e4059c76 pigsty-v4.5.0.tgz ``` ------ ## v4.4.0 Pigsty v4.4.0 is a maintenance release centered on PostgreSQL 18.4, PostgreSQL 19 beta readiness, 531 extensions, refreshed kernel variants, and broader platform coverage. Released on **2026-07-10**. See the [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v4.4.0) and [all changes since v4.3.0](https://github.com/pgsty/pigsty/compare/v4.3.0...v4.4.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:** New clone, fork, and PITR workflows arrive alongside automatic VIP discovery, Zstandard pgBackRest compression, and dedicated Patroni log collection. - **Security, applications, and tooling:** Secret handling and repository automation are hardened, with new app templates, a redesigned portal, and optional Codex support. - **Platform validation:** All 14 offline deployment tests pass across seven OS baselines on both `x86_64` and `aarch64`. - **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`; preserve intentional local overrides before re-rendering them. [#744](https://github.com/pgsty/pigsty/issues/744) - Patroni logs now use `/pg/log/patroni` and `job=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. - `pig` automation must use `-y/--yes` for destructive commands, while `pig pb restore` and `pig pitr` require one explicit recovery target. See the [`pig` v1.5](https://pigsty.io/docs/pig/release/#v150) notes. - Supabase analytics moves to the `_supabase` database and `_analytics` schema; existing deployments should create them before switching stacks. **Security and Operations** - The `pg-pitr` wrapper adds safer target selection, timelines, dry runs, and stronger checks against unsafe recovery targets. - Application secrets are hidden from Ansible output, generated `.env` files use mode `0600`, and Grafana no longer prints the administrator password. - The `dbsu` sudo policy gains controlled journal access, while 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 and added opt-in 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](https://github.com/pgsty/pigsty/issues/752) - Reused an existing `/www` directory during bootstrap and fixed Redis Sentinel HA password rendering. [#753](https://github.com/pgsty/pigsty/issues/753) [#748](https://github.com/pgsty/pigsty/issues/748) - Corrected RPM naming and package groups for `pg_http`, `pg_gzip`, `apache-age`, and `odbc_fdw`. [#750](https://github.com/pgsty/pigsty/issues/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, updates the PostgreSQL 18.4 package graph, introduces the PostgreSQL 19 beta template, and refreshes major kernel variants. Versions below are verified against final repository metadata and, where bundled, the v4.4.0 artifacts; PG major ranges describe catalog and repository coverage. [PostgreSQL RPM changes](https://pigsty.io/docs/repo/pgsql/rpm/) · [PostgreSQL DEB changes](https://pigsty.io/docs/repo/pgsql/deb/) · [Infrastructure package changes](https://pigsty.io/docs/repo/infra/log/) | 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 | {.stretch-last} **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` | | {.stretch-last} The MD5 list below covers all 14 validated artifacts. Six Community Edition artifacts are published on GitHub, while the remaining eight are delivered with the Professional Edition. GitHub records SHA-256 digests for the uploaded Community Edition artifacts. **Checksums** ```bash 7de8b932412f1863fd9c033a7be355d7 pigsty-pkg-v4.4.0.d12.aarch64.tgz 2e5006a8d35eb1c087dc0ed11cf14d14 pigsty-pkg-v4.4.0.d12.x86_64.tgz 955308c00d3890f6e82a6a83bc624760 pigsty-pkg-v4.4.0.d13.aarch64.tgz 350f31c66de0aafff3bd91c2c9d740a0 pigsty-pkg-v4.4.0.d13.x86_64.tgz 0b4817a8edbab0bdf37ecee730fb0412 pigsty-pkg-v4.4.0.el10.aarch64.tgz 4584a61e4456749e68d86e4817cfe526 pigsty-pkg-v4.4.0.el10.x86_64.tgz 21621daf510a532829c36464d48f9198 pigsty-pkg-v4.4.0.el9.aarch64.tgz 504afd5030e2738a25e1b4c570d0e654 pigsty-pkg-v4.4.0.el9.x86_64.tgz 461c999424dee587ca33fe1a63df40d7 pigsty-pkg-v4.4.0.u22.aarch64.tgz 20ccc5ab8f9f4648b05bcd304f9fb5fc pigsty-pkg-v4.4.0.u22.x86_64.tgz d092c48ee55116ed5e2c99a3d909ccdd pigsty-pkg-v4.4.0.u24.aarch64.tgz 24fa5399d8421305961fcaf91325b382 pigsty-pkg-v4.4.0.u24.x86_64.tgz 36f69b699d8b3041d35384970e157631 pigsty-pkg-v4.4.0.u26.aarch64.tgz 330047d117b20f04317dce506edd5d9a pigsty-pkg-v4.4.0.u26.x86_64.tgz 3077203c0c656ec99abc32b227f6566b pigsty-v4.4.0.tgz ``` ------ ## 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, deprecated Ubuntu 20.04 support, and refreshed minor OS variants 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 | {.stretch-last} **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** ```bash 58a914fce7bc521b65e167f66e7961a3 pigsty-v4.3.0.tgz 9ce070efb0420057a83c632b2856d1b3 pigsty-pkg-v4.3.0.d12.aarch64.tgz bf21c36d3aff94a1a6353130597ffa85 pigsty-pkg-v4.3.0.d12.x86_64.tgz 81b4790c4e5567cee9d1beadd06e48e6 pigsty-pkg-v4.3.0.d13.aarch64.tgz 06baab9341ab683eaeea2e066b28a0f4 pigsty-pkg-v4.3.0.d13.x86_64.tgz fb4bf751df5e09f547c49b8ab7cac9a0 pigsty-pkg-v4.3.0.el10.aarch64.tgz a3e752c8148122d1eaea74a6d8d8df0d pigsty-pkg-v4.3.0.el10.x86_64.tgz cb2a9af36615513e66fd5ac3e9f4d797 pigsty-pkg-v4.3.0.el9.aarch64.tgz e24641a879dec7a8eea74dab42f85920 pigsty-pkg-v4.3.0.el9.x86_64.tgz 6b675fd8d9e039193481f0838aa4b92c pigsty-pkg-v4.3.0.u22.aarch64.tgz c0e344ccb9d190a619591e5d46116424 pigsty-pkg-v4.3.0.u22.x86_64.tgz 3e0ec9534cf595201ec79eb1fc6549d8 pigsty-pkg-v4.3.0.u24.aarch64.tgz 0a3d19513eca9615bdd66a4b2bf66f1d pigsty-pkg-v4.3.0.u24.x86_64.tgz 683a10ff8fd993358d6befa9f4e02913 pigsty-pkg-v4.3.0.u26.aarch64.tgz fd1ea5cd5554bfe91fadd51ad80860e3 pigsty-pkg-v4.3.0.u26.x86_64.tgz ``` ------ ## 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** ```bash 0d9f907ff626203578c687d1418b38ba pigsty-pkg-v4.2.2.d12.aarch64.tgz 4129baf773c3005f4d697cf452f927a0 pigsty-pkg-v4.2.2.d12.x86_64.tgz 40d5a0d9c2a97615bf0421bae42458ae pigsty-pkg-v4.2.2.d13.aarch64.tgz cf91113a2296ad11fff79802ac9b1483 pigsty-pkg-v4.2.2.d13.x86_64.tgz dbccfeb3978ffb928bd0b501c3c0d42d pigsty-pkg-v4.2.2.el10.aarch64.tgz 8c848a4e3fa93c2455285fbcad5ddd78 pigsty-pkg-v4.2.2.el10.x86_64.tgz 7c15c9a36f7d2dd740019c20e8c75a4b pigsty-pkg-v4.2.2.el9.aarch64.tgz 7d6e9e529236a0db2382f42660790ed9 pigsty-pkg-v4.2.2.el9.x86_64.tgz 8f64bb14885ce330603172b186062671 pigsty-pkg-v4.2.2.u22.aarch64.tgz 16d4c36c9e1ff848848c34a257b1025c pigsty-pkg-v4.2.2.u22.x86_64.tgz 401230741af5b04f163ffc8e688315ab pigsty-pkg-v4.2.2.u24.aarch64.tgz 5312aa0841694fc560778b9377a32c89 pigsty-pkg-v4.2.2.u24.x86_64.tgz cabeeb898b56b26c0855f33d5e60411a pigsty-v4.2.2.tgz ``` ------ ## v4.2.1 A maintenance release that adds 3 new extensions. **Major Changes** - **New Extensions**: `pg_eviltransform` is added to the GIS package group, `pg_pinyin` to the FTS group, and `pg_qos` to the admin group — all for PG 14–18. - **PG13 Removed**: All `pgdg13`, `pgdg13-nonfree` repo entries and PG13 package aliases (`pg13-*`) are removed from every platform variant (EL7/8/9/10, Debian 12/13, Ubuntu 22/24/26, 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.1` to `ppg-18.3` to track the latest Percona PostgreSQL distribution. - **Nginx Repo**: Module tag for the Nginx upstream APT repo corrected from `infra` to `nginx` on Debian/Ubuntu platforms. - **UV Venv Fix**: `roles/node/tasks/pkg.yml` now checks for an existing virtualenv before running `uv venv`, preventing redundant re-creation and potential errors on re-provisioning. - **Docker Image**: `less` is added to the Pigsty Docker image base packages. - **Demo Config**: Default firewall rules in `el.yml` and `debian.yml` demo configs now include port `5432` for direct PostgreSQL access. **Compatibility Notes** PostgreSQL 13 reached its [end of life](https://www.postgresql.org/support/versioning/) on 2025-11-13. The PGDG YUM repository has archived and removed the [pg13](https://yum.postgresql.org/news/pg13-end-of-life/) / [pg12](https://yum.postgresql.org/news/pg12-end-of-life/) directories. If you install Pigsty on EL systems (even without using PG 13), repo access failures may cause installation or update errors. You can either upgrade directly to Pigsty v4.2.1, or manually edit the `repo_upstream_default` variable in your corresponding OS file under `roles/node_id/vars/` and remove the pg13 repo line. Additionally, EL8 remains in the Pigsty compatible OS list, but starting from this release, offline packages for EL8 will no longer be published. No other breaking API or configuration changes in this release. **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** ```bash 262b7671424a38b208872582fe835ef8 pigsty-v4.2.1.tgz 62edcca1d1e572a247be018e1c26eda8 pigsty-pkg-v4.2.1.d12.aarch64.tgz 1d55367e2fd9106e6f18b7ee112be736 pigsty-pkg-v4.2.1.d12.x86_64.tgz f122b1e5ba8a7ae8e3dc6e6dd53eba65 pigsty-pkg-v4.2.1.d13.aarch64.tgz 617a76bfc8df8766e78abf24339152eb pigsty-pkg-v4.2.1.d13.x86_64.tgz 908509b350403ad1a4a27a88795fee06 pigsty-pkg-v4.2.1.el10.aarch64.tgz 70cb4afd90ed7aea6ab43a264f8eb4a8 pigsty-pkg-v4.2.1.el10.x86_64.tgz 98fbd67334f5c674b12e6af81ef76923 pigsty-pkg-v4.2.1.el9.aarch64.tgz 687fa741ccd9dcf611a2aa964bcf1de8 pigsty-pkg-v4.2.1.el9.x86_64.tgz a2a30f4b1146b3e79be91d5be57615b6 pigsty-pkg-v4.2.1.u22.aarch64.tgz 7a1f571bd8526106775c175ba728eee1 pigsty-pkg-v4.2.1.u22.x86_64.tgz a5574071bac1955798265f71ad73c3d4 pigsty-pkg-v4.2.1.u24.aarch64.tgz 59a7632c650a3c034f1fe6cd589d7ab5 pigsty-pkg-v4.2.1.u24.x86_64.tgz ``` ------ ## 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](https://github.com/pgsty/minio). **Major Changes** - `mssql` now defaults to Babelfish PG17 (`pg_version: 17`, `pg_packages: [babelfish, pgsql-common, sqlcmd]`) and no longer requires an extra `mssql` repo. - Kernel install paths are normalized in `pg_home_map`: `mssql -> /usr/babelfish-$v/`, `gpsql -> /usr/local/cloudberry`. - `package_map` adds a dedicated `cloudberry` mapping and fixes `babelfish*` aliases to versioned RPM/DEB package names. - Redis data root default changes from `/data` to `/data/redis`; deployment blocks legacy defaults, while `redis_remove` keeps backward-compatible cleanup. - `configure` now supports absolute `-o` output paths with auto-created parent directories, tri-state region detection (CN/global/offline fallback), and a fix for `behind_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.5` and Vector `0.53.0`) and now includes missing S3 protocol credential variables. - Rich/Sample templates explicitly define `dbuser_meta` defaults; `node.sh` systemd completion is simplified. - `pgbackrest` stanza initialization now retries (2 attempts, 5-second interval) to reduce lock contention with `archive-push`. - Vibe template now ships `@anthropic-ai/claude-code`, `@openai/codex`, and `happy-coder`, and includes `age` in the default example. **PG Software Updates** - PostgreSQL 18.3, 17.9, 16.13, 15.17, 14.22 - [RPM Changelog 2026-02-27](/docs/repo/pgsql/rpm/#2026-02-27) - [DEB Changelog 2026-02-27](/docs/repo/pgsql/deb/#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_mode` now includes `agens` and `pgedge`. - `mssql` defaults are updated to `pg_version: 17` and `pg_packages: [babelfish, pgsql-common, sqlcmd]`. - Kernel/package alias mappings are updated in `pg_home_map` and `package_map` (Babelfish, OpenHalo, IvorySQL, Cloudberry, pgEdge family). - `redis_fs_main` now defaults to `/data/redis`, with deployment guardrails and backward-compatible cleanup behavior. - `configure` output path handling and region detection logic are updated, with offline fallback warnings and unified SSH probe timeouts. - `grafana.ini.j2` is updated for Grafana 12.4 config changes and deprecations. **Compatibility Notes** - If existing Redis configs still use `redis_fs_main: /data`, migrate to `/data/redis` before deployment. - Grafana 12.4 changes data link merge behavior. This release moves key links into field overrides; review custom dashboards accordingly. **26 commits**, 122 files changed, +2,116 / -2,215 lines (`v4.1.0..v4.2.0`, 2026-02-15 ~ 2026-02-28) **Checksums** ```bash 24a90427a7e7351ca1a43a7d53289970 pigsty-v4.2.0.tgz d980edf5eeb0419d4f1aa7feb0100e14 pigsty-pkg-v4.2.0.d12.aarch64.tgz 24bc237d841457fbdcc899e1d0a3f87e pigsty-pkg-v4.2.0.d12.x86_64.tgz e395b38685e2ecbe9c3a2850876d9b7b pigsty-pkg-v4.2.0.d13.aarch64.tgz c5c8776f9bead9f29528b26058801f83 pigsty-pkg-v4.2.0.d13.x86_64.tgz 28ea40434bd06135fc8adc0df1c8407d pigsty-pkg-v4.2.0.el10.aarch64.tgz 58ad715ac20dc1717d1687daecfcf625 pigsty-pkg-v4.2.0.el10.x86_64.tgz 008f955439ea311581dd0ebcf5b8bd34 pigsty-pkg-v4.2.0.el8.aarch64.tgz 2acfd127a517b09f07540f808fe9547a pigsty-pkg-v4.2.0.el8.x86_64.tgz 58e62a92f35291a40e3f05839a1b6bc4 pigsty-pkg-v4.2.0.el9.aarch64.tgz d311bfdf5d5f60df5fe6cb3d4ced4f9c pigsty-pkg-v4.2.0.el9.x86_64.tgz c98972fe9226657ac1faa7b72a22498b pigsty-pkg-v4.2.0.u22.aarch64.tgz 44a174ee9ba030ac1ea386cf0b85f6e7 pigsty-pkg-v4.2.0.u22.x86_64.tgz 143e404f4681c7d0bbd78ef7982cd652 pigsty-pkg-v4.2.0.u24.aarch64.tgz 00dfa86f477f3adff984906211ab3190 pigsty-pkg-v4.2.0.u24.x86_64.tgz ``` ------ ## v4.1.0 ```bash curl https://pigsty.io/get | bash -s 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 to `12.13 / 13.3`. - Added 7 new extensions, bringing total support to **451** extensions. - `pig` moved from a traditional script interface to an **Agent-Native CLI** (`1.0.0 -> 1.1.0`), with explicit context and JSON/YAML output. - `pig` now provides unified **major/minor upgrade** workflows for PostgreSQL and OS lifecycle updates. - `pg_exporter` upgraded to **v1.2.0** (`1.1.2 -> 1.2.0`), with PG17/18 metric pipeline and unit fixes. - Default firewall security policy updated: `node_firewall_mode` now defaults to `zone`, and `node_firewall_public_port` default changed 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-rm` uninstall flow with segmented `deregister` cleanup 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=8M` and unified `LimitNOFILE=8M` to 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` - `pig` CLI: `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](/docs/repo/pgsql/rpm/#2026-02-12) - [DEB Changelog 2026-02-12](/docs/repo/pgsql/deb/#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** [Infra Changelog 2026-02-12](/docs/repo/infra/log/#2026-02-12) | 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_workers` from `pg_version >= 17` to `pg_version >= 18`. - Fixed PG18 guards for `idle_replication_slot_timeout` / `initdb --no-data-checksums`. - Broadened `maintenance_io_concurrency` effective range to `PG13+`. - Raised `autovacuum_vacuum_threshold`: `oltp/crit/tiny` from 50 to 500, `olap` to 1000. - Raised `autovacuum_analyze_threshold`: `oltp/crit/tiny` from 50 to 250, `olap` to 500. - Increased default `checkpoint_completion_target` from `0.90` to `0.95`. - Added `fs.nr_open=8388608` in node tuned templates and aligned `fs.file-max / fs.nr_open / LimitNOFILE`. - Changed postgres/patroni/minio systemd `LimitNOFILE` from `16777216` to `8388608`. - Added `fs.nr_open: 8388608` into default `node_sysctl_params`. - Changed `node_firewall_mode` default from `none` to `zone`: firewall enabled by default, intranet trusted, and only `node_firewall_public_port` exposed publicly; set `none` for fully self-managed firewall. - Changed `node_firewall_public_port` default from `[22,80,443,5432]` to `[22,80,443]`; add `5432` explicitly only when public DB access is required. Firewall rules are add-only, so existing nodes that already exposed `5432` must remove it manually. Single-node experience templates (such as `meta` / `vibe`) explicitly override and keep `5432` for remote usage. - Added `bin/validate` checks for `pg_databases[*].parameters` and `pg_hba_rules[*].order`; fixed HBA validation not returning failure properly. - Added segmented tags in `infra-rm.yml`: `deregister`, `config`, `env`, etc. - Updated VIBE defaults: `jupyter_enabled=false`, `npm_packages` include `@anthropic-ai/claude-code` and `happy-coder`, plus `CLAUDE_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 `replicaof` empty-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_exporter` startup non-blocking to avoid slowing main flow when exporter fails. - Simplified VIP CIDR parsing: default mask `24` when omitted. - Increased MinIO health-check retries from `3` to `5`. - Switched node hostname setup to Ansible hostname module instead of shell calls. - Fixed `.env` format for `app/electric` and `app/pg_exporter` to standard `KEY=VALUE`. - Fixed `pg_crontab` syntax error in `pigsty.yml`. - Updated ETCD docs to clarify default TLS vs optional mTLS semantics. - Fixed `repo-add` argument passing, Debian CN mirror component compatibility, and `bin/psql.py` Python 3 compatibility. - Hardened redis-exporter credential file permissions. - `pgsql-user.yml` now masks credential logs (`no_log`) on sensitive steps. - Fixed gate conditions when `pg_monitor` registers Victoria targets. - Changed `pg_remove` backup 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)** ```text 7410de401 v4.1.0 release fa31213ce conf(node): default firewall to zone with single-node 5432 override bb8382c58 update default extension list to 451 770d01959 hide user credential in pgsql-user playbook 7219a896c pg_monitor: fix victoria registration gate conditions 084c98432 remove one cluster in backup dir during pg_remove 7005617f1 pgsql: drop legacy pgbouncer pool parameter aliases f8165a886 docs(roles): fix typos and align juice role documentation 06a589218 chore(meta): normalize platform versions for current lint schema e0a208248 fix(roles): harden redis exporter file permissions fd0469881 terraform/vagrant: parameterize aliyun region/zone, fix vagrant scripts 74c59aabe grafana: fix dashboard links, descriptions, and overrides 443e58724 conf: clean legacy params and fix template references 536c4b39d adjust grafana dashboard dead links f3b9866ce grafana(pgsql): fix panel typos and title consistency bcb69be11 grafana(pgsql): fix drilldown links and variable mappings 1ce4374a1 grafana: fill pglog panel titles and normalize wording 2d127f9f4 grafana: fix minio traffic metrics and pigsty dashboard links 9d3ca0118 grafana: align victoria instance dashboards with query scope 55bc61622 grafana: fix infra dashboard copy, links, and table semantics 607b75535 grafana(node): fix panel drilldown links and clean dashboard metadata 1321de532 grafana(redis): fix dashboard links and blocked-clients panel semantics 91e0c8437 fix(grafana): correct Redis alert drill-down dashboard links 0fde78c02 fix(tooling): improve Python3 compatibility and enforce vagrant scale lower bound fa3454a52 fix(bootstrap): use Debian-compatible components for CN apt mirror 36c95c749 fix(cli): restore repo-add execution and HBA validation failure propagation 797385929 add macbook local vagrant image override f9c928e32 fix(grafana): restore reverted dashboard bugfixes c11af8b6a Bump version to v4.1.0 307a236ba update extension list f17024807 override el9/u24 vagrant box for convient testing c2ada1283 terraform: bump Aliyun Debian images to 12.13/13.3 25bd8210f fix(node): add daemon_reload to systemd tasks for keepalived, chronyd, and cron 6f2576fd0 fix(node): set default fs.nr_open via node_sysctl_params 43a71245e add pg_bgwriter_buffers_backend for pg 17- da832a47b fix(monitor): keep checkpointer metrics for checkpoint stats 90434ca8a fix(monitor): add pg_bgwriter fallback for checkpointer metrics e2d75e787 fix(monitor): use pg_checkpointer metrics for checkpoint stats a0b7474f8 fix grafana dashboard metrics and lengend 27ddacbc6 vagrant: refresh box selector and OS shortcuts 26e108788 fix(monitor): correct unit for time metrics scaled by pg_exporter ee90044b5 fix(pgsql): correct min_parallel scan size params in oltp/crit templates d439464b2 pgsql: fix pg_version guards for PG18-only settings 26320f120 docs: recommend RockyLinux 10.1 1e9b9f33a terraform: bump Aliyun Rocky images to 9.7/10.1 d6e9c7122 monitor: optimize table/index bloat estimators 42d45d32e fix(grafana): align panel semantics across node/infra/redis 3972d2c45 fix(grafana/pgsql): align dashboard semantics for query monitoring cb52375ac bump checkpoint_completion_target from 0.90 to 0.95 13115a95d fix legend in pgsql-persist checkpoint panel 102cd2edb fix(pg_migration): make template logging format-safe c402f0e6d fix: correct io_method/io_workers version guard from PG17 to PG18 3bf676546 vibe: disable jupyter by default and install claude-code via npm_packages 613c4efa9 fix: set fs.nr_open in tuned profiles and reduce LimitNOFILE to 8M 07e499d4d new app conf template matter most 4cc68ed61 Refine infra removal playbook 7cfb98f69 fix: app docker .env file format 9b36b1875 Fix config templates and validation 318d85e6e Simplify VIP parsing and make pg_exporter non-blocking 571cd9e70 Use hostname module for nodename de98f073c Fix blackbox config filename and pgpass format 4bff01100 Fix redis replicaof guard and systemd stop 38445b68d minio: increase health check retries c99854969 docs(etcd): clarify TLS vs mTLS 41229124a fix pgsql roles typo e575d17c6 fix pg_migration scripts to use fully qualified identifiers ec4207202 fix pgsql-schema broken links a237e6c99 tune autovacuum threshold to reduce small table vacuum frequency e80754760 fix pgcat-database links to pgcat-table https://github.com/pgsty/pigsty/issues/690 0060f5346 fix pgsql-database / pgsql-databases age metric fix https://github.com/pgsty/pigsty/issues/695 43cdf72bc fix pigsty.yml typo 0d9db7b08 fix: update datasource to $dsn - fix https://github.com/pgsty/pigsty/issues/692#issuecomment-3835461620 ``` **Thanks** - Thanks to [@l2dy](https://github.com/l2dy) for many valuable suggestions and issues. **Checksums** ```bash 8bc75e8df0e3830931f2ddab71b89630 pigsty-v4.1.0.tgz da10de99d819421630f430d01bc9de62 pigsty-pkg-v4.1.0.d12.aarch64.tgz e1f2ed2da0d6b8c360f9fa2faaa7e175 pigsty-pkg-v4.1.0.d12.x86_64.tgz 382bb38a81c138b1b3e7c194211c2138 pigsty-pkg-v4.1.0.d13.aarch64.tgz 13ceaa728901cc4202687f03d25f1479 pigsty-pkg-v4.1.0.d13.x86_64.tgz 92d061de4d495d05d42f91e4283e7502 pigsty-pkg-v4.1.0.el10.aarch64.tgz be629ea91adf86bbd7e1c59b659d0069 pigsty-pkg-v4.1.0.el10.x86_64.tgz c14be706119ba33dd06c71dda6c02298 pigsty-pkg-v4.1.0.el8.aarch64.tgz 0c8b6952ffc00e3b169896129ea39184 pigsty-pkg-v4.1.0.el8.x86_64.tgz cfcc63b9ecc525165674f58f9365aa19 pigsty-pkg-v4.1.0.el9.aarch64.tgz 34f733080bfa9c8515d1573c35f3e870 pigsty-pkg-v4.1.0.el9.x86_64.tgz ad52ce9bf25e4d834e55873b3f9ada51 pigsty-pkg-v4.1.0.u22.aarch64.tgz 300b2185c61a03ea7733248e526f3342 pigsty-pkg-v4.1.0.u22.x86_64.tgz 2e561e6ae9abb14796872059d2f694a8 pigsty-pkg-v4.1.0.u24.aarch64.tgz c462bb4cb2359e771ffcad006888fbd4 pigsty-pkg-v4.1.0.u24.x86_64.tgz ``` ------ ## v4.0.0 ```bash curl https://pigsty.io/get | bash -s 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_databases` state (create/absent/recreate), instant clone with `strategy` - **PITR & Fork**: `/pg/bin/pg-fork` for instant CoW cloning, enhanced `pg-pitr` with pre-backup - **HA Enhancement**: `pg_rto_plan` with 4 RTO presets (fast/norm/safe/wide), `pg_crontab` scheduled 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**](https://github.com/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 | | | {.full-width} **New Modules** - **JUICE Module**: JuiceFS distributed filesystem using PostgreSQL as metadata engine, supports PITR recovery for filesystem. Multiple storage backends (PG large objects, MinIO, S3), multi-instance deployment with Prometheus metrics, new `node-juice` dashboard. - **VIBE Module**: AI coding sandbox with Code-Server (VS Code in browser), JupyterLab (interactive computing), Node.js (JavaScript runtime), Claude Code (AI coding assistant with OpenTelemetry observability). New `claude-code` dashboard 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](https://github.com/timescale/pg_textsearch) 0.4.0, [pg_clickhouse](https://github.com/clickhouse/pg_clickhouse/) 0.1.3, [pg_ai_query](https://github.com/benodiwal/pg_ai_query) 0.1.1, [etcd_fdw](https://github.com/pgsty/etcd_fdw), [pg_ttl_index](https://github.com/pg-ttl-index) 0.1.0, [pljs](https://github.com/plv8/pljs) 1.0.4, [pg_retry](https://github.com/pg-retry/pg_retry) 1.0.0, [pg_weighted_statistics](https://github.com/pgsty/pg_weighted_statistics) 1.0.0, [pg_enigma](https://github.com/pgsty/pg_enigma) 0.5.0, [pglinter](https://github.com/pgsty/pglinter) 1.0.1, [documentdb_extended_rum](https://github.com/microsoft/documentdb) 0.109, [mobilitydb_datagen](https://github.com/MobilityDB) 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` | {.full-width} **Observability** - VictoriaMetrics replaces Prometheus — several times the performance with a fraction of the resources - VictoriaLogs + Vector replaces Promtail + Loki for log collection - Unified log format for all components, PG logs use UTC timestamp (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, Victoria datasources auto-registered in Grafana - New `grafana_pgurl` parameter for using PG as Grafana backend storage - New `grafana_view_password` parameter for Grafana Meta datasource password - `pg_exporter` updated to 1.1.2 with new `pg_timeline` collector and numerous fixes - New dashboards: `node-vector`, `node-juice`, `claude-code` **Interface Improvements** - `install.yml` playbook renamed to `deploy.yml`, new `vibe.yml` playbook for VIBE module - `pg_databases`: added `state` field (create/absent/recreate), `strategy` for cloning, newer locale params support - `pg_users`: added `admin` parameter with `ADMIN OPTION`, `set` and `inherit` options - `pg_hba`: support `order` field for priority, IPv6 localhost access - New `node_crontab` auto-restores original crontab on `node-rm` **Parameter Optimization** - `pg_io_method`: auto, sync, worker, io_uring options, default worker - `pg_rto_plan`: RTO presets (fast/norm/safe/wide) integrating Patroni & HAProxy config - `pg_crontab`: scheduled tasks for postgres dbsu - `idle_replication_slot_timeout`: default 7d, crit template 3d - `file_copy_method`: set to `clone` for PG18 instant database cloning - Crit template enables Patroni strict sync mode - PITR default `archive_mode` changed to `preserve` **Architecture Improvements** - Fixed `/infra` symlink pointing to `/data/infra` on Infra nodes - Local repo at `/data/nginx/pigsty`, `/www` symlinks to `/data/nginx` - New scripts: `/pg/bin/pg-fork` (CoW cloning), `/pg/bin/pg-drop-role`, `bin/pgsql-ext` - Enhanced `/pg/bin/pg-pitr` for instance-level PITR with pre-backup - UV Python manager moved from `infra` to `node` module with `node_uv_env` parameter - Terraform templates: AWS, Azure, GCP, Hetzner, DigitalOcean, Linode, Vultr, TencentCloud - Simu template simplified from 36 to 20 nodes, new 10-node and Citus templates **Security Improvements** - `configure -g` auto-generates strong random passwords - Replaced `node_disable_firewall` with `node_firewall_mode` (off/none/zone) - Replaced `node_disable_selinux` with `node_selinux_mode` (disabled/permissive/enforcing) - Nginx Basic Auth support for optional HTTP authentication - Enabled etcd RBAC, each cluster can only manage its own PG cluster - etcd root password stored in `/etc/etcd/etcd.pass`, admin-readable only - New `node_admin_sudo` parameter 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 | {.full-width} **Removed Parameters**: `node_disable_firewall`, `node_disable_selinux`, `infra_pip_packages`, `pg_pwd_enc`, `pgbackrest_clean`, `code_home`, `jupyter_home` **Checksums** ```bash bc48405075b3ec6a85fc2c99a1f77650 pigsty-v4.0.0.tgz db9797c3c8ae21320b76a442c1135c7b pigsty-pkg-v4.0.0.d12.aarch64.tgz 1eed26eee42066ca71b9aecbf2ca1237 pigsty-pkg-v4.0.0.d12.x86_64.tgz 03540e41f575d6c3a7c63d1d30276d49 pigsty-pkg-v4.0.0.d13.aarch64.tgz 36a6ee284c0dd6d9f7d823c44280b88f pigsty-pkg-v4.0.0.d13.x86_64.tgz f2b6ec49d02916944b74014505d05258 pigsty-pkg-v4.0.0.el10.aarch64.tgz 73f64c349366fe23c022f81fe305d6da pigsty-pkg-v4.0.0.el10.x86_64.tgz 287f767fbb66a9aaca9f0f22e4f20491 pigsty-pkg-v4.0.0.el8.aarch64.tgz c0886aab454bd86245f3869ef2ab4451 pigsty-pkg-v4.0.0.el8.x86_64.tgz 094ab31bcf4a3cedbd8091bc0f3ba44c pigsty-pkg-v4.0.0.el9.aarch64.tgz 235ccba44891b6474a76a81750712544 pigsty-pkg-v4.0.0.el9.x86_64.tgz f2791c96db4cc17a8a4008fc8d9ad310 pigsty-pkg-v4.0.0.u22.aarch64.tgz 3099c4453eef03b766d68e04b8d5e483 pigsty-pkg-v4.0.0.u22.x86_64.tgz 49a93c2158434f1adf0d9f5bcbbb1ca5 pigsty-pkg-v4.0.0.u24.aarch64.tgz 4acaa5aeb39c6e4e23d781d37318d49b pigsty-pkg-v4.0.0.u24.x86_64.tgz ``` ------ ## v3.7.0 **Highlights** - **PostgreSQL 18 Deep Support:** Now the default major PG version, with full extension readiness! - **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:** Refined logic for default PG parameters to maximize resource utilization. - [**PGEXT.CLOUD**](/ext/): 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, please refer to: - [INFRA Changelog](/docs/repo/infra/) - [RPM Changelog](/docs/repo/pgsql/rpm) - [DEB Changelog](/docs/repo/pgsql/deb) **API Changes** - Implemented a refined optimization strategy for parallel execution parameters. See **[Tuning Guide](/docs/pgsql/template/tune)**. - The `citus` extension is no longer installed by default in `rich` and `full` templates (PG 18 support pending). - Added `duckdb` extension stubs to PostgreSQL parameter templates. - Capped `min_wal_size`, `max_wal_size`, and `max_slot_wal_keep_size` at 200 GB, 2000 GB, and 3000 GB, respectively. - Capped `temp_file_limit` at 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_port` default to `9059` to avoid potential conflicts with Kafka SSL ports. - Added a `pg_pre` subtask to `pg_pkg`: removes conflicting LLVM packages (`bpftool`, `python3-perf`) on EL9+ prior to PG installation. - Added the `llvm` module 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:** Resolved numerous compatibility issues introduced by Ansible 2.19 to ensure stability across versions: - Added explicit `int` type casting for sequence variables. - Migrated `with_items` syntax to `loop`. - Nested key exchange variables in lists to prevent character iteration on strings in newer versions. - Explicitly cast `range` usage to `list`. - Renamed reserved variables such as `name` and `port`. - Replaced `play_hosts` with `ansible_play_hosts`. - Added string casting for specific variables to prevent runtime errors. - **EL10 Adaptation:** - Fixed missing `ansible-collection-community-crypto` preventing key generation. - Fixed missing `ansible` logic packages. - Removed `modulemd_tools`, `flamegraph`, and `timescaledb-tool`. - Replaced `java-17-openjdk` with `java-21-openjdk`. - Resolved aarch64 YUM repository naming issues. - **Debian 13 Adaptation:** - Replaced `dnsutils` with `bind9-dnsutils`. - **Ubuntu 24 Fixes:** - Temporarily removed `tcpdump` due to upstream dependency crashes. **Checksums** ```bash e00d0c2ac45e9eff1cc77927f9cd09df pigsty-v3.7.0.tgz 987529769d85a3a01776caefefa93ecb pigsty-pkg-v3.7.0.d12.aarch64.tgz 2d8272493784ae35abeac84568950623 pigsty-pkg-v3.7.0.d12.x86_64.tgz 090cc2531dcc25db3302f35cb3076dfa pigsty-pkg-v3.7.0.d13.x86_64.tgz ddc54a9c4a585da323c60736b8560f55 pigsty-pkg-v3.7.0.el10.aarch64.tgz d376e75c490e8f326ea0f0fbb4a8fd9b pigsty-pkg-v3.7.0.el10.x86_64.tgz 8c2deeba1e1d09ef3d46d77a99494e71 pigsty-pkg-v3.7.0.el8.aarch64.tgz 9795e059bd884b9d1b2208011abe43cd pigsty-pkg-v3.7.0.el8.x86_64.tgz 08b860155d6764ae817ed25f2fcf9e5b pigsty-pkg-v3.7.0.el9.aarch64.tgz 1ac430768e488a449d350ce245975baa pigsty-pkg-v3.7.0.el9.x86_64.tgz e033aaf23690755848db255904ab3bcd pigsty-pkg-v3.7.0.u22.aarch64.tgz cc022ea89181d89d271a9aaabca04165 pigsty-pkg-v3.7.0.u22.x86_64.tgz 0e978598796db3ce96caebd76c76e960 pigsty-pkg-v3.7.0.u24.aarch64.tgz 48223898ace8812cc4ea79cf3178476a pigsty-pkg-v3.7.0.u24.x86_64.tgz ``` ------ ## v3.6.1 ```bash curl https://repo.pigsty.io/get | bash -s v3.6.1 ``` **Highlights** - PostgreSQL 17.6, 16.10, 15.14, 14.19, 13.22, and 18 Beta 3 Released! - PGDG APT/YUM mirror for Mainland China Users - New home website https://pgsty.com - Add el10, debian 13 stub, add 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** - remove `br_filter` from default `node_kernel_modules` - do not use OS minor version dir for pgdg yum repos **Checksums** ```bash 045977aff647acbfa77f0df32d863739 pigsty-pkg-v3.6.1.d12.aarch64.tgz 636b15c2d87830f2353680732e1af9d2 pigsty-pkg-v3.6.1.d12.x86_64.tgz 700a9f6d0db9c686d371bf1c05b54221 pigsty-pkg-v3.6.1.el8.aarch64.tgz 2aff03f911dd7be363ba38a392b71a16 pigsty-pkg-v3.6.1.el8.x86_64.tgz ce07261b02b02b36a307dab83e460437 pigsty-pkg-v3.6.1.el9.aarch64.tgz d598d62a47bbba2e811059a53fe3b2b5 pigsty-pkg-v3.6.1.el9.x86_64.tgz 13fd68752e59f5fd2a9217e5bcad0acd pigsty-pkg-v3.6.1.u22.aarch64.tgz c25ccfb98840c01eb7a6e18803de55bb pigsty-pkg-v3.6.1.u22.x86_64.tgz 0d71e58feebe5299df75610607bf428c pigsty-pkg-v3.6.1.u24.aarch64.tgz 4fbbab1f8465166f494110c5ec448937 pigsty-pkg-v3.6.1.u24.x86_64.tgz 083d8680fa48e9fec3c3fcf481d25d2f pigsty-v3.6.1.tgz ``` ------ ## v3.6.0 ```bash curl https://repo.pigsty.io/get | bash -s v3.6.0 ``` **Highlights** - Brand-new documentation site: https://doc.pgsty.com - Added `pgsql-pitr` playbook and backup/restore tutorial, improved PITR experience - Added kernel support: Percona PG TDE (PG17) - Optimized self-hosted Supabase experience, updated to the latest version, and fixed issues with the official template - Simplified installation steps, online install by default, bootstrap now part of install script **Improvements** - Refactored `ETCD` module with dedicated remove playbook and bin utils - Refactored `MinIO` module 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 `pgactive` for multi-master replication and sub-second failover - Adjusted default values for `pg_fs_main` / `pg_fs_backup`, simplified file directory structure design **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 - Fix ivorysql [libxcrypt](https://github.com/IvorySQL/IvorySQL/issues/826) dependencies issues - Fix Replace the slow and broken epel mirror - Fix `haproxy_enabled` flag not working **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 install` subcommand - 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](https://github.com/tensorchord/VectorChord/releases/tag/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 to `pg_fs_backup`, default value `/data/backups`. * `pg_rm_bkup`: Renamed to `pg_rm_backup`, default value `true`. * `pg_fs_main`: Default value adjusted to `/data/postgres`. * `nginx_cert_validity`: New parameter to control Nginx self-signed certificate validity, default `397d`. * `minio_buckets`: Default value adjusted to create three buckets named `pgsql`, `meta`, `data`. * `minio_users`: Removed `dba` user, added `s3user_meta` and `s3user_data` users for `meta` and `data` buckets respectively. * `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, abort `minio-rm.yml` when enabled * `minio_rm_data`: New parameter, whether to remove minio data directory during `minio-rm.yml` * `minio_rm_pkg`: New parameter, whether to uninstall minio package during `minio-rm.yml` * `etcd_learner`: New parameter to control whether to init etcd instance as learner * `etcd_rm_data`: New parameter, whether to remove etcd data directory during `etcd-rm.yml` * `etcd_rm_pkg`: New parameter, whether to uninstall etcd package during `etcd-rm.yml` **Checksums** ```bash ab91bc05c54b88c455bf66533c1d8d43 pigsty-v3.6.0.tgz cea861e2b4ec7ff5318e1b3c30b470cb pigsty-pkg-v3.6.0.d12.aarch64.tgz 2f253af87e19550057c0e7fca876d37c pigsty-pkg-v3.6.0.d12.x86_64.tgz 0158145b9bbf0e4a120b8bfa8b44f857 pigsty-pkg-v3.6.0.el8.aarch64.tgz 07330d687d04d26e7d569c8755426c5a pigsty-pkg-v3.6.0.el8.x86_64.tgz 311df5a342b39e3288ebb8d14d81e0d1 pigsty-pkg-v3.6.0.el9.aarch64.tgz 92aad54cc1822b06d3e04a870ae14e29 pigsty-pkg-v3.6.0.el9.x86_64.tgz c4fadf1645c8bbe3e83d5a01497fa9ca pigsty-pkg-v3.6.0.u22.aarch64.tgz 5477ed6be96f156a43acd740df8a9b9b pigsty-pkg-v3.6.0.u22.x86_64.tgz 196169afc1be02f93fcc599d42d005ca pigsty-pkg-v3.6.0.u24.aarch64.tgz dbe5c1e8a242a62fe6f6e1f6e6b6c281 pigsty-pkg-v3.6.0.u24.x86_64.tgz ``` ------ ## v3.5.0 **Highlights** - New website: https://pgsty.com - **PostgreSQL 18 (Beta) support**: monitoring via `pg_exporter 1.0.0`, installer alias via `pig 0.4.2`, and a `pg18` template - **421 bundled extensions**, now including OrioleDB and OpenHalo kernels on all platforms - **`pig do` CLI** replaces legacy `bin/` 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** ```bash curl https://repo.pigsty.io/get | bash -s v3.5.0 ``` **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 `pgsql` module - Split monitoring into a new **`pg_monitor`** role; removed `clean` logic - Pruned duplicate tasks, dropped `dir/utils` block, renamed templates (no `.j2`) - All extensions install in **`extensions`** schema (Supabase best-practice) - Added `SET search_path=''` to every monitoring function - Tuned PgBouncer defaults (larger pool, cleanup query); new `pgbouncer_ignore_param` - New `pg_key` task to generate `pgsodium` master keys - Enabled `sync_replication_slots` by default on PG 17 - Retagged subtasks for clearer structure - Refactored `pg_remove` module - New flags `pg_rm_data`, `pg_rm_bkup`, `pg_rm_pkg` control what gets wiped - Clearer role layout & tagging - Added new `pg_monitor` module - pgbouncer_exporter no longer shares configuration files with `pg_exporter` - Added monitoring metrics for TimescaleDB and Citus - Using `pg_exporter` 0.9.0 with updated replication slot metrics for PG16/17 - Using more compact, newly designed collector configuration files - Supabase Enhancement (thanks [@lawso017](https://github.com/lawso017) for the contribution) - update supabase containers and schemas to the latest version - Support `pgsodium` server key loading - fix logflare lag issue with `supa-kick` crontab - add `set search_path` clause for monitor functions - Added new `pig do` command to CLI, allowing command-line tool to replace Shell scripts in `bin/` **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](https://github.com/pgsty/pg_exporter/releases/tag/v1.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](https://github.com/Florents-Tselai/spat) new extension - pgsentinel [1.1.0](https://github.com/pgsentinel/pgsentinel/releases/tag/v1.1.0) new extension - pgdd [0.6.0](https://github.com/rustprooflabs/pgdd) (pgrx 0.14.1) new extension add back - convert [0.0.4](https://github.com/rustprooflabs/convert) (pgrx 0.14.1) new extension - pg_tokenizer.rs [0.1.0](https://github.com/tensorchord/pg_tokenizer.rs) (pgrx 0.13.1) - pg_render [0.1.2](https://github.com/mkaski/pg_render) (pgrx 0.12.8) - pgx_ulid [0.2.0](https://github.com/pksunkara/pgx_ulid) (pgrx 0.12.7) - pg_idkit [0.3.0](https://github.com/VADOSWARE/pg_idkit) (pgrx 0.14.1) - pg_ivm [1.11.0](https://github.com/sraoss/pg_ivm) - orioledb [1.4.0 beta11](https://github.com/orioledb/orioledb) rpm & add debian/ubuntu support - openhalo [14.10](https://github.com/HaloTech-Co-Ltd/openHalo) add debian/ubuntu support - omnigres 20250507 (miss on d12/u22) - citus [12.0.3](https://github.com/citusdata/citus/releases/tag/v13.0.3) - timescaledb [2.20.0](https://github.com/timescale/timescaledb/releases/tag/2.20.0) (DROP PG14 support) - supautils [2.9.2](https://github.com/supabase/supautils/releases/tag/v2.9.2) - pg_envvar [1.0.1](https://github.com/theory/pg-envvar/releases/tag/v1.0.1) - pgcollection [1.0.0](https://github.com/aws/pgcollection/releases/tag/v1.0.0) - aggs_for_vecs [1.4.0](https://github.com/pjungwir/aggs_for_vecs/releases/tag/1.4.0) - pg_tracing [0.1.3](https://github.com/DataDog/pg_tracing/releases/tag/v0.1.3) - pgmq [1.5.1](https://github.com/pgmq/pgmq/releases/tag/v1.5.1) - tzf-pg [0.2.0](https://github.com/ringsaturn/tzf-pg/releases/tag/v0.2.0) (pgrx 0.14.1) - pg_search [0.15.18](https://github.com/paradedb/paradedb/releases/tag/v0.15.18) (pgrx 0.14.1) - anon [2.1.1](https://gitlab.com/dalibo/postgresql_anonymizer/-/tree/latest/debian?ref_type=heads) (pgrx 0.14.1) - pg_parquet [0.4.0](https://github.com/CrunchyData/pg_parquet/releases/tag/v0.3.2) (0.14.1) - pg_cardano [1.0.5](https://github.com/Fell-x27/pg_cardano/commits/master/) (pgrx 0.12) -> 0.14.1 - pglite_fusion [0.0.5](https://github.com/frectonz/pglite-fusion/releases/tag/v0.0.5) (pgrx 0.12.8) -> 14.1 - vchord_bm25 [0.2.1](https://github.com/tensorchord/VectorChord-bm25/releases/tag/0.2.1) (pgrx 0.13.1) - vchord [0.3.0](https://github.com/tensorchord/VectorChord/releases/tag/0.3.0) (pgrx 0.13.1) - pg_vectorize [0.22.1](https://github.com/ChuckHend/pg_vectorize/releases/tag/v0.22.1) (pgrx 0.13.1) - wrappers [0.4.6](https://github.com/supabase/wrappers/releases/tag/v0.4.6) (pgrx 0.12.9) - timescaledb-toolkit [1.21.0](https://github.com/timescale/timescaledb-toolkit/releases/tag/1.21.0) (pgrx 0.12.9) - pgvectorscale [0.7.1](https://github.com/timescale/pgvectorscale/releases/tag/0.7.1) (pgrx 0.12.9) - pg_session_jwt [0.3.1](https://github.com/neondatabase/pg_session_jwt/releases/tag/v0.3.1) (pgrx 0.12.6) -> 0.12.9 - pg_timetable 5.13.0 - ferretdb 2.2.0 - documentdb [0.103.0](https://github.com/FerretDB/documentdb/releases/tag/v0.103.0-ferretdb-2.2.0) (+aarch64 support) - pgml [2.10.0](https://github.com/postgresml/postgresml/releases/tag/v2.10.0) (pgrx 0.12.9) - sqlite_fdw [2.5.0](https://github.com/pgspider/sqlite_fdw/releases/tag/v2.5.0) (fix pg17 deb) - tzf [0.2.2](https://github.com/ringsaturn/pg-tzf/releases/tag/v0.2.2) 0.14.1 (rename src) - pg_vectorize [0.22.2](https://github.com/ChuckHend/pg_vectorize/releases/tag/v0.22.2) (pgrx 0.13.1) - wrappers [0.5.0](https://github.com/supabase/wrappers/releases/tag/v0.5.0) (pgrx 0.12.9) **Checksums** ```bash c7e5ce252ddf848e5f034173e0f29345 pigsty-v3.5.0.tgz ba31f311a16d615c1ee1083dc5a53566 pigsty-pkg-v3.5.0.d12.aarch64.tgz 3aa5c56c8f0de53303c7100f2b3934f4 pigsty-pkg-v3.5.0.d12.x86_64.tgz a098cb33822633357e6880eee51affd6 pigsty-pkg-v3.5.0.el8.x86_64.tgz 63723b0aeb4d6c02fff0da2c78e4de31 pigsty-pkg-v3.5.0.el9.aarch64.tgz eb91c8921d7b8a135d8330c77468bfe7 pigsty-pkg-v3.5.0.el9.x86_64.tgz 87ff25e14dfb9001fe02f1dfbe70ae9e pigsty-pkg-v3.5.0.u22.x86_64.tgz 18be503856f6b39a59efbd1d0a8556b6 pigsty-pkg-v3.5.0.u24.aarch64.tgz 2bbef6a18cfa99af9cd175ef0adf873c pigsty-pkg-v3.5.0.u24.x86_64.tgz ``` ------ ## v3.4.1 GitHub Release Page: [v3.4.1](https://github.com/pgsty/pigsty/releases/tag/v3.4.1) - Added support for MySQL wire-compatible PostgreSQL kernel on EL systems: [openHalo](/docs/pgsql/kernel/openhalo) - Added support for OLTP-enhanced PostgreSQL kernel on EL systems: [orioledb](/docs/pgsql/kernel/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_fdw` extension 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** ```bash 471c82e5f050510bd3cc04d61f098560 pigsty-v3.4.1.tgz 4ce17cc1b549cf8bd22686646b1c33d2 pigsty-pkg-v3.4.1.d12.aarch64.tgz c80391c6f93c9f4cad8079698e910972 pigsty-pkg-v3.4.1.d12.x86_64.tgz 811bf89d1087512a4f8801242ca8bed5 pigsty-pkg-v3.4.1.el9.x86_64.tgz 9fe2e6482b14a3e60863eeae64a78945 pigsty-pkg-v3.4.1.u22.x86_64.tgz ``` ------ ## v3.4.0 GitHub Release Page: [v3.4.0](https://github.com/pgsty/pigsty/releases/tag/v3.4.0) Introduction Blog: [**Pigsty v3.4 MySQL Compatibility and Overall Enhancements**](/blog/pigsty/v3.4) **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-8` locale 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.yml` playbook: launch standard Docker app without extra config - Bump Supabase, Dify, and Odoo app templates, bump 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_data` and `docker_storage_driver` ([#521](https://github.com/pgsty/pigsty/pull/521) by [@waitingsong](https://github.com/waitingsong)) - Added new Infra parameter: `alertmanager_port`, which lets you specify the AlertManager port - Added new Infra parameter: `certbot_sign`, apply for cert during nginx init? (false by default) - 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-4` starting in IvorySQL 4.4 - Changed the default for `pg_lc_ctype` and other locale-related parameters from `en_US.UTF-8` to `C` - For PostgreSQL 17, if using `UTF8` encoding with `C` or `C.UTF-8` locales, PostgreSQL's built-in localization rules now take priority - `configure` automatically detects whether `C.utf8` is supported by both the PG version and the environment, and adjusts locale-related options accordingly - Set the default IvorySQL binary path to `/usr/ivory-4` - Updated the default value of `pg_packages` to `pgsql-main patroni pgbouncer pgbackrest pg_exporter pgbadger vip-manager` - Updated the default value of `repo_packages` to `[node-bootstrap, infra-package, infra-addons, node-package1, node-package2, pgsql-utility, extra-modules]` - Removed `LANG` and `LC_ALL` environment variable settings from `/etc/profile.d/node.sh` - Now using `bento/rockylinux-8` and `bento/rockylinux-9` as 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.yml` playbook now includes a `node_pip` task to configure a pip mirror on each node - The `pgsql.yml` playbook now includes a `pgbackrest_exporter` task for collecting backup metrics - The `Makefile` now allows the use of `META`/`PKG` environment variables - Added `/pg/spool` directory as temporary storage for pgBackRest - Disabled pgBackRest's `link-all` option by default - Enabled block-level incremental backups for MinIO repositories by default **Bug Fixes** - Fixed the exit status code in `pg-backup` ([#532](https://github.com/pgsty/pigsty/pull/532) by [@waitingsong](https://github.com/waitingsong)) - In `pg-tune-hugepage`, restricted PostgreSQL to use only large pages ([#527](https://github.com/pgsty/pigsty/pull/527) by [@waitingsong](https://github.com/waitingsong)) - Fixed logic errors in the `pg-role` task - Corrected type conversion for hugepage configuration parameters - Fixed default value issues for `node_repo_modules` in the `slim` template **Checksums** ```bash 768bea3bfc5d492f4c033cb019a81d3a pigsty-v3.4.0.tgz 7c3d47ef488a9c7961ca6579dc9543d6 pigsty-pkg-v3.4.0.d12.aarch64.tgz b5d76aefb1e1caa7890b3a37f6a14ea5 pigsty-pkg-v3.4.0.d12.x86_64.tgz 42dacf2f544ca9a02148aeea91f3153a pigsty-pkg-v3.4.0.el8.aarch64.tgz d0a694f6cd6a7f2111b0971a60c49ad0 pigsty-pkg-v3.4.0.el8.x86_64.tgz 7caa82254c1b0750e89f78a54bf065f8 pigsty-pkg-v3.4.0.el9.aarch64.tgz 8f817e5fad708b20ee217eb2e12b99cb pigsty-pkg-v3.4.0.el9.x86_64.tgz 8b2fcaa6ef6fd8d2726f6eafbb488aaf pigsty-pkg-v3.4.0.u22.aarch64.tgz 83291db7871557566ab6524beb792636 pigsty-pkg-v3.4.0.u22.x86_64.tgz c927238f0343cde82a4a9ab230ecd2ac pigsty-pkg-v3.4.0.u24.aarch64.tgz 14cbcb90693ed5de8116648a1f2c3e34 pigsty-pkg-v3.4.0.u24.x86_64.tgz ``` ------- ## v3.3.0 - Total available extensions increased to [**404**](/docs/pgsql/ext/)! - PostgreSQL February Minor Updates: 17.4, 16.8, 15.12, 14.17, 13.20 - New Feature: `app.yml` script 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_aliases` to 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](https://github.com/pgsty/pigsty/pull/506) [#524](https://github.com/pgsty/pigsty/pull/524) by [@waitingsong](https://github.com/waitingsong). - Improvement: Refined `ignore_startup_parameters` in `pgbouncer` config template [#488](https://github.com/pgsty/pigsty/pull/488) by [@waitingsong](https://github.com/waitingsong). - New homepage design: Pigsty's website now features a fresh new look. - Extension Directory: Detailed information and download links for RPM/DEB binary packages. - Extension Build: `pig` CLI now auto-sets PostgreSQL extension build environment. **New Extensions** **12** new PostgreSQL extensions added, bringing the total to [404](/ext/list) available extensions. - [documentdb](https://github.com/microsoft/documentdb/) 0.101-0 - [VectorChord-bm25](https://github.com/tensorchord/VectorChord-bm25) (vchord_bm25) 0.1.0 - [pg_tracing](https://github.com/DataDog/pg_tracing) 0.1.2 - [pg_curl](https://github.com/RekGRpth/pg_curl) 2.4 - [pgxicor](https://github.com/Florents-Tselai/pgxicor) 0.1.0 - [pgsparql](https://github.com/lacanoid/pgsparql) 1.0 - [pgjq](https://github.com/Florents-Tselai/pgJQ) 0.1.0 - [hashtypes](https://github.com/adjust/hashtypes/) 0.1.5 - [db_migrator](https://github.com/cybertec-postgresql/db_migrator) 1.0.0 - [pg_cooldown](https://github.com/rbergm/pg_cooldown) 0.1 - [pgcollection](https://github.com/aws/pgcollection) 0.9.1 - [pg_bzip](https://github.com/steve-chavez/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): [`Omnigres`](/ext/e/omni) 33 extensions, postgres as platform - New Extension: [`pg_mooncake`](/ext/e/pg_mooncake): duckdb in postgres - New Extensions: [`pg_xxhash`](/ext/e/xxhash) - New Extension: [`timescaledb_toolkit`](/ext/e/timescaledb_toolkit) - New Extension: [`pg_xenophile`](/ext/e/pg_xenophile) - New Extension: [`pg_drop_events`](/ext/e/pg_drop_events) - New Extension: [`pg_incremental`](/ext/e/pg_incremental) - Bump [`citus`](https://github.com/citusdata/citus/tree/v13.0.0) to 13.0.0 with PostgreSQL 17 support. - Bump [`pgml`](https://github.com/postgresml/postgresml/releases/tag/v2.10.0) to 2.10.0 - Bump [`pg_extra_time`](/ext/e/pg_extra_time) to 2.0.0 - Bump [`pg_vectorize`](/ext/e/vectorize) to 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-citus` package alias - hide `pgxxx-olap` category in `pg_extensions` by default ------- ## v3.2.1 **Highlights** - [**351**](/ext/) PostgreSQL Extensions, including the powerful [postgresql-anonymizer 2.0](https://postgresql-anonymizer.readthedocs.io/en/stable/) - 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**: Introducing the `pig` command-line tool for managing extension plugins. - **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 version 11.4, featuring a new Infinity datasource. **Package Changes** - New Extensions - Added `timescaledb`, `timescaledb-loader`, `timescaledb-toolkit`, and `timescaledb-tool` to the PIGSTY repository. - Added a custom-compiled [pg_timescaledb](https://github.com/timescale/timescaledb) for EL. - Added [pgroonga](/ext/e/pgroonga), custom-compiled for all EL variants. - Added [vchord](https://github.com/tensorchord/VectorChord) 0.1.0. - Added [pg_bestmatch.rs](https://github.com/tensorchord/pg_bestmatch.rs) 0.0.1. - Added [pglite_fusion](https://github.com/frectonz/pglite-fusion) 0.0.3. - Added [pgpdf](https://github.com/Florents-Tselai/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 `prometheus2` to `prometheus`) - **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](https://github.com/mattermost/mattermost) the open-source Slack alternative self-hosting template - Bug Fixes - Added `python3-cdiff` for `el8.aarch64` to fix missing Patroni dependency. - Added `timescaledb-tools` for `el9.aarch64` to fix missing package in official repo. - Added `pg_filedump` for `el9.aarch64` to 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_packages`](/docs/infra/param#repo_url_packages) now defaults to an empty array; packages are installed via OS package managers. - `grafana_plugin_cache` is deprecated; Grafana plugins are now installed via OS package managers. - `grafana_plugin_list` is deprecated for the same reason. - The 36-node "production" template has been renamed to `simu`. - Auto-generated code under `node_id/vars` now includes `aarch64` support. - `infra_packages` now includes the `pig` CLI tool. - The `configure` command now updates the version numbers of `pgsql-xxx` aliases in auto-generated config files. - Update terraform templates with Makefile shortcuts and better provision experience **Bug Fix** - Fix pgbouncer dashboard selector issue [#474](https://github.com/pgsty/pigsty/issues/474) - Add `--arg value` support for `pg-pitr` by [@waitingsong](https://github.com/pgsty/pigsty/pulls?q=is%3Apr+author%3Awaitingsong) - Fix redis log message typo by [@waitingsong](https://github.com/pgsty/pigsty/pull/476) **Checksums** ```bash c42da231067f25104b71a065b4a50e68 pigsty-pkg-v3.2.0.d12.aarch64.tgz ebb818f98f058f932b57d093d310f5c2 pigsty-pkg-v3.2.0.d12.x86_64.tgz d2b85676235c9b9f2f8a0ad96c5b15fd pigsty-pkg-v3.2.0.el9.aarch64.tgz 649f79e1d94ec1845931c73f663ae545 pigsty-pkg-v3.2.0.el9.x86_64.tgz 24c0be1d8436f3c64627c12f82665a17 pigsty-pkg-v3.2.0.u22.aarch64.tgz 0b9be0e137661e440cd4f171226d321d pigsty-pkg-v3.2.0.u22.x86_64.tgz 8fdc6a60820909b0a2464b0e2b90a3a6 pigsty-v3.2.0.tgz ``` -------- ## 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 : Extension Exploding & Pluggable Kernels (MSSQL, Oracle) https://github.com/pgsty/pigsty/releases/tag/v3.0.0 -------- ## v2.7.0 2024-05-16 : Extension Overwhelming, 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 Fix, security enhance and bump grafana version https://github.com/pgsty/pigsty/releases/tag/v2.0.1 -------- ## v2.0.0 2023-02-28 : Compatibility Security Maintainability Enhancement 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 fix & Full translation of English documents. 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 : Upgrade default Postgres to 14, monitoring existing pg 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 Customize 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 on Testing 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 --------