Skip to content

Version v3.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

Series: Pigsty

  1. Pigsty v0.3: First Public Beta

    By vonng In Articles 112 words 1 min

    vonngPigstyPigsty

    Pigsty v0.3: First Public Beta

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.3.0 Pigsty v0.3.0 is the very first public preview. It packages a lean observability stack plus a reproducible offline bundle so you can spin up a real …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.3.0 Pigsty v0.3.0 is the very first public preview. It packages a lean observability stack plus a reproducible offline bundle so you can spin up a real …

  2. Pigsty v0.4: PG13 and Better Docs

    By vonng In Articles 171 words 1 min

    vonngPigstyPigsty

    Pigsty v0.4: PG13 and Better Docs

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.4.0 Pigsty v0.4 is our second public beta. The observability stack was rebuilt around Grafana 7.3, and ten curated dashboards became the default …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.4.0 Pigsty v0.4 is our second public beta. The observability stack was rebuilt around Grafana 7.3, and ten curated dashboards became the default …

  3. Pigsty v0.5: Declarative DB Templates

    By vonng In Articles 684 words 4 min

    vonngPigstyPigsty

    Pigsty v0.5: Declarative DB Templates

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.5.0 v0.5.0 Outline The official docs site (http://pigsty.cc/) is live. Database templating becomes fully declarative: define users, roles, databases, …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.5.0 v0.5.0 Outline The official docs site (http://pigsty.cc/) is live. Database templating becomes fully declarative: define users, roles, databases, …

  4. Pigsty v0.6: Provisioning Upgrades

    By vonng In Articles 206 words 1 min

    vonngPigstyPigsty

    Pigsty v0.6: Provisioning Upgrades

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.6.0 Pigsty v0.6 responds to user feedback with a redesigned provisioning path plus a monitoring stack that can sit beside any managed PG fleet—even a …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.6.0 Pigsty v0.6 responds to user feedback with a redesigned provisioning path plus a monitoring stack that can sit beside any managed PG fleet—even a …

  5. Pigsty v0.7: Monitor-Only Deployments

    By vonng In Articles 274 words 2 min

    vonngPigstyPigsty

    Pigsty v0.7: Monitor-Only Deployments

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.7.0 Pigsty v0.7 focuses on plugging existing fleets into Pigsty’s observability stack. The new monitor-only flow lets you drop Pigsty dashboards onto …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.7.0 Pigsty v0.7 focuses on plugging existing fleets into Pigsty’s observability stack. The new monitor-only flow lets you drop Pigsty dashboards onto …

  6. Pigsty v0.8: Service Provisioning

    By vonng In Articles 187 words 1 min

    vonngPigstyPigsty

    Pigsty v0.8: Service Provisioning

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.8.0 v0.8 finalizes the provisioning API. Services are completely rebuilt: instead of a hard-coded primary/replica pair you can now declare any number of …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.8.0 v0.8 finalizes the provisioning API. Services are completely rebuilt: instead of a hard-coded primary/replica pair you can now declare any number of …

  7. Pigsty v0.9: CLI + Logs

    By vonng In Articles 266 words 2 min

    vonngPigstyPigsty

    Pigsty v0.9: CLI + Logs

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.9.0 New Stuff One-liner install: curl -fsSL https://pigsty.cc/install | bash bootstraps everything. pigsty-cli: wraps the common Ansible playbooks so you …

    Originally published on VONNG. GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.9.0 New Stuff One-liner install: curl -fsSL https://pigsty.cc/install | bash bootstraps everything. pigsty-cli: wraps the common Ansible playbooks so you …

  8. Pigsty v1.0: GA Release with Monitoring Overhaul

    By vonng In Articles 1426 words 7 min

    vonngPigstyPigsty

    Pigsty v1.0: GA Release with Monitoring Overhaul

    Originally published on VONNG. GitHub Release | Release Note After over a year of iterations and refinement, Pigsty officially ships v1.0.0 GA. Pigsty (/ˈpɪɡˌstaɪ/) stands for PostgreSQL In Graphic STYle — PostgreSQL, visualized. What is Pigsty? …

    Originally published on VONNG. GitHub Release | Release Note After over a year of iterations and refinement, Pigsty officially ships v1.0.0 GA. Pigsty (/ˈpɪɡˌstaɪ/) stands for PostgreSQL In Graphic STYle — PostgreSQL, visualized. What is Pigsty? …

  9. Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger

    By vonng In Articles 960 words 5 min

    vonngPigstyPigsty

    Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.1 is officially released, featuring a brand-new homepage design, plus support for JupyterLab, PGWeb, PEV2, PgBadger, and other useful tools. Brand New Homepage The Home Dashboard …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.1 is officially released, featuring a brand-new homepage design, plus support for JupyterLab, PGWeb, PEV2, PgBadger, and other useful tools. Brand New Homepage The Home Dashboard …

  10. Pigsty v1.2: PG14 Default, Monitor Existing PG

    By vonng In Articles 731 words 4 min

    vonngPigstyPigsty

    Pigsty v1.2: PG14 Default, Monitor Existing PG

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.2 is officially released, making PostgreSQL 14 the default version and adding support for monitoring existing database instances independently. PostgreSQL 14 Becomes the Default …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.2 is officially released, making PostgreSQL 14 the default version and adding support for monitoring existing database instances independently. PostgreSQL 14 Becomes the Default …

  11. Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements

    By vonng In Articles 657 words 4 min

    vonngPigstyPigsty

    Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.3 is officially released, featuring Redis support, a rebuilt PGCAT application, and enhanced PGSQL monitoring. Redis Support While PostgreSQL is the world’s most advanced …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.3 is officially released, featuring Redis support, a rebuilt PGCAT application, and enhanced PGSQL monitoring. Redis Support While PostgreSQL is the world’s most advanced …

  12. Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support

    By vonng In Articles 2183 words 11 min

    vonngPigstyPigsty

    Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.4 is officially released! A brand new modular architecture: four built-in modules INFRA, NODES, PGSQL, REDIS can be used independently and freely combined; new MatrixDB …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.4 is officially released! A brand new modular architecture: four built-in modules INFRA, NODES, PGSQL, REDIS can be used independently and freely combined; new MatrixDB …

  13. Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring

    By vonng In Articles 2243 words 11 min

    vonngPigstyPigsty

    Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.5 is officially released! Complete Docker support brings a rich application ecosystem — countless database-backed software works out of the box! Other improvements include: …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v1.5 is officially released! Complete Docker support brings a rich application ecosystem — countless database-backed software works out of the box! Other improvements include: …

  14. Pigsty v2.0: Open-Source RDS PostgreSQL Alternative

    By vonng In Articles 3408 words 16 min

    vonngPigstyPigsty

    Pigsty v2.0: Open-Source RDS PostgreSQL Alternative

    Originally published on VONNG. GitHub Release | Release Note 2023/02/28, Pigsty v2.0.0 is officially released, bringing a series of major feature updates. PIGSTY now stands for “PostgreSQL In Great STYle” — PostgreSQL at its best. Pigsty’s …

    Originally published on VONNG. GitHub Release | Release Note 2023/02/28, Pigsty v2.0.0 is officially released, bringing a series of major feature updates. PIGSTY now stands for “PostgreSQL In Great STYle” — PostgreSQL at its best. Pigsty’s …

  15. Pigsty v2.1: Vector + Full PG Version Support!

    By vonng In Articles 1228 words 6 min

    vonngPigstyPigsty

    Pigsty v2.1: Vector + Full PG Version Support!

    Originally published on VONNG. GitHub Release | Release Note Following PostgreSQL’s summer minor version updates and the release of PG 16 Beta, Pigsty closely tracks the PG community with the v2.1 release. This update supports PostgreSQL 16 Beta1 …

    Originally published on VONNG. GitHub Release | Release Note Following PostgreSQL’s summer minor version updates and the release of PG 16 Beta, Pigsty closely tracks the PG community with the v2.1 release. This update supports PostgreSQL 16 Beta1 …

  16. Pigsty v2.2: Monitoring System Reborn

    By vonng In Articles 1771 words 9 min

    vonngPigstyPigsty

    Pigsty v2.2: Monitoring System Reborn

    Originally published on VONNG. GitHub Release | Release Note Pigsty v2.2 is here! The world’s most powerful PostgreSQL monitoring system receives an epic upgrade — completely rebuilt on Grafana v10, pushing PG observability to a whole new level with …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v2.2 is here! The world’s most powerful PostgreSQL monitoring system receives an epic upgrade — completely rebuilt on Grafana v10, pushing PG observability to a whole new level with …

  17. Pigsty v2.3: Richer App Ecosystem

    By vonng In Articles 1511 words 8 min

    vonngPigstyPigsty

    Pigsty v2.3: Richer App Ecosystem

    Originally published on VONNG. GitHub Release | Release Note Pigsty v2.3 is here! This release further refines the monitoring system, enriches the application ecosystem, and keeps pace with PostgreSQL’s routine minor version updates (CVE fixes). …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v2.3 is here! This release further refines the monitoring system, enriches the application ecosystem, and keeps pace with PostgreSQL’s routine minor version updates (CVE fixes). …

  18. Pigsty v2.4: Monitor Cloud RDS

    By vonng In Articles 926 words 5 min

    vonngPigstyPigsty

    Pigsty v2.4: Monitor Cloud RDS

    Originally published on VONNG. GitHub Release | Release Note PostgreSQL released its new major version 16 today, bringing a series of improvements. Pigsty followed up within 1 hour of release with Pigsty v2.4, providing complete support for …

    Originally published on VONNG. GitHub Release | Release Note PostgreSQL released its new major version 16 today, bringing a series of improvements. Pigsty followed up within 1 hour of release with Pigsty v2.4, providing complete support for …

  19. Pigsty v2.5: Ubuntu & PG16

    By vonng In Articles 1825 words 9 min

    vonngPigstyPigsty

    Pigsty v2.5: Ubuntu & PG16

    Originally published on VONNG. GitHub Release | Release Note On Programmer’s Day (10/24), Pigsty v2.5.0 is released! This version adds support for Ubuntu and Debian operating systems. Combined with existing EL7/8/9 support, we’ve achieved a grand …

    Originally published on VONNG. GitHub Release | Release Note On Programmer’s Day (10/24), Pigsty v2.5.0 is released! This version adds support for Ubuntu and Debian operating systems. Combined with existing EL7/8/9 support, we’ve achieved a grand …

  20. Pigsty v2.6: PostgreSQL Crashes the OLAP Party

    By vonng In Articles 1761 words 9 min

    vonngPigstyPigsty

    Pigsty v2.6: PostgreSQL Crashes the OLAP Party

    Originally published on VONNG. GitHub Release | Release Note On the last day of February, Pigsty v2.6 is officially released! This version makes PostgreSQL 16 the default major version and introduces a series of new extensions, including ParadeDB …

    Originally published on VONNG. GitHub Release | Release Note On the last day of February, Pigsty v2.6 is officially released! This version makes PostgreSQL 16 the default major version and introduces a series of new extensions, including ParadeDB …

  21. Pigsty v2.7: The Extension Superpack

    By vonng In Articles 2174 words 11 min

    vonngPigstyPigsty

    Pigsty v2.7: The Extension Superpack

    Originally published on VONNG. GitHub Release | Release Note On 2024-05-20, Pigsty v2.7 is released. The number of available extensions in this version reaches an astonishing 255, successfully elevating PostgreSQL’s versatility to a new height! …

    Originally published on VONNG. GitHub Release | Release Note On 2024-05-20, Pigsty v2.7 is released. The number of available extensions in this version reaches an astonishing 255, successfully elevating PostgreSQL’s versatility to a new height! …

  22. Pigsty v3.0: Pluggable Kernels & 340 Extensions

    By vonng In Articles 1604 words 8 min

    vonngPigstyPigsty

    Pigsty v3.0: Pluggable Kernels & 340 Extensions

    Originally published on VONNG. GitHub Release | Release Note Highlights Extension Explosion: Pigsty v3 ships an unprecedented 340 available PostgreSQL extensions. This includes 121 extension RPM packages and 133 DEB packages — more than the total …

    Originally published on VONNG. GitHub Release | Release Note Highlights Extension Explosion: Pigsty v3 ships an unprecedented 340 available PostgreSQL extensions. This includes 121 extension RPM packages and 133 DEB packages — more than the total …

  23. Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24

    By vonng In Articles 2582 words 13 min

    vonngPigstyPigsty

    Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24

    Originally published on VONNG. GitHub Release | Release Note With PostgreSQL 17.2 released just days ago, Pigsty immediately follows up with v3.1. In this version, PostgreSQL 17 becomes the default major version, with nearly 340 extensions available …

    Originally published on VONNG. GitHub Release | Release Note With PostgreSQL 17.2 released just days ago, Pigsty immediately follows up with v3.1. In this version, PostgreSQL 17 becomes the default major version, with nearly 340 extensions available …

  24. Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements

    By vonng In Articles 1369 words 7 min

    vonngPigstyPigsty

    Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements

    Originally published on VONNG. GitHub Release | Release Note Pigsty wraps up 2024 with its final release: v3.2. This release brings the pig command-line tool and complete ARM extension support. Together, they deliver silky-smooth PostgreSQL delivery …

    Originally published on VONNG. GitHub Release | Release Note Pigsty wraps up 2024 with its final release: v3.2. This release brings the pig command-line tool and complete ARM extension support. Together, they deliver silky-smooth PostgreSQL delivery …

  25. Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website

    By vonng In Articles 1183 words 6 min

    vonngPigstyPigsty

    Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website

    Originally published on VONNG. GitHub Release | Release Note After two months of careful refinement, Pigsty v3.3 is officially released. As an open-source “batteries-included” PostgreSQL distribution, Pigsty aims to harness the collective power of …

    Originally published on VONNG. GitHub Release | Release Note After two months of careful refinement, Pigsty v3.3 is officially released. As an open-source “batteries-included” PostgreSQL distribution, Pigsty aims to harness the collective power of …

  26. Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates

    By vonng In Articles 1660 words 8 min

    vonngPigstyPigsty

    Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates

    Originally published on VONNG. GitHub Release | Release Note After a month of intensive development, Pigsty v3.4 is officially released. This version features significant architectural optimizations, addressing several core concerns highly valued by …

    Originally published on VONNG. GitHub Release | Release Note After a month of intensive development, Pigsty v3.4 is officially released. This version features significant architectural optimizations, addressing several core concerns highly valued by …

  27. Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions

    By vonng In Articles 1588 words 8 min

    vonngPigstyPigsty

    Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions

    Originally published on VONNG. GitHub Release | Release Note Pigsty v3.5 is officially released. The project has crossed the 4,000+ Star milestone on GitHub — a remarkable achievement for a database infrastructure project. This version brings a …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v3.5 is officially released. The project has crossed the 4,000+ Star milestone on GitHub — a remarkable achievement for a database infrastructure project. This version brings a …

  28. Pigsty v3.6: The Ultimate PostgreSQL Distribution

    By vonng In Articles 1959 words 10 min

    vonngPigstyPigsty

    Pigsty v3.6: The Ultimate PostgreSQL Distribution

    Originally published on VONNG. GitHub Release | Release Note Pigsty v3.6 is officially released. After two months of careful refinement, this will be the last major version before v4.0, featuring extensive refactoring and improvements that lay a …

    Originally published on VONNG. GitHub Release | Release Note Pigsty v3.6 is officially released. After two months of careful refinement, this will be the last major version before v4.0, featuring extensive refactoring and improvements that lay a …