# Pigsty v2.0.1

> v2 bug fixes, security enhancements, Grafana upgrade

---

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

---

**v2\.0\.1 · 2023-03-21**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.0.1)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.0.1.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.0.1.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

Security improvements and bug fixes for v2.0.0.

## Improvements

- New pig logo to comply with PostgreSQL trademark policy
- Grafana upgraded to v9.4 with better UI and bug fixes
- Patroni upgraded to v3.0.1 with bug fixes
- Grafana systemd service file reverted to rpm default
- Use slower `copy` instead of `rsync` for Grafana dashboard sync, more reliable
- Bootstrap now restores default repo files after execution
- Added asciinema videos for various admin tasks
- Security enhancement mode: restricted monitoring user permissions
- New config template: `dual.yml` for two-node deployment
- Enable `log_connections` and `log_disconnections` in `crit.yml` template
- Enable `$lib/passwordcheck` in `pg_libs` in `crit.yml` template
- Explicitly grant `pg_monitor` role monitoring view permissions
- Remove default `dbrole_readonly` from `dbuser_monitor` to restrict monitoring user permissions
- Patroni now listens on `{{ inventory_hostname }}` instead of `0.0.0.0`
- `pg_listen` now controls postgres/pgbouncer listen address
- `${ip}`, `${lo}`, `${vip}` placeholders now available in `pg_listen`
- Aliyun terraform image upgraded from centos 7.9 to Rocky Linux 9
- Bytebase upgraded to v1.14.0

## Bug Fixes

* Added missing advertise address for alertmanager
* Fixed missing `pg_mode` variable when creating database users with `bin/pgsql-user`
* Added `-a password` option for Redis cluster join task in `redis.yml`
* Added missing default value in `infra-rm.yml`.`remove infra data` task
* Fixed prometheus monitoring target definition file owner to `prometheus` user
* Use admin user instead of root to delete DCS metadata
* Fixed issue caused by Grafana 9.4 bug: missing Meta datasource

## Sources

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