Release notes from pigsty

Pigsty v.4.3.0

2026-05-03T09:20:51Z

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.0, 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

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

Pigsty v4.3.0 Beta1

2026-05-01T15:24:55Z

No content.

Pigsty v4.2.2

2026-03-23T10:18:11Z

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

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 PG 13 Obsolete

2026-03-06T01:37:32Z

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, 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 on 2025-11-13.
The PGDG YUM repository has archived and removed the pg13 / pg12 directories.
If you install Pigsty on EL systems (even without using PG 13), repo access failures may cause installation or update errors.

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

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

Warning

PGDG 13/12 YUM REMOVE REMOVED SINCE MAR 2026!

v4.2.0 Kernel Update

2026-02-28T06:36:58Z

Highlights

Aligned with PostgreSQL out-of-band minor updates: 18.3, 17.9, 16.13, 15.17, 14.22.
Total PostgreSQL extension coverage reaches 461 packages.
Kernel updates across Babelfish, AgensGraph, pgEdge, OriolePG, OpenHalo, and Cloudberry.
Babelfish template now uses a Pigsty-maintained PG17-compatible build, with no WiltonDB repo dependency.
Supabase images and self-hosted templates are refreshed to the latest stack, using Pigsty-maintained pgsty/minio.

Major Changes

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
DEB Changelog 2026-02-27
Core upgrades: timescaledb 2.25.0 -> 2.25.1, citus 14.0.0-3 -> 14.0.0-4, pg_search -> 0.21.9
New/rebuilt: pgedge 17.9, spock 5.0.5, lolor 1.2.2, snowflake 2.4, babelfish 5.5.0, cloudberry 2.0.0
Kernel-side updates: oriolepg 17.11 -> 17.16, orioledb beta12 -> beta14, openhalo 14.10 -> 1.0(14.18)

Package	Old Version	New Version	Notes
`timescaledb`	2.25.0	2.25.1
`citus`	14.0.0-3	14.0.0-4	Rebuilt from the latest official release
`age`	1.7.0	1.7.0	Added PG 17 support for version 1.7.0
`pgmq`	1.10.0	1.10.1	Package currently unavailable
`pg_search`	0.21.7 / 0.21.6	0.21.9	Previous RPM/DEB versions differ
`oriolepg`	17.11	17.16	OriolePG kernel update
`orioledb`	beta12	beta14	Matches OriolePG 17.16
`openhalo`	14.10	1.0	Updated and renamed, based on 14.18
`pgedge`	-	17.9	New multi-master edge-distributed kernel
`spock`	-	5.0.5	New core pgEdge extension
`lolor`	-	1.2.2	New core pgEdge extension
`snowflake`	-	2.4	New core pgEdge extension
`babelfishpg`	-	5.5.0	New BabelfishPG package group
`babelfish`	-	5.5.0	New Babelfish compatibility package
`antlr4-runtime413`	-	4.13	New runtime dependency for Babelfish
`cloudberry`	-	2.0.0	RPM build only
`pg_background`	-	1.8	DEB build only

Infrastructure Software Updates

Name	Old Version	New Version
`grafana`	12.3.2	12.4.0
`prometheus`	3.9.1	3.10.0
`mongodb_exporter`	0.47.2	0.49.0
`victoria-metrics`	1.135.0	1.136.0
`victoria-metrics-cluster`	1.135.0	1.136.0
`vmutils`	1.135.0	1.136.0
`victoria-logs`	1.45.0	1.47.0
`vlagent`	1.45.0	1.47.0
`vlogscli`	1.45.0	1.47.0
`loki`	3.6.5	3.6.7
`promtail`	3.6.5	3.6.7
`logcli`	3.6.5	3.6.7
`grafana-victorialogs-ds`	0.24.1	0.26.2
`grafana-victoriametrics-ds`	0.21.0	0.23.1
`grafana-infinity-ds`	3.7.0	3.7.2
`redis_exporter`	1.80.2	1.81.0
`etcd`	3.6.7	3.6.8
`dblab`	0.34.2	0.34.3
`tigerbeetle`	0.16.72	0.16.74
`seaweedfs`	4.09	4.13
`rustfs`	1.0.0-alpha.82	1.0.0-alpha.83
`uv`	0.10.0	0.10.4
`kafka`	4.1.1	4.2.0
`npgsqlrest`	3.7.0	3.10.0
`postgrest`	14.4	14.5
`caddy`	2.10.2	2.11.1
`rclone`	1.73.0	1.73.1
`pev2`	1.20.1	1.20.2
`genai-toolbox`	0.25.0	0.27.0
`opencode`	1.1.59	1.2.15
`claude`	2.1.37	2.1.59
`codex`	0.104.0	0.105.0
`code`	1.109.2	1.109.4
`code-server`	4.108.2	4.109.2
`nodejs`	24.13.1	24.14.0
`pig`	1.1.2	1.3.0
`stalwart`	-	0.15.5
`maddy`	-	0.8.2

