Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiqtW-00Gcf6-9S for pgsql-announce@arkaria.postgresql.org; Mon, 04 Aug 2025 08:50:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uiqtV-00HUYZ-9H for pgsql-announce@arkaria.postgresql.org; Mon, 04 Aug 2025 08:50:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiqtU-00HUYJ-8d for pgsql-announce@lists.postgresql.org; Mon, 04 Aug 2025 08:50:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uiqtQ-000elN-2J for pgsql-announce@lists.postgresql.org; Mon, 04 Aug 2025 08:50:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=54/tpNs5OtMUGhJ8DqK4hH6sGARv7pQoSCDz9RBZ5XI=; b=Nhc+CiSugIsBV+HkzY9A/tNAAm An9EeTM9cCH0ddKaLetQSjBj9brc9UUUi7yavB42QyuOComAiu/7M03LP/e+koUVF4TLeyMVIydTB i76Lg9c8f82h8tWzmDBlJMHvRjfD+GU6Ar/pqNihNK78xO5NPg4X2ONC6uRdHhSg2msLrFdmEcIUj xow5nNib8KFuKqK/RUpZEK3pNuUVkivBlux69iiNcZZa8bvC+E0bF98GPe8oBKDlnqdFILygz8kA5 YTr0NEgBTDEcxxw6+Ndx98kRzyQDZcVSPPInTmZ+ci3sqiSHFbbZSLqigb/UW7mDzxzHI0e54ppqk edCaM1BA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiqtQ-001ocR-71 for pgsql-announce@lists.postgresql.org; Mon, 04 Aug 2025 08:50:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uiqtO-003Mw1-2n for pgsql-announce@lists.postgresql.org; Mon, 04 Aug 2025 08:50:03 +0000 Content-Type: multipart/mixed; boundary="===============6366867209179451919==" MIME-Version: 1.0 Subject: Pigsty 3.6, the meta-distribution for PostgreSQL To: PostgreSQL Announce From: Pigsty via PostgreSQL Announce Reply-To: rh@vonng.com Date: Mon, 04 Aug 2025 08:49:32 +0000 Message-ID: <175429737260.799.4020780158265712909@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 5960b693fbe8013fdc0315ac81449bffbb7f68fcd5c2805a7a250a766798911a List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6366867209179451919== Content-Type: multipart/alternative; boundary="===============3636623390938669424==" MIME-Version: 1.0 --===============3636623390938669424== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable The Pigsty team is thrilled to announce **Pigsty v3.6**, our latest step to= ward a true **meta-PostgreSQL distribution**. From a single code base you = can now launch near 10 distinct PostgreSQL kernels =E2=80=94 Babelfish, Ivo= rySQL, OpenHalo, OrioleDB, PolarDB, Supabase-PG, Citus, the brand-new **Per= cona TDE**, and more. - [PostgreSQL](https://doc.pgsty.com/pgsql/kernel/postgres) : Vanilla Postg= reSQL 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 wi= re-compatibility - [IvorySQL](https://doc.pgsty.com/pgsql/kernel/ivorysql) : Oracle Gramma= r and PL/SQL compatible - [OpenHalo](https://doc.pgsty.com/pgsql/kernel/openhalo) : MySQL wire-pr= otocol compatibility - [Percona](https://doc.pgsty.com/pgsql/kernel/percona) : Percona Patch= ed 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 bl= oat, "cloud-native" with S3 Storage - [PolarDB](https://doc.pgsty.com/pgsql/kernel/polardb) : RAC flavor Po= stgres - [Supabase](https://doc.pgsty.com/app/supabase) : BaaS upon Pos= tgreSQL Each kernel is wrapped as a production-ready, RDS-style service: HA with Pa= troni, PITR via pgBackRest, deep observability with Grafana / Prometheus, a= nd fully repeatable infrastructure-as-code -- all without Docker or Kuberne= tes. 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 r= ebuilt 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 Beta= 2**, while versions 17.5, 16.9, 15.13, 14.18, and 13.21 remain fully suppor= ted. Percona TDE and OrioleDB 1.5 =CE=B212 bring our supported-kernel coun= t into double digits. ### Three-step install, one-command PITR Online installation is now the default; it just takes three steps to instal= l everything: ```bash curl -fsSL https://repo.pigsty.cc/get | bash -s v3.6.0; cd ~/pigsty && ./co= nfigure && ./install.yml ``` Need to rewind the clock? The new `pgsql-pitr` playbook handles everything= automatically =E2=80=94 even on multi-node HA clusters. just supply the ta= rget timestamp, XID, or LSN, and it does the rest. ### Supabase hardening & modern observability Pigsty tracks the latest Supabase containers, fixes Logflare replication-sl= ot bloat, and wires up pgsodium keys by default. The monitoring stack move= s to **Grafana 12 + Prometheus 3.5**, with tuned OS profiles for NVMe serve= rs 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, Ferret= DB 2.4, DuckDB 1.3.2, and the new **genai-toolbox**. Browse the catalog or= run `pig install ` to get started. ### Cleaner roles, clearer switches Destructive Etcd and MinIO actions are now isolated in dedicated `*-rm` pla= ybooks, bucket/user provisioning is fully declarative, defaults are rationa= lised (`/data/postgres`, `/data/backups`), and self-signed-cert validity is= controlled by a single variable=E2=80=94resulting in fewer surprises and s= moother rolling upgrades. -------- Pigsty 3.6 tarballs and architecture-specific offline package sets are avai= lable now. This is the final stop before 4.0 =E2=80=94 look forward to Pos= tgreSQL 18 GA support, a vector-based log shipper, and a unified CLI that f= ronts every playbook. > Release Note: https://doc.pgsty.com/release/latest/ --===============3636623390938669424== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Pigsty 3.6, the meta-distribution for PostgreSQL
 

Pigsty 3.6, the meta-distribution for PostgreSQL

The Pigsty team is thrilled to announce Pigsty v3.6, our latest step toward a true meta-Postg= reSQL distribution. From a single code base you can now launch ne= ar 10 distinct PostgreSQL kernels =E2=80=94 Babelfish, IvorySQL, OpenHalo, = OrioleDB, PolarDB, Supabase-PG, Citus, the brand-new Percona TDE, and more.

  • PostgreSQL : Vanilla PostgreSQL with 420+ extensions=
  • Citus : Distributive PostgreSQL via native exte= nsion
  • WiltonDB : SQL Server wire-compatibility
  • IvorySQL : Oracle Grammar and PL/SQL compatible
  • OpenHalo : MySQL wire-protocol compatibility
  • Percona : Percona Patched PG with pg_tde
  • FerretDB : MongoDB wire-protocol compatibility
  • OrioleDB : PG without bloat, "cloud-native" with S= 3 Storage
  • PolarDB : RAC flavor Postgres
  • Supabase : BaaS upon PostgreSQL

Each kernel is wrapped as a production-read= y, RDS-style service: HA with Patroni, PITR via pgBackRest, deep observabil= ity with Grafana / Prometheus, and fully repeatable infrastructure-as-code = -- all without Docker or Kubernetes. Materialized with idemopent ansible pl= aybooks on bare Linux.

This release also introduces a standalone e= xtension catalog (ext.pgsty.com, 423 build= -tested packages) and a completely rebuilt documentation site (= doc.pgsty.com).

Built for PostgreSQL 18 (and fr= iends)

Templates, exporters, and client tooling ar= e 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 =CE=B212 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 &&a= mp; ./configure && ./install.yml

Need to rewind the clock? The new pg= sql-pitr playbook handles everything automatically =E2=80=94 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 container= s, fixes Logflare replication-slot bloat, and wires up pgsodium keys by def= ault. 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 co= unting)

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 in= stall <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 controlle= d by a single variable=E2=80=94resulting in fewer surprises and smoother ro= lling upgrades.

Pigsty 3.6 tarballs and architecture-specif= ic offline package sets are available now. This is the final stop before 4= .0 =E2=80=94 look forward to PostgreSQL 18 GA support, a vector-based log s= hipper, and a unified CLI that fronts every playbook.

Release Note: https://doc.pgsty.com/release= /latest/
This email was sent to you from Pigsty. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Pigsty.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============3636623390938669424==-- --===============6366867209179451919==--