[Pigsty v3.1](https://pigsty.io/blog/releases/v3.1.0/) is now live, closely following the release of PostgreSQL 17.2. This version marks PostgreSQL 17 as the default, featuring compatibility with 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. Pigsty v3.1 enables you to run Supabase on local-first HA PostgreSQL (ver14-17) alone with 300+ extensions on [mainstream Linux distros](https://pigsty.io/docs/reference/compatibility/) without virtualization or containers, utilizing modern hardware to its full potential. The update enhances its [repository](https://ext.pigsty.io/#/usage) with new PostgreSQL-compatible kernels like [Babelfish](https://pigsty.io/docs/kernel/babelfish/), [IvorySQL](https://pigsty.io/docs/kernel/ivorysql/), and [PolarDB](https://pigsty.io/docs/kernel/polardb/), and the OLAP / DuckDB race players such as [pg_analytics](https://ext.pigsty.io/#/pg_analytics), [pg_duckdb](https://ext.pigsty.io/#/pg_duckdb), [pg_mooncake](https://ext.pigsty.io/#/pg_mooncake), [pg_parquet](https://ext.pigsty.io/#/pg_parquet), and [`duckdb_fdw`](https://ext.pigsty.io/#/duckdb_fdw), now directly accessible for the pigsty repo. Additionally, MinIO best practices have been refined to lower deployment barriers 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 standardizing scenario-based [config templates](https://pigsty.io/docs/conf/overview/). You can download and install kernels and extensions by specifying their name. and changing the significant versions with just one `pg_version` parameter. With comprehensive support for new operating 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 PostgreSQL distribution and an open-sourced RDS alternative. Links: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pigsty) | [Demo](https://demo.pigsty.cc/) | [Get Started](https://pigsty.io/docs/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://pigsty.io/docs/kernel/babelfish/), [Oracle](https://pigsty.io/docs/kernel/ivorysql/) compatible [Kernel](https://pigsty.io/docs/kernel) replacements available. - [Reliable](https://pigsty.io/img/pigsty/arch.jpg): Self-healing [HA](https://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/param/#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 customizable database [Services](https://pigsty.io/docs/concept/svc#default-service) [Access](https://pigsty.io/docs/concept/svc#access-service) with haproxy, pgbouncer, and VIP. - [Maintainable](https://pigsty.io/img/pigsty/iac.jpg): [One-Cmd Install](https://pigsty.io/docs/setup/install), [Admin SOP](https://pigsty.io/docs/pgsql/admin), Auto-Tune, Local Repo, [IaC,](https://pigsty.io/docs/pgsql/config) and [Vagrant](https://pigsty.io/docs/setup/provision#vagrant) / [Terraform](https://pigsty.io/docs/setup/provision#terraform) support. - [Composable](https://pigsty.io/img/pigsty/sandbox.jpg): Bonus [Modules](https://pigsty.io/docs/about/modules) such as [Redis](https://pigsty.io/docs/redis), [MinIO](https://pigsty.io/docs/minio), [Etcd](https://pigsty.io/docs/etcd), [Docker](https://pigsty.io/docs/app), [DuckDB](https://pigsty.io/docs/pro/duckdb), [FerretDB](https://pigsty.io/docs/ferret), [Supabase](https://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 official PGDG repo. - Stunning Observability: Ultimate experience with 3000+ metrics visualized in 30+ organized dashboards. - Reliable Best Practices: Proven & Polished in large-scale production environment (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 provision 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.
