# Pigsty v3.7.0

> PG18 default, 437 extensions, EL10 & Debian 13 support, PGEXT.CLOUD

---

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

---

**v3\.7\.0 · 2025-12-02**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.7.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.7.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.7.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Highlights

- **PostgreSQL 18 Deep Support:** Now the default major PG version, with full extension readiness!
- **Expanded OS Support:** Added EL10 and Debian 13, bringing the total supported operating systems to 14.
- **Extension Growth:** The PostgreSQL extension library now includes 437 entries.
- **Ansible 2.19 Compatibility:** Full support for Ansible 2.19 following its breaking changes.
- **Kernel Updates:** Latest versions for Supabase, PolarDB, IvorySQL, and Percona kernels.
- **Optimized Tuning:** Refined logic for default PG parameters to maximize resource utilization.
- [**PGEXT.CLOUD**](https://pigsty.io/ext/): Dedicated extension website open-sourced under Apache-2.0 license

## Version Updates

- PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, 13.23
- Patroni 4.1.0
- Pgbouncer 1.25.0
- pg_exporter 1.0.3
- pgbackrest 2.57.0
- Supabase 2025-11
- PolarDB 15.15.5.0
- FerretDB 2.7.0
- DuckDB 1.4.2
- Etcd 3.6.6
- pig 0.7.4

For detailed version changes, please refer to:

- [INFRA Changelog](https://pigsty.io/docs/repo/infra/)
- [RPM Changelog](https://pigsty.io/docs/repo/pgsql/rpm)
- [DEB Changelog](https://pigsty.io/docs/repo/pgsql/deb)

## API Changes

- Implemented a refined optimization strategy for parallel execution parameters. See **[Tuning Guide](/docs/pgsql/template/tune)**.
- The `citus` extension is no longer installed by default in `rich` and `full` templates (PG 18 support pending).
- Added `duckdb` extension stubs to PostgreSQL parameter templates.
- Capped `min_wal_size`, `max_wal_size`, and `max_slot_wal_keep_size` at 200 GB, 2000 GB, and 3000 GB, respectively.
- Capped `temp_file_limit` at 200 GB (2 TB for OLAP workloads).
- Increased the default connection count for the connection pool.
- Added `prometheus_port` (default: `9058`) to avoid conflicts with the EL10 RHEL Web Console port.
- Changed `alertmanager_port` default to `9059` to avoid potential conflicts with Kafka SSL ports.
- Added a `pg_pre` subtask to `pg_pkg`: removes conflicting LLVM packages (`bpftool`, `python3-perf`) on EL9+ prior to PG installation.
- Added the `llvm` module to the default repository definition for Debian/Ubuntu.
- Fixed package removal logic in `infra-rm.yml`.

## Compatibility Fixes

- **Ubuntu/Debian CA Trust:** Fixed incorrect warning return codes when trusting Certificate Authorities.
- **Ansible 2.19 Support:** Resolved numerous compatibility issues introduced by Ansible 2.19 to ensure stability across versions:
  - Added explicit `int` type casting for sequence variables.
  - Migrated `with_items` syntax to `loop`.
  - Nested key exchange variables in lists to prevent character iteration on strings in newer versions.
  - Explicitly cast `range` usage to `list`.
  - Renamed reserved variables such as `name` and `port`.
  - Replaced `play_hosts` with `ansible_play_hosts`.
  - Added string casting for specific variables to prevent runtime errors.
- **EL10 Adaptation:**
  - Fixed missing `ansible-collection-community-crypto` preventing key generation.
  - Fixed missing `ansible` logic packages.
  - Removed `modulemd_tools`, `flamegraph`, and `timescaledb-tool`.
  - Replaced `java-17-openjdk` with `java-21-openjdk`.
  - Resolved aarch64 YUM repository naming issues.
- **Debian 13 Adaptation:**
  - Replaced `dnsutils` with `bind9-dnsutils`.
- **Ubuntu 24 Fixes:**
  - Temporarily removed `tcpdump` due to upstream dependency crashes.

## Checksums

```bash
e00d0c2ac45e9eff1cc77927f9cd09df  pigsty-v3.7.0.tgz
987529769d85a3a01776caefefa93ecb  pigsty-pkg-v3.7.0.d12.aarch64.tgz
2d8272493784ae35abeac84568950623  pigsty-pkg-v3.7.0.d12.x86_64.tgz
090cc2531dcc25db3302f35cb3076dfa  pigsty-pkg-v3.7.0.d13.x86_64.tgz
ddc54a9c4a585da323c60736b8560f55  pigsty-pkg-v3.7.0.el10.aarch64.tgz
d376e75c490e8f326ea0f0fbb4a8fd9b  pigsty-pkg-v3.7.0.el10.x86_64.tgz
8c2deeba1e1d09ef3d46d77a99494e71  pigsty-pkg-v3.7.0.el8.aarch64.tgz
9795e059bd884b9d1b2208011abe43cd  pigsty-pkg-v3.7.0.el8.x86_64.tgz
08b860155d6764ae817ed25f2fcf9e5b  pigsty-pkg-v3.7.0.el9.aarch64.tgz
1ac430768e488a449d350ce245975baa  pigsty-pkg-v3.7.0.el9.x86_64.tgz
e033aaf23690755848db255904ab3bcd  pigsty-pkg-v3.7.0.u22.aarch64.tgz
cc022ea89181d89d271a9aaabca04165  pigsty-pkg-v3.7.0.u22.x86_64.tgz
0e978598796db3ce96caebd76c76e960  pigsty-pkg-v3.7.0.u24.aarch64.tgz
48223898ace8812cc4ea79cf3178476a  pigsty-pkg-v3.7.0.u24.x86_64.tgz
```

## Sources

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