Pigsty Blog Articles

Posts in 2022
  • Cloud RDS: From Database Drop to Exit

    May 10, 2022 in Cloud

    Cloud RDS: From Database Drop to Exit

    I recently witnessed a live cloud database drop-and-run incident. This article discusses how to handle accidentally deleted data when using PostgreSQL in production environments.

    Read more

    I recently witnessed a live cloud database drop-and-run incident. This article discusses how to handle accidentally deleted data when using PostgreSQL in production environments.

    Read more

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

    May 05, 2022 in Pigsty

    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.

    Read more

    Complete Docker support, infrastructure self-monitoring, ETCD as DCS, better cold backup support, and CMDB improvements.

    Read more

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

    March 14, 2022 in Pigsty

    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.

    Read more

    Pigsty v1.4 introduces a modular architecture with four independent modules, adds MatrixDB time-series data warehouse support, and delivers global CDN acceleration.

    Read more

Posts in 2021
  • Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements

    November 10, 2021 in Pigsty

    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.

    Read more

    Pigsty v1.3 adds Redis support with three deployment modes, rebuilds the PGCAT catalog explorer, and enhances PGSQL monitoring dashboards.

    Read more

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

    October 22, 2021 in Pigsty

    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.

    Read more

    Pigsty v1.2 makes PostgreSQL 14 the default version and adds support for monitoring existing database instances independently.

    Read more

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

    September 17, 2021 in Pigsty

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

    Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.

    Read more

    Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.

    Read more

  • Time to Say Goodbye to GPL

    September 16, 2021 in Database

    Time to Say Goodbye to GPL

    DDIA author Martin Kleppmann argues we should move away from GPL licenses. In the 2020s, the enemy of computing freedom is cloud software.

    Read more

    DDIA author Martin Kleppmann argues we should move away from GPL licenses. In the 2020s, the enemy of computing freedom is cloud software.

    Read more

  • Pigsty v1.0: GA Release with Monitoring Overhaul

    July 26, 2021 in Pigsty

    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.

    Read more

    Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.

    Read more

  • Pigsty v0.9: CLI + Logs

    May 31, 2021 in Pigsty

    Pigsty v0.9: CLI + Logs

    One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.

    Read more

    One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.

    Read more

  • Ready-to-Use PostgreSQL Distribution: Pigsty

    May 24, 2021 in PostgreSQL

    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.

    Read more

    Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution: Pigsty.

    Read more