The Pigsty team is thrilled to announce **Pigsty v3.6**, our latest step toward a true **meta-PostgreSQL distribution**. From a single code base you can now launch near 10 distinct PostgreSQL kernels — Babelfish, IvorySQL, OpenHalo, OrioleDB, PolarDB, Supabase-PG, Citus, the brand-new **Percona TDE**, and more.
- [PostgreSQL](https://doc.pgsty.com/pgsql/kernel/postgres) : Vanilla PostgreSQL with 420+ extensions - [Citus](https://doc.pgsty.com/pgsql/kernel/citus) : Distributive PostgreSQL via native extension - [WiltonDB](https://doc.pgsty.com/pgsql/kernel/babelfish) : SQL Server wire-compatibility - [IvorySQL](https://doc.pgsty.com/pgsql/kernel/ivorysql) : Oracle Grammar and PL/SQL compatible - [OpenHalo](https://doc.pgsty.com/pgsql/kernel/openhalo) : MySQL wire-protocol compatibility - [Percona](https://doc.pgsty.com/pgsql/kernel/percona) : Percona Patched PG with pg_tde - [FerretDB](https://doc.pgsty.com/pgsql/kernel/ferretdb) : MongoDB wire-protocol compatibility - [OrioleDB](https://doc.pgsty.com/pgsql/kernel/orioledb) : PG without bloat, "cloud-native" with S3 Storage - [PolarDB](https://doc.pgsty.com/pgsql/kernel/polardb) : RAC flavor Postgres - [Supabase](https://doc.pgsty.com/app/supabase) : BaaS upon PostgreSQL Each kernel is wrapped as a production-ready, RDS-style service: HA with Patroni, PITR via pgBackRest, deep observability with Grafana / Prometheus, and fully repeatable infrastructure-as-code -- all without Docker or Kubernetes. Materialized with idemopent ansible playbooks on bare Linux. This release also introduces a standalone extension catalog ([ext.pgsty.com](https://ext.pgsty.com), **423** build-tested packages) and a completely rebuilt documentation site ([doc.pgsty.com](https://doc.pgsty.com)). ------ ### Built for PostgreSQL 18 (and friends) Templates, exporters, and client tooling are ready for **PostgreSQL 18 Beta2**, while versions 17.5, 16.9, 15.13, 14.18, and 13.21 remain fully supported. Percona TDE and OrioleDB 1.5 β12 bring our supported-kernel count into double digits. ### Three-step install, one-command PITR Online installation is now the default; it just takes three steps to install everything: ```bash curl -fsSL https://repo.pigsty.cc/get | bash -s v3.6.0; cd ~/pigsty && ./configure && ./install.yml ``` Need to rewind the clock? The new `pgsql-pitr` playbook handles everything automatically — even on multi-node HA clusters. just supply the target timestamp, XID, or LSN, and it does the rest. ### Supabase hardening & modern observability Pigsty tracks the latest Supabase containers, fixes Logflare replication-slot bloat, and wires up pgsodium keys by default. The monitoring stack moves to **Grafana 12 + Prometheus 3.5**, with tuned OS profiles for NVMe servers and an optional plain-HTTP mode for MinIO. ### 423 packaged extensions (and counting) Highlights include **pgactive 2.1.5**, TimescaleDB 2.21, Citus 13.1, FerretDB 2.4, DuckDB 1.3.2, and the new **genai-toolbox**. Browse the catalog or run `pig install <name>` to get started. ### Cleaner roles, clearer switches Destructive Etcd and MinIO actions are now isolated in dedicated `*-rm` playbooks, bucket/user provisioning is fully declarative, defaults are rationalised (`/data/postgres`, `/data/backups`), and self-signed-cert validity is controlled by a single variable—resulting in fewer surprises and smoother rolling upgrades. -------- Pigsty 3.6 tarballs and architecture-specific offline package sets are available now. This is the final stop before 4.0 — look forward to PostgreSQL 18 GA support, a vector-based log shipper, and a unified CLI that fronts every playbook. > Release Note: https://doc.pgsty.com/release/latest/