API Changes

pg_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

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 PG & Linux Minor Update

2026-02-23T07:02:12Z

Caution

Do Not Deploy with v4.1.0 Packages Until PostgreSQL Patch Release

The offline packages shipped with Pigsty v4.1.0 were built against PostgreSQL 18.2, 17.8, and corresponding minor versions. Two bugs have since been identified in these releases, and the PostgreSQL Global Development Group will publish out-of-cycle minor releases (e.g. 18.3, 17.9, …) on 2026-02-26 to address them.
We strongly recommend holding off on any new deployment until Pigsty v4.2.0 is available with the patched PostgreSQL packages. Specifically:

Do not perform online installations during this window — upstream repos will pull in the affected versions until the fix is published.
Do not use the v4.1.0 offline packages — they contain the affected binaries.
If you have an urgent deployment need, consider using the v4.0.0 offline packages, which ship with the PostgreSQL 18.1 series and are not affected. We will release Pigsty v4.2.0 shortly after the upstream patch lands. Stay tuned.

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
DEB Changelog 2026-02-12
timescaledb 2.24.0 -> 2.25.0
pg_search 0.21.4 -> 0.21.7
pgmq 1.9.0 -> 1.10.0
pg_textsearch 0.4.0 -> 0.5.0
pljs 1.0.4 -> 1.0.5
pg_track_optimizer 0.9.1 (new)
nominatim_fdw 1.1.0 (new)
pg_utl_smtp 1.0.0 (new)
pg_strict 1.0.2 (new)
pgmb 1.0.0 (new)
pg_pwhash (new support)
informix_fdw (new support)

INFRA Component Versions

Infra Changelog 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)

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 for many valuable suggestions and issues.

Checksums

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

Pigsty v4.0: Into the AI Era

2026-01-30T08:43:37Z

Quick Start

curl https://pigsty.io/get | bash -s v4.0.0

318 commits, 604 files changed, +118,655 / -327,552 lines

Release Date: 2026-01-28 | GitHub | Docs EN | Docs CN

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

Infrastructure Package Updates

MinIO now uses pgsty/minio fork RPM/DEB.

Package	Version	Package	Version
victoria-metrics	1.134.0	victoria-logs	1.43.1
vector	0.52.0	grafana	12.3.1
alertmanager	0.30.1	etcd	3.6.7
duckdb	1.4.4	pg_exporter	1.1.2
pgbackrest_exporter	0.22.0	blackbox_exporter	0.28.0
node_exporter	1.10.2	minio	20251203
pig	1.0.0	claude	2.1.19
opencode	1.1.34	uv	0.9.26
asciinema	3.1.0	prometheus	3.9.1
pushgateway	1.11.2	juicefs	1.4.0
code-server	4.100.2	caddy	2.10.2
hugo	0.154.5	cloudflared	2026.1.1
headscale	0.27.1

Docker Support

Pigsty now supports running in Docker containers with full systemd support, working on both macOS (Docker Desktop) and Linux.

Quick Start:

cd ~/pigsty/docker; make launch    # = make up config deploy

New Modules

v4.0.0 adds two optional modules that don't affect core Pigsty functionality:

JUICE Module: JuiceFS Distributed Filesystem

Uses PostgreSQL as metadata engine, supports PITR recovery for filesystem
Multiple storage backends: PostgreSQL large objects, MinIO, S3
Multi-instance deployment with Prometheus metrics per instance
New node-juice dashboard for JuiceFS monitoring
New juice.yml playbook for deployment
Parameters: juice_cache, juice_instances

VIBE Module: AI Coding Sandbox (Code-Server + JupyterLab + Node.js + Claude Code)

