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 1tGuNk-001gka-6c for pgsql-announce@arkaria.postgresql.org; Fri, 29 Nov 2024 06:21:36 +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 1tGuNM-004dNH-Ux for pgsql-announce@arkaria.postgresql.org; Fri, 29 Nov 2024 06:21:14 +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 1tGuNL-004dFD-4p for pgsql-announce@lists.postgresql.org; Fri, 29 Nov 2024 06:21:12 +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.94.2) (envelope-from ) id 1tGuNF-0007Uw-UJ for pgsql-announce@lists.postgresql.org; Fri, 29 Nov 2024 06:21:10 +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=uVUrHf+rVd64BDHW2IMjRakWuiejEPLWjQlhypeaBzA=; b=J/qVOk4n3WSCGNO/iu2SPYZ+e9 bzIjyxo4zJ8KssWDGmNkOYWLWI9pncWcTfZgNuFKHUNGs1EJgqJvaRllmoXmVUTpFIbxlQLWzGuax IFyigb0Pg8i/ZY4HAJ+FQ3//0i+eIOU6d7y4v+zcw06taKwHpz3mWHqO7pgtZoAxVGwBUFctHexUW NO87HpmogUj+jlDyNDplS9Obs/XXL4D69ynDJBrpCK1fp9ecne7I9sVP1sDSWr5GouMpaT7tA1tSk SYLerfqFpCeWvUwWb9QjvE4nt15eanm9OkX8ZpEWvFzT2xMM1Zo01jHzI6WTBbW/jc319h+FrV4LS 2ZTjiHbg==; 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 1tGuNE-000LMO-Hp for pgsql-announce@lists.postgresql.org; Fri, 29 Nov 2024 06:21:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tGuNC-000W9M-NC for pgsql-announce@lists.postgresql.org; Fri, 29 Nov 2024 06:21:03 +0000 Content-Type: multipart/mixed; boundary="===============4947806140878065906==" MIME-Version: 1.0 Subject: Pigsty v3.1 Release: PG17, Duck Extensions, Self-hosting Supabase, ARM & Ubuntu24 To: PostgreSQL Announce From: Pigsty via PostgreSQL Announce Reply-To: rh@vonng.com Date: Fri, 29 Nov 2024 06:20:21 +0000 Message-ID: <173286122156.713.5087328007220442238@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: fe78cfd7e6780ea0cdb1510261f4779266080a1f975f7e31c9bd48c41754bb39 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4947806140878065906== Content-Type: multipart/alternative; boundary="===============8601108755606122279==" MIME-Version: 1.0 --===============8601108755606122279== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [Pigsty v3.1](https://pigsty.io/blog/releases/v3.1.0/) is now live, closely= following the release of PostgreSQL 17.2.=20 This version marks PostgreSQL 17 as the default, featuring compatibility wi= th the latest Ubuntu 24.04 LTS and initial ARM64 arch support. It also introduces nearly [340](https://ext.pigsty.io/#/list) ready-to-use = PostgreSQL extensions right from the start. A notable feature is the one-click setup for a self-hosted [Supabase](https= ://pigsty.io/docs/kernel/supabase), which is built upon PostgreSQL.=20 Pigsty v3.1 enables you to run Supabase on local-first HA PostgreSQL (ver14= -17) alone with 300+ extensions on [mainstream Linux distros](https://pigst= y.io/docs/reference/compatibility/) without virtualization or containers, u= tilizing modern hardware to its full potential. The update enhances its [repository](https://ext.pigsty.io/#/usage) with ne= w PostgreSQL-compatible kernels like [Babelfish](https://pigsty.io/docs/ker= nel/babelfish/), [IvorySQL](https://pigsty.io/docs/kernel/ivorysql/), and [= PolarDB](https://pigsty.io/docs/kernel/polardb/),=20 and the OLAP / DuckDB race players such as [pg_analytics](https://ext.pigst= y.io/#/pg_analytics), [pg_duckdb](https://ext.pigsty.io/#/pg_duckdb), [pg_m= ooncake](https://ext.pigsty.io/#/pg_mooncake), [pg_parquet](https://ext.pig= sty.io/#/pg_parquet), and [`duckdb_fdw`](https://ext.pigsty.io/#/duckdb_fdw= ), now directly accessible for the pigsty repo.=20 Additionally, MinIO best practices have been refined to lower deployment ba= rriers and allow expanding existing clusters, which are detailed in the new= [admin SOP](http://pigsty.io/docs/minio/admin/). Pigsty 3.1 simplifies configuration across various OS distros by standardiz= ing scenario-based [config templates](https://pigsty.io/docs/conf/overview/= ).=20 You can download and install kernels and extensions by specifying their nam= e. and changing the significant versions with just one `pg_version` paramet= er. With comprehensive support for new operating systems and architectural impr= ovements, Pigsty 3.1 aims to deliver a more feature-rich and cost-effective= OSS RDS PG solution. I hope this could help you easily enjoy the latest PostgreSQL features and = extensions. ## About Pigsty Pigsty is a battery-included, local-first PostgreSQL distribution and an op= en-sourced RDS alternative. Links: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pi= gsty) | [Demo](https://demo.pigsty.cc/) | [Get Started](https://pigsty.io/d= ocs/setup/install/) | [Features](https://pigsty.io/docs/about/feature/) | [= Extension List](https://ext.pigsty.io/#/list) | [v3.1.0 Release Note](https= ://pigsty.io/blog/releases/v3.1.0/) ``` bash curl -fsSL https://repo.pigsty.io/get | bash ``` #### Features - [Extensible](https://pigsty.io/img/pigsty/extension.png): PG 17 - 12, 340= [PG Extensions](https://pigsty.io/docs/pgext/list) & [MSSQL](https://pigst= y.io/docs/kernel/babelfish/), [Oracle](https://pigsty.io/docs/kernel/ivorys= ql/) compatible [Kernel](https://pigsty.io/docs/kernel) replacements availa= ble. - [Reliable](https://pigsty.io/img/pigsty/arch.jpg): Self-healing [HA](http= s://pigsty.io/docs/concept/ha/) clusters with pre-configured [PITR](https:/= /pigsty.io/docs/pgsql/arch#point-in-time-recovery) and built-in [ACL](https= ://pigsty.io/docs/pgsql/acl), [CA & SSL](https://pigsty.io/docs/reference/p= aram/#ca) secure best practice. - [Observable](https://pigsty.io/img/pigsty/dashboard.jpg): SOTA monitoring= for [PG](https://demo.pigsty.cc/d/pgrds-instance/pgrds-instance) / [Infra]= (https://pigsty.io/docs/infra) / [Node](https://pigsty.io/docs/node) based = on Prometheus & Grafana stack: [Demo](https://demo.pigsty.cc/) & [Gallery](= https://github.com/Vonng/pigsty/wiki/Gallery). - [Available](https://pigsty.io/img/pigsty/ha.png): Auto-routed & pooled cu= stomizable database [Services](https://pigsty.io/docs/concept/svc#default-s= ervice) [Access](https://pigsty.io/docs/concept/svc#access-service) with ha= proxy, pgbouncer, and VIP. - [Maintainable](https://pigsty.io/img/pigsty/iac.jpg): [One-Cmd Install](h= ttps://pigsty.io/docs/setup/install), [Admin SOP](https://pigsty.io/docs/pg= sql/admin), Auto-Tune, Local Repo, [IaC,](https://pigsty.io/docs/pgsql/conf= ig) and [Vagrant](https://pigsty.io/docs/setup/provision#vagrant) / [Terraf= orm](https://pigsty.io/docs/setup/provision#terraform) support. - [Composable](https://pigsty.io/img/pigsty/sandbox.jpg): Bonus [Modules](h= ttps://pigsty.io/docs/about/modules) such as [Redis](https://pigsty.io/docs= /redis), [MinIO](https://pigsty.io/docs/minio), [Etcd](https://pigsty.io/do= cs/etcd), [Docker](https://pigsty.io/docs/app), [DuckDB](https://pigsty.io/= docs/pro/duckdb), [FerretDB](https://pigsty.io/docs/ferret), [Supabase](htt= ps://pigsty.io/docs/kernel/supabase/), [& more](https://pigsty.io/docs/pro/= )! #### Advantages - Unparalleled Extension: We packed 143 [RPM](https://ext.pigsty.io/#/rpm) = and 144 [DEB](https://ext.pigsty.io/#/deb) extensions in addition to the of= ficial PGDG repo. - Stunning Observability: Ultimate experience with 3000+ metrics visualized= in 30+ organized dashboards. - Reliable Best Practices: Proven & Polished in large-scale production envi= ronment (25K vCPU) for 5 years+. - NO Docker/Kubernetes: We choose the hard way to deliver RDS based on bare= OS WITHOUT [Containers](https://pigsty.io/blog/db/db-in-k8s/)! - Infrastructure as Code: Describe everything with declarative API and prov= ision with idempotent playbooks! - Free OSS & Local-First: Pigsty is a free software under [AGPLv3](https://= pigsty.io/docs/about/license/). Build for PostgreSQL with passion & love. --===============8601108755606122279== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Pigsty v3.1 Release: PG17, Duck Extensions, Self-hosting Supabas= e, ARM & Ubuntu24
 

