# Pigsty v1.3.1

> Dashboard polish, security fixes, and software upgrades

---

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

---

**v1\.3\.1 · 2021-12-10**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v1.3.1)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v1.3.1.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v1.3.1.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Monitoring

- PGSQL & PGCAT dashboard improvements
- Optimized PGCAT Instance & PGCAT Database layout
- Added key metric panels to PGSQL Instance dashboard (consistent with PGSQL Cluster)
- Added table/index bloat panels to PGCAT Database, removed PGCAT Bloat dashboard
- Added index information to PGCAT Database dashboard
- Fixed broken panels in Grafana 8.3
- Added Redis index to Nginx homepage

## Deployment

- New `infra-demo.yml` playbook for one-click bootstrap
- New `infra-jupyter.yml` playbook for optional JupyterLab server
- New `infra-pgweb.yml` playbook for optional PGWeb server
- Added `pg` alias on meta node for starting PostgreSQL cluster from admin user
- Adjusted `max_locks_per_transactions` in all Patroni config templates per `timescaledb-tune` recommendations
- Added `citus.node_conninfo: 'sslmode=prefer'` to config templates for SSL-free Citus usage
- Added all extensions (except pgrouting) from PGDG14 to package list
- Upgraded node_exporter to v1.3.1
- Added PostgREST v9.0.0 for generating REST APIs from PostgreSQL schemas

## Bug Fixes

- Grafana security vulnerability fix (upgraded to v8.3.1, [details](https://grafana.com/blog/2021/12/07/grafana-8.3.1-8.2.7-8.1.8-and-8.0.7-released-with-high-severity-security-fix/))
- Fixed `pg_instance` & `pg_service` issues in `register` role when starting playbook mid-run
- Fixed Nginx homepage rendering on hosts without `pg_cluster` variable
- Fixed style issues when upgrading to Grafana 8.3.1

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v1.3.1)
- [Pigsty v1.3 release article](https://pigsty.io/blog/pigsty/v1.3/)
- [Source comparison: `v1.3.0...v1.3.1`](https://github.com/pgsty/pigsty/compare/v1.3.0...v1.3.1)