# Pigsty v1.0.0

> v1 GA, Monitoring System Overhaul

---

LLMS index: [llms.txt](/llms.txt)

---

**v1\.0\.0 · 2021-07-26**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v1.0.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v1.0.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v1.0.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Monitoring System Overhaul

- New dashboards on Grafana 8.0
- New metric definitions, added PG14 support
- Simplified labeling system: static label set (job, cls, ins)
- New alerting rules and derived metrics
- Monitor multiple databases simultaneously
- Real-time log search & csvlog analysis
- Richly-linked dashboards, click through for drill-down/roll-up

## Architecture Changes

- Added Citus and TimescaleDB to default installation
- Added PostgreSQL 14beta2 support
- Simplified HAProxy admin page indexing
- Decoupled infrastructure and PGSQL by adding new role `register`
- Added new roles `loki` and `promtail` for logging
- Added new role `environ` to setup environment for admin user on meta node
- Default to `static` service discovery for Prometheus (instead of `consul`)
- Added new role `remove` for graceful cluster and instance removal
- Upgraded Prometheus and Grafana provisioning logic
- Upgraded to vip-manager 1.0, node_exporter 1.2, pg_exporter 0.4, Grafana 8.0
- Every database on every instance auto-registers as a Grafana datasource
- Moved Consul registration to `register` role, changed Consul service tags
- Added cmdb.sql as pg-meta baseline definition (CMDB & PGLOG)

## Application Framework

- Extensible framework for new features
- Core app: PostgreSQL monitoring system `pgsql`
- Core app: PostgreSQL catalog explorer `pgcat`
- Core app: PostgreSQL csvlog analyzer `pglog`
- Added sample app `covid` for COVID-19 data visualization
- Added sample app `isd` for ISD weather data visualization

## Other

- Added JupyterLab for full Python data science environment
- Added `vonng-echarts-panel` to restore ECharts support
- Added wrapper scripts `createpg`, `createdb`, `createuser`
- Added CMDB dynamic inventory scripts: `load_conf.py`, `inventory_cmdb`, `inventory_conf`
- Removed obsolete playbooks: `pgsql-monitor`, `pgsql-service`, `node-remove`, etc.

## API Changes

- New variable: `node_meta_pip_install`
- New variable: `grafana_admin_username`
- New variable: `grafana_database`
- New variable: `grafana_pgurl`
- New variable: `pg_shared_libraries`
- New variable: `pg_exporter_auto_discovery`
- New variable: `pg_exporter_exclude_database`
- New variable: `pg_exporter_include_database`
- Variable renamed: `grafana_url` → `grafana_endpoint`

## Bug Fixes

- Fixed default timezone Asia/Shanghai (CST) issue
- Fixed nofile limits for pgbouncer & patroni
- pgbouncer user list and database list now generated when running tag `pgbouncer`

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v1.0.0)
- [Pigsty v1.0 release article](https://pigsty.io/blog/pigsty/v1.0/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v100)
- [Source comparison: `v0.9.1...v1.0.0`](https://github.com/pgsty/pigsty/compare/v0.9.1...v1.0.0)