Pigsty v3.1 Release: PG17, Duck Extensions, Self-hosting Supabase, AR= M & Ubuntu24

Pigsty v3.1 is now live, closely following the release of PostgreSQL 17.2.=20 This version marks PostgreSQL 17 as the default, featuring compatibility wi= th the latest Ubuntu 24.04 LTS and initial ARM64 arch support. It also introduces nearly 340 ready-to-use PostgreSQ= L extensions right from the start.

A notable feature is the one-click setup fo= r a self-hosted Supabase, which is built u= pon PostgreSQL.=20 Pigsty v3.1 enables you to run Supabase on local-first HA PostgreSQL (ver14= -17) alone with 300+ extensions on ma= instream Linux distros without virtualization or containers, utilizing = modern hardware to its full potential.

The update enhances its repository with new PostgreSQL-compatible kernels like Babelfish, IvorySQL, = and PolarDB,=20 and the OLAP / DuckDB race players such as pg_an= alytics, pg_duckdb, pg_mooncake, pg_parquet, and duckdb_fdw, now directly accessible for the pigsty repo.

Additionally, MinIO best practices have bee= n refined to lower deployment barriers and allow expanding existing cluster= s, which are detailed in the new admin SOP.

Pigsty 3.1 simplifies configuration across = various OS distros by standardizing scenario-based config templates.=20 You can download and install kernels and extensions by specifying their nam= e. and changing the significant versions with just one pg_version parameter.

