# Pigsty

LLMS index: [llms.txt](/llms.txt)

---

Section pages:

- [Pigsty v4.5: 575 Extensions, Kafka, MySQL, Valkey, and Silo](/blog/pigsty/v4.5/)
- [Pigsty v4.3: 510 Extensions & Ubuntu 26](/blog/pigsty/v4.3/): Pigsty v4.3 adds 50 PostgreSQL extensions, bringing the total to 510. It also adds Ubuntu 26.04 x86_64/arm64 support, refreshes Supabase, pgEdge, PolarDB, Grafana, MinIO, and a batch of infra packages.
- [Pigsty v4.2: 12 Kernels](/blog/pigsty/v4.2/)
- [Pigsty v4.1: Day-Zero 18.2 Support](/blog/pigsty/v4.1/)
- [Pigsty v4.0: Victoria Stack + Security Hardening](/blog/pigsty/v4.0/): VictoriaMetrics/Logs replace Prometheus/Loki for 10x observability performance, Vector handles logs, unified UI, firewall/SELinux/credential hardening.
- [Pigsty v3.7: PostgreSQL Magneto Award, PG18 Deep Support](/blog/pigsty/v3.7/): PostgreSQL 18 becomes the default version, EL10 and Debian 13 support added, extensions reach 437, and Pigsty wins the PostgreSQL Magneto Award.
- [Pigsty v3.6: The Ultimate PostgreSQL Distribution](/blog/pigsty/v3.6/): New doc site, PITR playbook, Percona PG TDE kernel support, and Supabase self-hosting optimization make v3.6 the last major release before 4.0.
- [Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions](/blog/pigsty/v3.5/): Pigsty crosses 4K GitHub stars, adds PG18 beta support, pushes extensions to 421, ships new doc site, and completes OrioleDB/OpenHalo full-platform support.
- [Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates](/blog/pigsty/v3.4/): Pigsty v3.4 adds pgBackRest backup monitoring, cross-cluster PITR restore, automated HTTPS certificates, locale best practices, and full-platform IvorySQL and Apache AGE support.
- [Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website](/blog/pigsty/v3.3/): Pigsty v3.3 pushes available extensions to 404, adds turnkey app deployment with app.yml, delivers Certbot integration for automated HTTPS, and launches a redesigned website.
- [Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements](/blog/pigsty/v3.2/): Pigsty v3.2 introduces the pig CLI for PostgreSQL package management, complete ARM64 extension repository support, and Supabase & Grafana enhancements.
- [Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24](/blog/pigsty/v3.1/): Pigsty v3.1 makes PostgreSQL 17 the default, delivers one-click Supabase self-hosting, adds ARM64 and Ubuntu 24.04 support, and simplifies configuration management.
- [Pigsty v3.0: Pluggable Kernels & 340 Extensions](/blog/pigsty/v3.0/): Pigsty v3.0 ships 340 extensions across EL/Deb with full parity, adds pluggable kernels (Babelfish, IvorySQL, PolarDB) for MSSQL/Oracle compatibility, and delivers a local-first state-of-the-art RDS experience.
- [Pigsty v2.7: The Extension Superpack](/blog/pigsty/v2.7/): Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.
- [Pigsty v2.6: PostgreSQL Crashes the OLAP Party](/blog/pigsty/v2.6/): Pigsty v2.6 makes PostgreSQL 16.2 the default, introduces ParadeDB and DuckDB support, and brings epic-level OLAP improvements.
- [Pigsty v2.5: Ubuntu & PG16](/blog/pigsty/v2.5/): Pigsty v2.5 adds Ubuntu/Debian support (bullseye, bookworm, jammy, focal), new extensions including pointcloud and imgsmlr, and redesigned monitoring dashboards.
- [Pigsty v2.4: Monitor Cloud RDS](/blog/pigsty/v2.4/): Pigsty v2.4 delivers PostgreSQL 16 GA support, RDS/PolarDB monitoring, Redis Sentinel HA, and a wave of new extensions including Apache AGE, zhparser, and pg_embedding.
- [Pigsty v2.3: Richer App Ecosystem](/blog/pigsty/v2.3/): Pigsty v2.3 adds FerretDB MongoDB support, NocoDB integration, L2 VIP for node clusters, PostgreSQL security patches, and Redis 7.2.
- [Pigsty v2.2: Monitoring System Reborn](/blog/pigsty/v2.2/): Pigsty v2.2 delivers a complete monitoring dashboard overhaul built on Grafana 10, a 42-node production simulation sandbox, Pigsty's own RPM repos, and UOS compatibility.
- [Pigsty v2.1: Vector + Full PG Version Support!](/blog/pigsty/v2.1/): Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.
- [Pigsty v2.0: Open-Source RDS PostgreSQL Alternative](/blog/pigsty/v2.0/): Pigsty v2.0 delivers major improvements in security, compatibility, and feature integration — truly becoming a local open-source RDS alternative.
- [Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring](/blog/pigsty/v1.5/): Complete Docker support, infrastructure self-monitoring, ETCD as DCS, better cold backup support, and CMDB improvements.
- [Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support](/blog/pigsty/v1.4/): Pigsty v1.4 introduces a modular architecture with four independent modules, adds MatrixDB time-series data warehouse support, and delivers global CDN acceleration.
- [Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements](/blog/pigsty/v1.3/): Pigsty v1.3 adds Redis support with three deployment modes, rebuilds the PGCAT catalog explorer, and enhances PGSQL monitoring dashboards.
- [Pigsty v1.2: PG14 Default, Monitor Existing PG](/blog/pigsty/v1.2/): Pigsty v1.2 makes PostgreSQL 14 the default version and adds support for monitoring existing database instances independently.
- [Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger](/blog/pigsty/v1.1/): Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.
- [Pigsty v1.0: GA Release with Monitoring Overhaul](/blog/pigsty/v1.0/): Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.
- [Pigsty v0.9: CLI + Logs](/blog/pigsty/v0.9/): One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.
- [Pigsty v0.8: Service Provisioning](/blog/pigsty/v0.8/): Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.
- [Pigsty v0.7: Monitor-Only Deployments](/blog/pigsty/v0.7/): Monitor-only deployments unlock hybrid fleets, while DB/user provisioning APIs get a serious cleanup.
- [Pigsty v0.6: Provisioning Upgrades](/blog/pigsty/v0.6/): v0.6 reworks the provisioning flow, adds exporter toggles, and makes the monitoring stack portable across environments.
- [Pigsty v0.5: Declarative DB Templates](/blog/pigsty/v0.5/): Pigsty v0.5 introduces declarative database templates so roles, schemas, extensions, and ACLs can be described entirely in YAML.
- [Pigsty v0.4: PG13 and Better Docs](/blog/pigsty/v0.4/): Pigsty v0.4 ships PG13 support, a Grafana 7.3 refresh, and a cleaned-up docs site for the second public beta.
- [Pigsty v0.3: First Public Beta](/blog/pigsty/v0.3/): Pigsty v0.3.0, the first public beta, lands with eight battle-tested dashboards and an offline bundle.