Code-Server: VS Code in browser
- Deploy Code-Server with Nginx reverse proxy for HTTPS
- Supports Open VSX and Microsoft extension galleries
- Set code_enabled: false to disable
- Parameters: code_enabled, code_port, code_data, code_password, code_gallery
JupyterLab: Interactive computing environment
- Deploy JupyterLab with Nginx reverse proxy for HTTPS
- Python venv configuration for data science libraries
- Set jupyter_enabled: false to disable
- Parameters: jupyter_enabled, jupyter_port, jupyter_data, jupyter_password, jupyter_venv
Node.js: JavaScript runtime environment
- Install Node.js with npm package manager
- Auto-configure China npm mirror when region=china
- Set nodejs_enabled: false to disable
- Parameters: nodejs_enabled, nodejs_registry
Claude Code: AI coding assistant CLI configuration
- Configure Claude Code CLI, skip onboarding
- Built-in OpenTelemetry config sending metrics/logs to Victoria stack
- New claude-code dashboard for usage monitoring
- Set claude_enabled: false to disable
- Parameters: claude_enabled, claude_env
New vibe.yml playbook for full VIBE deployment
Use conf/vibe.yml template for quick AI coding sandbox setup
Common parameter: vibe_data (default /fs) for workspace directory

PostgreSQL Extension Updates

Major extensions add PG 18 support: age, citus, documentdb, pg_search, timescaledb, pg_bulkload, rum, etc.

New Extensions:

pg_textsearch 0.4.0 - TimescaleDB full-text search
pg_clickhouse 0.1.3 - ClickHouse FDW
pg_ai_query 0.1.1 - AI query extension
etcd_fdw 0.0.0 - etcd FDW
pg_ttl_index 0.1.0 - TTL index
pljs 1.0.4 - JavaScript procedural language
pg_retry 1.0.0 - Retry extension
pg_weighted_statistics 1.0.0 - Weighted statistics
pg_enigma 0.5.0 - Encryption extension
pglinter 1.0.1 - SQL Linter
documentdb_extended_rum 0.109 - DocumentDB RUM
mobilitydb_datagen 1.3.0 - MobilityDB data generator

Major Updates:

Extension	Old	New	Notes
timescaledb	2.23.x	2.24.0	+PG18
pg_search	0.19.x	0.21.4	ParadeDB, +PG18
citus	13.2.0	14.0.0	Distributed PG, +PG18
documentdb	0.106	0.109	MongoDB compat, +PG18
age	1.5.0	1.7.0	Graph DB, +PG18
pg_duckdb	1.1.0	1.1.1	DuckDB integration
vchord	0.5.3	1.0.0	VectorChord
vchord_bm25	0.2.2	0.3.0	BM25 full-text search
pg_biscuit	1.0	2.2.2	Biscuit auth
pg_anon	2.4.1	2.5.1	Data anonymization
wrappers	0.5.6	0.5.7	Supabase FDW
pg_vectorize	0.25.0	0.26.0	Vectorization
pg_session_jwt	0.3.3	0.4.0	JWT session
pg_partman	5.3.x	5.4.0	Partition mgmt, PGDG
pgmq	1.8.0	1.9.0	Message queue
pg_bulkload	3.1.22	3.1.23	Bulk load, +PG18
pg_timeseries	0.1.7	0.2.0	Time series
pg_convert	0.0.4	0.1.0	Type conversion
pg_clickhouse	0.1.2	0.1.3	ClickHouse FDW

pgBackRest updated to 2.58 with HTTP support.

Observability

VictoriaMetrics replaces Prometheus — achieving 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
Recording temp file allocations over 1MB in PG logs, enabling PG 17/18 log parameters in specific templates
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
pgbackrest_exporter default cache interval reduced from 600s to 120s
grafana_clean default changed from true to false
New pg_timeline collector for real-time timeline metrics pg_timeline_id
New pg:ixact_ratio metric for idle transaction ratio monitoring
pg_exporter updated to 1.1.2 with pg_timeline collector and numerous fixes
Added slot name coalesce for pg_recv metrics collector
Blackbox ping monitoring support enabled
New node-vector dashboard for Vector monitoring
New node-juice dashboard for JuiceFS monitoring
New claude-code dashboard for Claude Code usage monitoring
PGSQL Cluster/Instance dashboards add version banner
All dashboards use compact JSON format, significantly reducing file size

Interface Improvements

Playbook Rename

install.yml renamed to deploy.yml for better semantics
New vibe.yml playbook for VIBE AI coding sandbox

pg_databases Improvements

Database removal: use state field (create, absent, recreate)
Database cloning: use strategy parameter for clone method
Support newer locale params: locale_provider, icu_locale, icu_rules, builtin_locale
Support is_template to mark template databases
Added type checks to prevent character parameter injection
Allow state: absent in extension to remove extensions

pg_users Improvements

New admin parameter similar to roles but with ADMIN OPTION for re-granting
New set and inherit options for user role attributes

pg_hba Improvements

Support order field for HBA rule priority
Support IPv6 localhost access
Allow specifying trusted intranet via node_firewall_intranet

