Skip to content

Pigsty v4.2.0

Routine minor release with six PG kernel updates
Routine minor release with six PG kernel updates

v4.2.0 ·

Highlights

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

Major Changes

  • 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

Sources