Posts in 2021

  • v0.9.0 Release Note

    2021-05-05 in Releases

    Pigsty v0.9.0 Features One-Line Installation Run this on meta node /bin/bash -c "$(curl -fsSL https://pigsty.cc/install)" MetaDB provisioning Now you can use pgsql database on meta node as inventory instead of static yaml file affter …

    Read more

  • v0.8.0 Release Note

    2021-03-16 in Releases

    Pigsty v0.8.0 Pigsty now is in RC status with guaranteed API stability. New Features Service provision. full locale support. API Changes Role vip and haproxy are merged into service. …

    Read more

  • v0.7.0 Release Note

    2021-03-01 in Releases

    Overview Monitor Only Deployment Now you can monitoring existing postgres clusters without Pigsty provisioning solution. Intergration with other provisioning solution is available and under further test. Database/User Management Update …

    Read more

  • v0.6.0 Release Note

    2021-02-19 in Releases

    Bug Fix pg_hba reset on patroni restart (patroni 2.0) #5 Merge Fix name of dashboard #1, Fix PG Overview Dashboard typo Fix default primary instance to pg-test-1 of cluster pg-test in sandbox environment Fix obsolete comments Enhancement …

    Read more

Posts in 2020

  • v0.5.0 Release Note

    2020-12-20 in Releases

    Pigsty now have an Official Site 🎉 ! New Features Add Database Provision Template Add Init Template Add Business Init Template Refactor HBA Rules variables Fix dashboards bugs. Move pg-cluster-replication to default dashboards Use ZJU PostgreSQL …

    Read more

  • v0.4.0 Release Note

    2020-12-14 in Releases

    The second public beta (v0.4.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 10 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Query PG Table PG Table Catalog PG …

    Read more

  • v0.3.0 Release Note

    2020-10-24 in Releases

    The first public beta (v0.3.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 8 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Table Overview PG Table Catalog Node …

    Read more

Posts in 2019

  • Database in Docker

    2019-01-13 in Post

    Thou shalt not run a prod database inside a container For stateless application services, the container is a perfect development and operation solution. However, for a service with a persistent state - the database, things are not that simple. As a …

    Read more

Posts in 2018

  • Postgres Development Convention

    2018-06-20 in Post

    This is a PostgreSQL convention I wrote for previous company. Could be a useful reference when dealing with database. For now it’s just an index. detailed information will be traslated when got time. 0x00 Background Nothing can be accomplished …

    Read more