Tags: Pigsty
The Agent Moat: Runtime
A mediocre local who knows the terrain beats a genius parachuted into unknown territory. Intelligence without context is idle. An agent without a runtime is vapor.
From AGPL to Apache: Why I Changed Pigsty's License
Pigsty switched from AGPLv3 to Apache 2.0. Aren’t you worried about freeloaders? Freeloaders welcome — if you want to become the Debian of databases, a permissive license is table stakes.
Pigsty v4.0: Victoria Stack + Security Hardening
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
PostgreSQL 18 becomes the default version, EL10 and Debian 13 support added, extensions reach 437, and Pigsty wins the PostgreSQL Magneto Award.
Forging a China-Rooted, Global PostgreSQL Distro
PostgreSQL already won. The real battle is the distro layer. Will Chinese developers watch from the sideline or craft a PG “Ubuntu” for the world?
Pigsty v3.6: The Ultimate PostgreSQL Distribution
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
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
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
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
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
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
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
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
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
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
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
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
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!
Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.
Pigsty v2.0: Open-Source RDS PostgreSQL Alternative
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
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
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
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
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
Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.
Pigsty v1.0: GA Release with Monitoring Overhaul
Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.
Pigsty v0.9: CLI + Logs
One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.
Ready-to-Use PostgreSQL Distribution: Pigsty
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty
Pigsty v0.8: Service Provisioning
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
Monitor-only deployments unlock hybrid fleets, while DB/user provisioning APIs get a serious cleanup.
Pigsty v0.6: Provisioning Upgrades
v0.6 reworks the provisioning flow, adds exporter toggles, and makes the monitoring stack portable across environments.
Pigsty v0.5: Declarative DB Templates
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
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
Pigsty v0.3.0, the first public beta, lands with eight battle-tested dashboards and an offline bundle.