# Pigsty v3.1.0

> PG17 default, config simplification, Ubuntu24 & ARM support

---

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

---

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

## Highlights

- PostgreSQL 17 is now the default major version (17.2)
- Ubuntu 24.04 system support
- ARM architecture support: EL9, Debian12, Ubuntu 22.04
- One-click Supabase self-hosting, new `supabase.yml` playbook
- MinIO best practice improvements, config templates and Vagrant templates
- Series of ready-to-use config templates with documentation
- Allow specifying PG major version with `-v|--version` during `configure`
- Adjusted default extension policy: `pg_repack`, `wal2json`, and `pgvector` installed by default
- Greatly simplified `repo_packages` local repo build logic, allowing package group aliases in `repo_packages`
- Provided WiltonDB, IvorySQL, PolarDB repo mirrors, simplifying installation
- Database checksums enabled by default
- Fixed ETCD and MINIO log panels

## Software Upgrades

- PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, 12.22
- PostgreSQL extension versions: see https://pgext.cloud/en
- Patroni 4.0.4
- MinIO 20241107 / MCLI 20241117
- Rclone 1.68.2
- Prometheus: 2.54.0 -> 3.0.0
- VictoriaMetrics 1.102.1 -> 1.106.1
- VictoriaLogs v0.28.0 -> 1.0.0
- vslogcli 1.0.0
- MySQL Exporter 0.15.1 -> 0.16.0
- Redis Exporter 1.62.0 -> 1.66.0
- MongoDB Exporter 0.41.2 -> 0.42.0
- Keepalived Exporter 1.3.3 -> 1.4.0
- DuckDB 1.1.2 -> 1.1.3
- etcd 3.5.16 -> 3.5.17
- tigerbeetle 16.8 -> 0.16.13

## API Changes

- `repo_upstream`: Generates defaults for each specific OS distribution: [`roles/node_id/vars`](https://github.com/pgsty/pigsty/tree/main/roles/node_id/vars)
- `repo_packages`: Allows aliases defined in `package_map`
- `repo_extra_packages`: New default when unspecified, allows aliases defined in `package_map`
- `pg_checksum`: Default changed to `true`, enabled by default
- `pg_packages`: Default changed to: `postgresql, wal2json pg_repack pgvector, patroni pgbouncer pgbackrest pg_exporter pgbadger vip-manager`
- `pg_extensions`: Default changed to empty array `[]`
- `infra_portal`: Allows specifying `path` for `home` server, replacing default local repo path `nginx_home` (`/www`)

## Sources

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