Pigsty v0.3: First Public Beta

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 PostgreSQL lab without touching the public Internet.

Observability Stack
#

The open build ships eight curated Grafana dashboards: PG Overview, Cluster, Service, Instance, Database, Table Overview, Table Catalog, and a bare-metal Node view. Even with a trimmed set the coverage still crushes most “enterprise” monitoring stories.

Offline Bundle
#

Shipyard environments can fetch the CentOS 7.8 offline bundle directly from GitHub (pkg.tgz). Drop it on the management node and you have a deterministic install no matter how broken the mirrors are.

Pigsty - This article is part of a series.

Part : Pigsty v4.0: Victoria Stack + Security Hardening

Part : Pigsty v3.7: PostgreSQL Magneto Award, PG18 Deep Support

Part : Pigsty v3.6: The Ultimate PostgreSQL Distribution

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

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

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

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

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

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

Part : Pigsty v2.7: The Extension Superpack

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

Part : Pigsty v2.5: Ubuntu & PG16

Part : Pigsty v2.4: Monitor Cloud RDS

Part : Pigsty v2.3: Richer App Ecosystem

Part : Pigsty v2.2: Monitoring System Reborn

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

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

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

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

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

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

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

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

Part : Pigsty v0.9: CLI + Logs

Part : Pigsty v0.8: Service Provisioning

Part : Pigsty v0.7: Monitor-Only Deployments

Part : Pigsty v0.6: Provisioning Upgrades

Part : Pigsty v0.5: Declarative DB Templates

Part : Pigsty v0.4: PG13 and Better Docs

Part : This Article

Paradise Found: Wusun Ancient Trail

2020-10-11·5391 words·26 mins

This National Day I trekked the Wusun Ancient Trail, crossing over the Tianshan Mountains to reach that Ili. Though over a week has passed, the memories linger - writing to commemorate this journey.

Database Cluster Management Concepts and Entity Naming Conventions

2020-06-03·1509 words·8 mins

PostgreSQL PG-Admin Architecture

Concepts and their naming are very important. Naming style reflects an engineer’s understanding of system architecture. Poorly defined concepts lead to communication confusion, while carelessly set names create unexpected additional burden. Therefore, they need careful design.

PostgreSQL's KPI

2020-05-29·3053 words·15 mins

PostgreSQL PG-Admin Monitoring Metrics

Managing databases is similar to managing people - both need KPIs (Key Performance Indicators). So what are database KPIs? This article introduces a way to measure PostgreSQL load: using a single horizontally comparable metric that is basically independent of workload type and machine type, called PG Load.

Practical Cryptography Made Simple

2020-03-12·1360 words·3 mins

A classic problem in cryptography is how to transmit data securely and reliably through insecure channels. Protecting your chats and communications from surveillance and monitoring - easily achievable with just a computer.

Online PostgreSQL Column Type Migration

2020-01-30·790 words·4 mins

PostgreSQL PG-Admin Migration

How to modify PostgreSQL column types online? A general approach

Observability Stack#

Offline Bundle#

Related

Observability Stack
#

Offline Bundle
#