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

The [Pigsty](https://pigsty.io/) Community is happy to announce Pigsty [2.6.0](https://github.com/Vonng/pigsty/releases/tag/v2.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**](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](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pigsty) | [Demo](https://demo.pigsty.cc) | [Blog](https://pigsty.io/blog) | [Install](https://pigsty.io/docs/setup/install/) | [Feature](https://pigsty.io/docs/about/feature/)

Images: [**Introduction**](https://pigsty.io/img/pigsty/banner.en.jpg) | [**Extensions**](https://pigsty.io/img/pigsty/extension.png) | [**High-Availability**](https://pigsty.io/img/pigsty/ha.png) | [**Dashboards**](https://pigsty.io/img/pigsty/dashboard.jpg)

-----------

### [Extensible Postgres](https://pigsty.io/docs/reference/extension/)

PG with [180+](https://pigsty.io/docs/reference/extension/#extension-list) powerful [extensions](https://pigsty.io/docs/reference/extension/) out of the box: PostGIS, Timescale, Citus, PGVector, AGE, PGML, ParadeDB, Hydra, DuckFDW, GraphQL, ……

### [Reliable Infras](https://pigsty.io/docs/concept/arch)

Create self-healing [HA](https://pigsty.io/docs/concept/ha/) [PostgreSQL](https://pigsty.io/docs/pgsql/) clusters with pre-configured [PITR](https://pigsty.io/docs/concept/pitr/), built-in [ACL](https://pigsty.io/docs/concept/ac/), & SSL, and secure your infra with local [CA](https://pigsty.io/docs/concept/ca/) & best practices.

### [Observable Graphics](https://demo.pigsty.cc/)

Unparalleled monitoring best practices build upon the modern [Prometheus](https://pigsty.io/docs/infra/#prometheus) & [Grafana](https://pigsty.io/docs/infra/#grafana) stack. Reuse them to monitor existing DBs & cloud [RDS](https://pigsty.io/docs/pgsql/monitor/#monitor-rds). Check our [Gallery](https://github.com/Vonng/pigsty/wiki/Gallery) & [Demo](https://demo.pigsty.cc)

### [Available Service](https://pigsty.io/docs/concept/svc)

Deliver auto-routed, high-performance, pooled, reliable, flexible database [Services](https://pigsty.io/docs/pgsql/svc/#default-service) [Access](https://pigsty.io/docs/concept/svc/#access-service) via Pgbouncer DNSMasq, Keepalived, vip-manager, and HAProxy.

### [Maintainable Toolbox](https://pigsty.io/docs/setup/config/)

[Infra as Code](https://pigsty.io/docs/pgsql/config/), Declarative [API](https://pigsty.io/docs/setup/config/) & Idempotent [Playbooks](https://pigsty.io/docs/setup/playbook/), [Vagrant](https://pigsty.io/docs/setup/provision/#vagrant) sandbox & [Terraform](https://pigsty.io/docs/setup/provision/#terraform) IaaS provisioning specs. Local repo, offline package, delivered without Internet access.

### [Composable Modules](https://pigsty.io/docs/about/module/)

[Modular](https://pigsty.io/docs/concept/arch/#模块) design, flexible arch with many bonus features. [Redis](https://pigsty.io/docs/redis/), [MinIO](https://pigsty.io/docs/minio/), [ETCD](https://pigsty.io/docs/etcd/), [FerretDB](https://pigsty.io/docs/mongo/), [DuckDB](https://github.com/Vonng/pigsty/tree/master/app/duckdb), [Supabase](https://github.com/Vonng/pigsty/tree/master/app/supabase), and [Docker](https://pigsty.io/docs/app/docker/) compose template for software that uses Postgres.

### [Painless Experience](https://pigsty.io/docs/setup/install/)

Easy to use: Download, [Install](https://pigsty.io/docs/setup/install/), and Configure in one command. Built-in configuration templates for different scenarios, auto-tuned params, admin [SOP](https://pigsty.io/docs/pgsql/admin/), and zero-downtime blue-green [migration](https://pigsty.io/docs/pgsql/migration/) plans.

### [Compatible Distros](https://pigsty.io/docs/reference/compatibility/)

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](https://pigsty.io/docs/reference/compare/)

Free software open-sourced under the [AGPLv3](https://pigsty.io/docs/about/license/) license, a [free](https://pigsty.io/docs/reference/compare/) RDS for PostgreSQL alternative.

----------