[Pigsty](https://pigsty.io) 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](https://vonng.com/en/pg/pigsty-relicense/). This release brings 320 
commits with significant improvements to observability, security, high 
availability, and Docker container support. See the [v4.0 release 
blog](https://vonng.com/en/pigsty/v4.0/) for details.

Pigsty v4 introduces the [VIBE](https://pigsty.io/docs/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](https://piglet.run) — an 
agentic PostgreSQL runtime for AI workloads, forged as a sub-distribution of 
Pigsty.

This release ships [444 PostgreSQL extensions](https://pgext.cloud/list) across 
PG 13–18 on 14 [Linux distributions](https://pgext.cloud/os) via 
[PGEXT.CLOUD](https://pgext.cloud). Key extensions including TimescaleDB, 
Citus, ParadeDB, DocumentDB, and Apache AGE now support PostgreSQL 18. New 
additions include [pg_textsearch](https://pgext.cloud/e/pg_textsearch/) (BM25 
full-text search), [pg_clickhouse](https://pgext.cloud/e/pg_clickhouse/) FDW, 
and [pljs](https://pgext.cloud/e/pljs/). Default parameters are optimized for 
PG 17/18, including `file_copy_method=clone` for [instant database 
cloning](https://vonng.com/en/pg/pg-clone/).

The observability stack replaces Prometheus and Loki with [VictoriaMetrics, 
VictoriaLogs, and Vector](https://pigsty.io/docs/infra/), 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](https://pigsty.io/docs/concept/ha/rto) 
(fast/norm/safe/wide) with worst-case bounds of 30/45/90/150 seconds and three 
[RPO protection modes](https://pigsty.io/docs/concept/ha/rpo).

Additional highlights: official [Docker 
support](https://pigsty.io/docs/setup/docker/), [JUICE 
module](https://vonng.com/en/pg/pgfs/) for JuiceFS with synchronized database 
and filesystem PITR, multi-cloud Terraform templates, and the Agent-native CLI 
[pig 
v1.0](https://www.postgresql.org/about/news/pig-v10-released-with-pgextcloud-444-pg-extensions-on-14-linux-3214/).
 And it all starts with one command: `curl -fsSL https://repo.pigsty.io/get | 
bash`

**Links**: [GitHub](https://github.com/pgsty/pigsty/releases/tag/v4.0.0) | 
[Docs](https://pigsty.io/docs/) | 
[Install](https://pigsty.io/docs/setup/install/) | [Release 
Blog](https://vonng.com/en/pigsty/v4.0/)

Reply via email to