Pigsty v3: 336 extensions and MSSQL/Oracle flavor PG kernels!

The Pigsty community is thrilled to announce Pigsty v3.0, which delivers 336 unique extensions. and several in-place PG kernel replacements.

You can replace vanilla PostgreSQL with Babelfish for MSSQL compatibility, with IvorySQL for ORACLE compatibility, and PolarDB for Aurora flavor. You can also wrap any existing PostgreSQL kernel / RDS with add-ons: serving MongoDB wire protocol with the latest FerretDB or the self-hosting firebase alternative Supabase, which is newly available on Debian/Ubuntu in addition to EL distros.

We also have DuckDB support with the CLI binary and PostgreSQL extensions, such as pg_lakehouse / pg_analytics / duckdb_fdw and pg_duckdb (alpha) and many other extensions, to serve the OLAP race in the PG ecosystem. Check the complete release note for all the details.

About Pigsty

Pigsty is a Battery-included, local-first PostgreSQL Distribution as an open-sourced RDS alternative.

Links: Website | GitHub | Demo | Get Started | Features | v3.0.0 Release Note

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

Features

• Extensible: 336 PG Extensions & 6 PG Kernel replacements available (e.g., MSSQL, Oracle compatibility).
• 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 138 RPM and 133 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.