Other Improvements

Default privileges for Supabase roles
node_crontab auto-restores original crontab on node-rm
New infra_extra_services for homepage service entries

Parameter Optimization

I/O Parameters

pg_io_method: auto, sync, worker, io_uring options, default worker
maintenance_io_concurrency set to 100 for SSD
effective_io_concurrency reduced from 1000 to 200
file_copy_method set to clone for PG18 instant database cloning

Replication & Logging

idle_replication_slot_timeout: default 7d, crit template 3d
log_lock_failures: enabled for oltp, crit templates
track_cost_delay_timing: enabled for olap, crit templates
log_connections: auth logs for oltp/olap, full logs for crit

HA Parameters

New pg_rto_plan integrating Patroni & HAProxy RTO config
- fast: Fastest failover (~15s), for high availability requirements
- norm: Standard mode (~30s), balanced (default)
- safe: Safe mode (~60s), reduced false positives
- wide: Relaxed mode (~120s), for geo-distributed deployments
pg_crontab: scheduled tasks for postgres dbsu
For PG17+, explicitly disable checksums if pg_checksums is off
Crit template enables Patroni strict sync mode

Backup & Recovery

PITR default archive_mode changed to preserve
pg-pitr supports pre-recovery backup

Other

Fixed duckdb.allow_community_extensions always active issue
pg_hba and pgbouncer_hba now support IPv6 localhost

Architecture Improvements

Directories & Portal

Fixed /infra symlink pointing to /data/infra on Infra nodes
Infra data defaults to /data/infra for container convenience
Local repo at /data/nginx/pigsty, /www symlinks to /data/nginx
DNS records moved to /infra/hosts, solving Ansible SELinux race condition
Default homepage domain renamed from h.pigsty to i.pigsty, added Chinese homepage

Scripts

New /pg/bin/pg-fork for instant CoW replica creation
Enhanced /pg/bin/pg-pitr for instance-level PITR with pre-backup
New /pg/bin/pg-drop-role for safe user deletion
New bin/pgsql-ext for extension installation
Restored pg-vacuum and pg-repack scripts

New Playbooks

juice.yml: Deploy JuiceFS instances
vibe.yml: Deploy VIBE AI sandbox (Code-Server, JupyterLab, Node.js, Claude Code)

Module Improvements

Explicit cron/cronie package installation for minimal system compatibility
UV Python manager moved from infra to node module, new node_uv_env parameter
pg_remove/pg_pitr etcd metadata removal now runs on etcd cluster
Simu template simplified from 36 to 20 nodes
Removed PGDG sysupdate repo and llvmjit packages on EL systems
Using full OS version (major.minor) for EPEL 10 / PGDG 9/10 repos
Allow meta parameter in repo definitions
Vagrant libvirt templates default to 128GB disk with xfs at /data
Ensure pgbouncer doesn't modify 0.0.0.0 to *
New 10-node and Citus Vagrant templates
Restored EL7 compatibility

System Tuning

Tuned systemd service NOFILE limits based on actual workload requirements
Fixed tuned profile activation by restarting tuned service after changes
Added runtime directory for PostgreSQL systemd service
Fixed ip_local_port_range start/end value parity alignment

Multi-Cloud

Terraform templates: AWS, Azure, GCP, Hetzner, DigitalOcean, Linode, Vultr, TencentCloud

Security Improvements

Password Management

configure supports -g flag for auto-generating strong random passwords
Changed MinIO default password to avoid well-known defaults

Firewall & SELinux

Replaced node_disable_firewall with node_firewall_mode (off/none/zone)
Replaced node_disable_selinux with node_selinux_mode (disabled/permissive/enforcing)
Configured correct SELinux contexts for HAProxy, Nginx, DNSMasq, Redis

Access Control

Enabled etcd RBAC, each cluster can only manage its own PG cluster
etcd root password stored in /etc/etcd/etcd.pass, admin-readable only
Added admin_ip to Patroni API whitelist
Always create admin system group, patronictl restricted to admin group
New node_admin_sudo parameter for admin sudo mode (all/nopass)
Revoked script ownership from non-root users

Certificates & Auth

Nginx Basic Auth support for optional HTTP authentication
Fixed ownca certificate validity for Chrome recognition
New vip_auth_pass parameter for VRRP authentication

Other

Fixed ansible copy content empty field errors
Fixed pg_pitr race conditions during Patroni cluster recovery
Protected files/pki/ca directory with mode 0700

Bug Fixes

