# Pigsty v2.2.0

> Dashboard & provisioning overhaul, UOS compatibility

---

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

---

**v2\.2\.0 · 2023-08-04**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.2.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.2.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.2.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Highlights

* Monitoring Dashboard Overhaul: https://demo.pigsty.cc
* Vagrant Sandbox Redesign: libvirt support with new config templates
* Pigsty EL Yum Repos: Consolidated scattered RPMs, simplified installation/build process
* OS Compatibility: Added UOS-v20-1050e support
* New Config Template: 42-node production simulation configuration
* Unified official PGDG Citus packages (el7)

## Software Upgrades

* PostgreSQL 16 beta2
* Citus 12 / PostGIS 3.3.3 / TimescaleDB 2.11.1 / PGVector 0.44
* Patroni 3.0.4 / pgBackRest 2.47 / pgBouncer 1.20
* Grafana 10.0.3 / Loki/Promtail/logcli 2.8.3
* etcd 3.5.9 / HAProxy v2.8.1 / Redis v7.0.12
* MinIO 20230711212934 / mcli 20230711233044

## Bug Fixes

* Fixed Docker group permission issue [29434bd](https://github.com/pgsty/pigsty/commit/29434bdd39548d95d80a236de9099874ed564f9b)
* Made `infra` OS user group supplementary rather than primary
* Fixed Redis Sentinel systemd service auto-enable state [5c96feb](https://github.com/pgsty/pigsty/commit/5c96feb598ad6e44daa7a595e34c87e67952777b)
* Relaxed `bootstrap` & `configure` checks, especially when `/etc/redhat-release` doesn't exist
* Upgraded to Grafana 10, fixing Grafana 9.x [CVE-2023-1410](https://grafana.com/blog/2023/03/22/grafana-security-release-new-versions-with-security-fixes-for-cve-2023-1410/)
* Added PG 14-16 command tags and error codes to CMDB `pglog` schema

## API Changes

New variable:

- `INFRA`.`NGINX`.`nginx_exporter_enabled`: Users can now disable nginx_exporter by setting this parameter

Default value changes:

- `repo_modules`: `node,pgsql,infra` : Redis now provided by pigsty-el repo, no longer needs `redis` module
- `repo_upstream`:
    - Added `pigsty-el`: EL version-independent RPMs: grafana, minio, pg_exporter, etc.
    - Added `pigsty-misc`: EL version-specific RPMs: redis, prometheus stack, etc.
    - Removed `citus`: PGDG now has complete EL7-EL9 Citus 12 support
    - Removed `remi`: Redis now provided by pigsty-el repo
- `repo_packages`: Consolidated package lists (see source for details)
- `repo_url_packages`:
    - https://get.pigsty.cc/rpm/pev.html
    - https://get.pigsty.cc/rpm/chart.tgz
- `node_default_packages`: Updated package list
- `infra_packages`: Updated package list
- `PGSERVICE` in `.pigsty` replaced with `PGDATABASE=postgres`, allowing users to access specific instances from admin node using just IP address

Directory structure changes:

- `bin/dns` and `bin/ssh` moved to `vagrant/` directory

```bash
MD5 (pigsty-pkg-v2.2.0.el7.x86_64.tgz) = 5fb6a449a234e36c0d895a35c76add3c
MD5 (pigsty-pkg-v2.2.0.el8.x86_64.tgz) = c7211730998d3b32671234e91f529fd0
MD5 (pigsty-pkg-v2.2.0.el9.x86_64.tgz) = 385432fe86ee0f8cbccbbc9454472fdd
```

## Sources

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