# Pigsty v3.0.1

> Routine bug fixes, Patroni 4 support, Oracle compatibility improvements

---

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

---

**v3\.0\.1 · 2024-08-31**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.0.1)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.1.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.1.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

v3.0.1 [Released](https://pigsty.io/docs/about/release/) @ 2024-08-31

![kernels](https://github.com/user-attachments/assets/6b80fa25-fa84-487a-8bfc-fd498391b3d7)

## Features & Enhancement

- Oracle Compatibility through PolarDB-O (3rd commercial kernel)
- Rewrite monitoring views and SQL statements using Oracle-compatible SQL syntax
- Patroni [4](https://patroni.readthedocs.io/en/latest/releases.html) support and adaptation
- New extension `pg_analytics` enhances PostgreSQL with analytics capabilities via DuckDB
- Added new extensions: `odbc_fdw` and `jdbc_fdw`, providing universal external data source connectivity
- Added new kernel `cloudberrydb` (open-source fork by the original Greenplum developers)
- Add a restart after PGSQL primary initialization to apply `pg_param` & `pg_files`, no need to reboot after provisioning a Supabase PG / PolarDB cluster.
- Add new grafana plugin: `volkovlabs-rss-datasource`
- Add new dashboard panel: Extensions in PGCAT databases
- Bump Pev2 version to 1.12.1

## Bug Fix

- Fix Grafana 11.1.4 panel plugin failed to load by default
- Fix BlackBox Exporter Ping probe failed on certain OS Distro (run as root rather than prometheus)
- Make sure `/var/run/postgresql` and `/var/run/redis` temporary directory always auto-create after reboot
- Fix `cache.yml` playbook not correctly remove outdated Patroni 3.0.4 RPM package
- Correct description errors in some alerting rules
- Remove outdated Bootstrap User/HBA parameters from Patroni configuration file

```
MD5 (pigsty-v3.0.1.tgz) = 277a05f8dc944b9b5ef99b682b300b8d
MD5 (pigsty-pkg-v3.0.1.d12.x86_64.tgz) = 6ca11ea3d3531f2d208fd7dd3b251234
MD5 (pigsty-pkg-v3.0.1.el8.x86_64.tgz) = 12aa6f2eaac46c907e544677ade1d81f
MD5 (pigsty-pkg-v3.0.1.el9.x86_64.tgz) = f1cc152e688ff94f984fb45b1ae28968
MD5 (pigsty-pkg-v3.0.1.u22.x86_64.tgz) = bad1ab8a54df467c46e7d750d92a56c1
```

## Sources

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