Issue	Resolution
ownca certificate Chrome compatibility	Set ownca_not_after correctly
Vector 0.52 syslog_raw parsing	Adapted to new Vector format
pg_pitr multi-replica clonefrom timing	Fixed Patroni recovery race condition
Ansible SELinux dnsmasq race condition	Moved DNS records to /infra/hosts
EL9 aarch64 patroni & llvmjit	Hotfix for ARM64 compatibility
Debian groupadd path	Fixed user group add path
Empty sudoers file generation	Prevented empty sudoers config
pgbouncer pid path	Use `/run/postgresql`
duckdb.allow_community_extensions active	Fixed DuckDB extension config
pg_partman EL8 upstream break	Hidden pg_partman on EL8
HAProxy service template variable path	Fixed variable reference
Redis remove task variable name	Fixed redis_seq to redis_node
MinIO reload handler ineffective	Removed ineffective handler
vmetrics_port default value	Corrected to 8428
pg-failover-callback script	Handle all Patroni callback events
pg-vacuum transaction block	Fixed transaction handling
pg_sub_16 parallel logical worker	Added PG16+ parallel replication
FerretDB cert SAN and restart policy	Fixed cert config and restart
Polar Exporter metric types	Corrected metric type definitions
proxy_env package install missing	Fixed proxy env propagation
patroni_method=remove service issue	Fixed postgres service in remove mode
Docker default data directory	Updated to correct path
EL10 cache compatibility	Fixed EL10 cache issues
etcd/MinIO removal cleanup incomplete	Fixed systemd service and DNS cleanup
IvorySql 18 file_copy_method	Fixed incompatibility with clone method
tuned profile activation	Fixed by restarting tuned service

Parameter Changes

New Parameters

Parameter	Type	Default	Description
`node_firewall_mode`	enum	none	Firewall mode: off/none/zone
`node_selinux_mode`	enum	permissive	SELinux mode
`node_firewall_intranet`	string	-	HBA trusted intranet
`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
`vip_auth_pass`	string	-	VRRP auth password
`grafana_pgurl`	string	-	Grafana PG backend URL
`grafana_view_password`	string	DBUser.Viewer	Grafana Meta datasource password
`infra_extra_services`	list	[]	Homepage extra service entries
`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_port`	port	8443	Code-Server listen port
`code_data`	path	/data/code	Code-Server data directory
`code_password`	string	Vibe.Coding	Code-Server password
`code_gallery`	enum	openvsx	Extension gallery: openvsx/microsoft
`jupyter_enabled`	bool	true	Enable JupyterLab
`jupyter_port`	port	8888	JupyterLab listen port
`jupyter_data`	path	/data/jupyter	JupyterLab data directory
`jupyter_password`	string	Vibe.Coding	JupyterLab access token
`jupyter_venv`	path	/data/venv	Python venv path
`claude_enabled`	bool	true	Enable Claude Code configuration
`claude_env`	dict	{}	Claude Code extra env vars
`nodejs_enabled`	bool	true	Enable Node.js installation
`nodejs_registry`	string	''	npm registry, auto china mirror
`node_uv_env`	path	/data/venv	Node UV venv path, empty to skip
`node_pip_packages`	string	''	pip packages for UV venv

Removed Parameters

Parameter	Replacement
`node_disable_firewall`	`node_firewall_mode`
`node_disable_selinux`	`node_selinux_mode`
`infra_pip_packages`	`node_pip_packages`
`pgbackrest_clean`	Unused, removed
`pg_pwd_enc`	Removed, always scram-sha-256
`code_home`	`vibe_data`
`jupyter_home`	`vibe_data`

Default Value Changes

Parameter	Change	Notes
`grafana_clean`	true → false	Don't clean by default
`effective_io_concurrency`	1000 → 200	More reasonable default
`node_firewall_mode`	zone → none	Disable firewall rules
`install.yml`	Renamed to `deploy.yml`	Better semantics

Compatibility

OS	x86_64	aarch64
EL 8/9/10	✅	✅
Debian 11/12/13	✅	✅
Ubuntu 22.04/24.04	✅	✅

PostgreSQL: 13, 14, 15, 16, 17, 18

Checksums

9f42b8c64180491b59bd03016c26e8ca  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

v4.0.0-rc2

2026-01-19T01:10:08Z

add default privileges for supabase roles

Pigsty v3.7.0

2025-12-06T06:19:55Z

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: Dedicate 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:

API Changes

Implemented a refined optimization strategy for parallel execution parameters. See Tuning Guide.
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

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 Minor Release

2025-08-15T13:35:16Z

curl https://repo.pigsty.cc/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

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