Pigsty v4.0, a batteries-included PostgreSQL distribution, is now available with a major infrastructure overhaul, PostgreSQL 18 readiness, and a return to the permissive Apache 2.0 license. This release brings 320 commits with significant improvements to observability, security, high availability, and Docker container support. See the v4.0 release blog for details.
Pigsty v4 introduces the VIBE module for AI coding environments and DBA Agents, featuring Claude Code integration with built-in observability dashboards. Combined with PITR-enabled filesystem and instant cloning, these capabilities power PIGLET.RUN — an agentic PostgreSQL runtime for AI workloads, forged as a sub-distribution of Pigsty.
This release ships 444 PostgreSQL extensions across PG 13–18 on 14 Linux distributions via PGEXT.CLOUD. Key extensions including TimescaleDB, Citus, ParadeDB, DocumentDB, and Apache AGE now support PostgreSQL 18. New additions include pg_textsearch (BM25 full-text search), pg_clickhouse FDW, and pljs. Default parameters are optimized for PG 17/18, including file_copy_method=clone for instant database cloning.
The observability stack replaces Prometheus and Loki with VictoriaMetrics, VictoriaLogs, and Vector, delivering ~10x performance gains. Security hardening adds auto-generated strong passwords, etcd RBAC, firewall support, and SELinux optimization. High availability now offers four RTO parameter templates (fast/norm/safe/wide) with worst-case bounds of 30/45/90/150 seconds and three RPO protection modes.
Additional highlights: official Docker support, JUICE module for JuiceFS with synchronized database and filesystem PITR, multi-cloud Terraform templates, and the Agent-native CLI pig v1.0. And it all starts with one command: curl -fsSL https://repo.pigsty.io/get | bash
Links: GitHub | Docs | Install | Release Blog