# Pigsty v1.2.0

> Default PGSQL version upgraded to 14

---

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

---

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

## Core Features

- Default to PostgreSQL 14
- Default to TimescaleDB 2.5 extension
- TimescaleDB and PostGIS enabled by default in CMDB

## Monitor-Only Mode

- Monitor existing PostgreSQL instances via connection URL only
- pg_exporter deployed on local meta node
- New PGSQL Cluster Monly dashboard for remote clusters

## Software Upgrades

- Grafana upgraded to 8.2.2
- pev2 upgraded to v0.11.9
- Promscale upgraded to 0.6.2
- PgWeb upgraded to 0.11.9
- New extensions: pglogical, pg_stat_monitor, orafce

## Improvements

- Auto-detect machine specs and use appropriate `node_tune` and `pg_conf` templates
- Reworked bloat-related views, exposing more information
- Removed TimescaleDB and Citus internal monitoring
- Added `pgsql-audit.yml` playbook for creating audit reports
- All config templates simplified to two: auto and demo

## Bug Fixes

- pgbouncer_exporter resource owner changed to `{{ pg_dbsu }}` instead of postgres
- Fixed pg_exporter duplicate metrics on pg_table/pg_index during `REINDEX TABLE CONCURRENTLY`

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v1.2.0)
- [Pigsty v1.2 release article](https://pigsty.io/blog/pigsty/v1.2/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v120)
- [Source comparison: `v1.1.1...v1.2.0`](https://github.com/pgsty/pigsty/compare/v1.1.1...v1.2.0)