Pigsty Blog Articles
Pigsty v1.2: PG14 Default, Monitor Existing PG
October 22, 2021 in Pigsty

Pigsty v1.2 makes PostgreSQL 14 the default version and adds support for monitoring existing database instances independently.
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
September 17, 2021 in Pigsty

Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.
Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.
Time to Say Goodbye to GPL
September 16, 2021 in Database

DDIA author Martin Kleppmann argues we should move away from GPL licenses. In the 2020s, the enemy of computing freedom is cloud software.
DDIA author Martin Kleppmann argues we should move away from GPL licenses. In the 2020s, the enemy of computing freedom is cloud software.
Pigsty v1.0: GA Release with Monitoring Overhaul
July 26, 2021 in Pigsty

Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.
Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.
Pigsty v0.9: CLI + Logs
May 31, 2021 in Pigsty
One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.
Ready-to-Use PostgreSQL Distribution: Pigsty
May 24, 2021 in PostgreSQL

Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — 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
May 14, 2021 in Pigsty

Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.
Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.
Why Does PostgreSQL Have a Bright Future?
May 08, 2021 in PostgreSQL

Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?
Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?
Pigsty v0.7: Monitor-Only Deployments
April 26, 2021 in Pigsty

Monitor-only deployments unlock hybrid fleets, while DB/user provisioning APIs get a serious cleanup.
Monitor-only deployments unlock hybrid fleets, while DB/user provisioning APIs get a serious cleanup.
Pigsty v0.6: Provisioning Upgrades
April 19, 2021 in Pigsty

v0.6 reworks the provisioning flow, adds exporter toggles, and makes the monitoring stack portable across environments.
v0.6 reworks the provisioning flow, adds exporter toggles, and makes the monitoring stack portable across environments.
