# Pigsty v3.0.2

> Mini install mode, PolarDB 15 support, monitoring view updates

---

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

---

**v3\.0\.2 · 2024-09-07**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.0.2)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.2.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.2.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Features

- [Minimal Installation](https://pigsty.io/docs/setup/mini/) support with `pgsql-min.yml` (NODE, PGSQL, ETCD only)
- Official support for the latest [PolarDB for PostgreSQL](https://github.com/ApsaraDB/PolarDB-for-PostgreSQL) Kernel v15
- Optimize `monitor.pg_table_bloat` and `monitor.pg_index_bloat` with security definer wrap functions to avoid PolarDB statistics view permission issue.
- Honor `prometheus_enabled`, `grafana_enabled` option in target register, not register when disabled.
- Add `PGDATABASE` and `PGPORT` environment variable to `/etc/profile.d/pgsql.sh`, set to `pg_primary_db` (default `postgres`)

## Changes

- Remove PolarDB 11, CloudberryDB 1.5.4 packages from pgsql repo.
- New dedicate repo for PolarDB 15, CloudberryDB 1.6.0, MSSQL, IvorySQL.

## Bug Fix

- Fix redis `/etc/tmp.files.d` entry name
- Set `PGHOST` and `PGPORT` when managing pgbouncer users.
- Remove support for `pg_snakeoil` due to `clamv` deps break on EL8
- Remove role `pgsql` notify handler for ansible 2.9 compatibility

## Checksums

```
MD5 (pigsty-v3.0.2.tgz) = e366b754ec9b57f5e22c5feadd8f0901
```

## Sources

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