# Pigsty v3.0.0

> 333 extensions, pluggable kernels, MSSQL/Oracle/PolarDB compatibility

---

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

---

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

## Highlights

* PostgreSQL 16.4, 15.8, 14.13, 13.16, 12.20
* 340 PostgreSQL extensions available
* EL/Debian extension ecosystem parity achieved
* Pluggable kernels: Babelfish, IvorySQL, PolarDB support
* Supabase now available on Debian systems
* Pigsty Pro edition with extended OS and module support

## Breaking Changes

* Primary OS support: EL8/EL9, Debian 12, Ubuntu 22.04
* Legacy systems (EL7, Debian 11, Ubuntu 20.04) require subscription
* Default online installation; offline packages discontinued
* Repository consolidation with GPG signing

## API Changes

* New `pg_mode` options: `pgsql`, `citus`, `gpsql`, `mssql`, `ivory`, `polar`
* New parameters: `pg_parameters`, `pg_files`, `repo_extra_packages`
* `patroni_citus_db` renamed to `pg_primary_db`
* Enhanced: `proxy_env`, `repo_url_packages`, `pg_databases.extensions`
* Auto-derived defaults for `repo_upstream`, `repo_packages`, `infra_packages`, `node_default_packages`
* Bootstrap `-k|--keep` flag; Configure `-m|--conf` and `-x|--proxy` flags

## Bug Fixes

* OpenSSH CVE-2024-6387 auto-remediation
* Loki high-cardinality label memory fix
* EL8 Ansible dependency bootstrap fix

```bash
MD5 (pigsty-v3.0.0.tgz) = acc802fc2a47a838f09a39e7615ee4d9
```

## Sources

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