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. ----------