With comprehensive support for new operatin= g systems and architectural improvements, Pigsty 3.1 aims to deliver a more= feature-rich and cost-effective OSS RDS PG solution. I hope this could help you easily enjoy the latest PostgreSQL features and = extensions.

About Pigsty

Pigsty is a battery-included, local-first P= ostgreSQL distribution and an open-sourced RDS alternative.

Links: Website | GitHub | Demo | = Get Started | Features | Extension List | v3.1.0 Release No= te

bash curl -fsSL https://repo.pigsty.i= o/get | bash

Features

Advantages

  • Unparalleled Extension: We packed 143 RPM and 144 DEB extensions in addit= ion to the official PGDG repo.

  • Stunning Observability: Ultimate experience= with 3000+ metrics visualized in 30+ organized dashboards.

  • Reliable Best Practices: Proven & Polis= hed in large-scale production environment (25K vCPU) for 5 years+.

  • NO Docker/Kubernetes: We choose the hard wa= y to deliver RDS based on bare OS WITHOUT Contai= ners!

  • Infrastructure as Code: Describe everything= with declarative API and provision with idempotent playbooks!

  • Free OSS & Local-First: Pigsty is a fre= e software under AGPLv3. Build for PostgreS= QL with passion & love.
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/.
 
--===============8601108755606122279==-- --===============4947806140878065906==--