Pigsty, Battery-included PostgreSQL Distro & Free RDS Alternative, v2.6 released!

Posted on 2024-03-06 by Pigsty
Related Open Source

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

About Pigsty

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


Extensible Postgres

PG with 180+ powerful extensions out of the box: PostGIS, Timescale, Citus, PGVector, AGE, PGML, ParadeDB, Hydra, DuckFDW, GraphQL, ……

Reliable Infras

Create self-healing HA PostgreSQL clusters with pre-configured PITR, built-in ACL, & SSL, and secure your infra with local CA & best practices.

Observable Graphics

Unparalleled monitoring best practices build upon the modern Prometheus & Grafana stack. Reuse them to monitor existing DBs & cloud RDS. Check our Gallery & Demo

Available Service

Deliver auto-routed, high-performance, pooled, reliable, flexible database Services Access via Pgbouncer DNSMasq, Keepalived, vip-manager, and HAProxy.

Maintainable Toolbox

Infra as Code, Declarative API & Idempotent Playbooks, Vagrant sandbox & Terraform IaaS provisioning specs. Local repo, offline package, delivered without Internet access.

Composable Modules

Modular design, flexible arch with many bonus features. Redis, MinIO, ETCD, FerretDB, DuckDB, Supabase, and Docker compose template for software that uses Postgres.

Painless Experience

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.

Compatible Distros

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.

Open-Source RDS

Free software open-sourced under the AGPLv3 license, a free RDS for PostgreSQL alternative.