The Pigsty Community is happy to announce Pigsty 2.6.0, which uses PostgreSQL 16.2 as the default kernel and introduces the new ParadeDB & DuckDB FDW extensions to provide extra OLAP workload support.
We also have a brand new official website available at https://pigsty.io
Getting started with the latest v2.6.0 release with:
bash
curl -fsSL https://get.pigsty.cc/latest
Pigsty is a Battery-included, local-first PostgreSQL Distribution as an open-sourced RDS alternative.
Links: Website | GitHub | Demo | Blog | Install | Feature
Images: Introduction | Extensions | High-Availability | Dashboards
PG with 180+ powerful extensions out of the box: PostGIS, Timescale, Citus, PGVector, AGE, PGML, ParadeDB, Hydra, DuckFDW, GraphQL, ……
Create self-healing HA PostgreSQL clusters with pre-configured PITR, built-in ACL, & SSL, and secure your infra with local CA & best practices.
Unparalleled monitoring best practices build upon the modern Prometheus & Grafana stack. Reuse them to monitor existing DBs & cloud RDS. Check our Gallery & Demo
Deliver auto-routed, high-performance, pooled, reliable, flexible database Services Access via Pgbouncer DNSMasq, Keepalived, vip-manager, and HAProxy.
Infra as Code, Declarative API & Idempotent Playbooks, Vagrant sandbox & Terraform IaaS provisioning specs. Local repo, offline package, delivered without Internet access.
Modular design, flexible arch with many bonus features. Redis, MinIO, ETCD, FerretDB, DuckDB, Supabase, and Docker compose template for software that uses Postgres.
Easy to use: Download, Install, and Configure in one command. Built-in configuration templates for different scenarios, auto-tuned params, admin SOP, and zero-downtime blue-green migration plans.
Run on base OS without containerization support: EL 7, 8, 9 and Rocky, Alma, CentOS, OracleLinux,… and Ubuntu 20.04 / 22.04 and Debian 11 / 12 Support.
Free software open-sourced under the AGPLv3 license, a free RDS for PostgreSQL alternative.