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

Pigsty v3.1 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 ready-to-use PostgreSQL extensions right from the start.

A notable feature is the one-click setup for a self-hosted 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 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, and the OLAP / DuckDB race players such as pg_analytics, pg_duckdb, pg_mooncake, pg_parquet, and 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.

Pigsty 3.1 simplifies configuration across various OS distros by standardizing scenario-based config templates. 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 | GitHub | Demo | Get Started | Features | Extension List | v3.1.0 Release Note

bash curl -fsSL https://repo.pigsty.io/get | bash

Features

• Extensible: PG 17 - 12, 340 PG Extensions & MSSQL, Oracle compatible Kernel replacements available.
• Reliable: Self-healing HA clusters with pre-configured PITR and built-in ACL, CA & SSL secure best practice.
• Observable: SOTA monitoring for PG / Infra / Node based on Prometheus & Grafana stack: Demo & Gallery.
• Available: Auto-routed & pooled customizable database Services Access with haproxy, pgbouncer, and VIP.
• Maintainable: One-Cmd Install, Admin SOP, Auto-Tune, Local Repo, IaC, and Vagrant / Terraform support.
• Composable: Bonus Modules such as Redis, MinIO, Etcd, Docker, DuckDB, FerretDB, Supabase, & more!

Advantages

• Unparalleled Extension: We packed 143 RPM and 144 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!

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

• Free OSS & Local-First: Pigsty is a free software under AGPLv3. Build for PostgreSQL with passion & love.