# Pigsty v2.6.0

> PG16 as default, ParadeDB & DuckDB extensions introduced

---

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

---

**v2\.6\.0 · 2024-02-29**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.6.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.6.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.6.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Highlights

* PostgreSQL 16 is now the default major version (16.2)
* New [ParadeDB](https://www.paradedb.com/) extensions: `pg_analytics`, `pg_bm25`, and `pg_sparse`
* New [DuckDB](https://duckdb.org/) and `duckdb_fdw` support
* Global Cloudflare CDN https://repo.pigsty.io and China CDN https://repo.pigsty.cc

## Configuration Changes

- Replaced `node_repo_method` with `node_repo_modules`, removed `node_repo_local_urls`
- Temporarily disabled Grafana unified alerting to avoid "Database Locked" errors
- New `node_repo_modules` parameter to specify upstream repos added to nodes
- Removed `node_local_repo_urls`, functionality replaced by `node_repo_modules` & `repo_upstream`
- Removed `node_repo_method` parameter, functionality replaced by `node_repo_modules`
- Added new `local` source in `repo_upstream`, used via `node_repo_modules` to replace `node_local_repo_urls`
- Reorganized `node_default_packages`, `infra_packages`, `pg_packages`, `pg_extensions` defaults
- When replacing `repo_upstream.baseurl`, if EL8/9 PGDG minor-version-specific repos are available, use `major.minor` instead of `major` for $releasever for better minor version compatibility

## Software Upgrades

- Grafana 10.3
- Prometheus 2.47
- node_exporter 1.7.0
- HAProxy 2.9.5
- Loki / Promtail 2.9.4
- minio-20240216110548 / mcli-20240217011557
- etcd 3.5.11
- Redis 7.2.4
- Bytebase 2.13.2
- DuckDB 0.10.0
- FerretDB 1.19
- Metabase: new Docker app template

## PostgreSQL Extensions

- PostgreSQL minor version upgrades: 16.2, 15.6, 14.11, 13.14, 12.18
- PostgreSQL 16: now promoted to default major version
- pg_exporter 0.6.1: security fix
- Patroni 3.2.2
- pgBadger 12.4
- pgBackRest 2.50
- vip-manager 2.3.0
- PostGIS 3.4.2
- TimescaleDB 2.14.1
- Vector extension PGVector 0.6.0: added parallel HNSW index creation
- New extension [duckdb_fdw](https://github.com/alitrack/duckdb_fdw) v1.1 for reading/writing DuckDB data
- New extension [pgsql-gzip](https://github.com/pramsey/pgsql-gzip) for Gzip compression/decompression v1.0.0
- New extension [pg_sparse](https://github.com/paradedb/paradedb/tree/dev/pg_sparse) for efficient sparse vectors (ParadeDB) v0.5.6
- New extension [pg_bm25](https://github.com/paradedb/paradedb/tree/dev/pg_bm25) for high-quality BM25 full-text search (ParadeDB) v0.5.6
- New extension [pg_analytics](https://github.com/paradedb/paradedb/tree/dev/pg_analytics) with SIMD + columnar storage for analytics (ParadeDB) v0.5.6
- Upgraded AIML extension [pgml](https://github.com/postgresml/postgresml) to v2.8.1 with PG 16 support
- Upgraded columnar extension [hydra](https://github.com/hydradatabase/) to v1.1.1 with PG 16 support
- Upgraded graph extension [age](https://github.com/apache/age) to v1.5.0 with PG 16 support
- Upgraded GraphQL extension [pg_graphql](https://github.com/supabase/pg_graphql) to v1.5.0 for Supabase support

```bash
MD5 (pigsty-v2.6.0.tgz) = 330e9bc16a2f65d57264965bf98174ff
MD5 (pigsty-pkg-v2.6.0.debian11.x86_64.tgz) = 81abcd0ced798e1198740ab13317c29a
MD5 (pigsty-pkg-v2.6.0.debian12.x86_64.tgz) = 7304f4458c9abd3a14245eaf72f4eeb4
MD5 (pigsty-pkg-v2.6.0.el7.x86_64.tgz) = f914fbb12f90dffc4e29f183753736bb
MD5 (pigsty-pkg-v2.6.0.el8.x86_64.tgz) = fc23d122d0743d1c1cb871ca686449c0
MD5 (pigsty-pkg-v2.6.0.el9.x86_64.tgz) = 9d258dbcecefd232f3a18bcce512b75e
MD5 (pigsty-pkg-v2.6.0.ubuntu20.x86_64.tgz) = 901ee668621682f99799de8932fb716c
MD5 (pigsty-pkg-v2.6.0.ubuntu22.x86_64.tgz) = 39872cf774c1fe22697c428be2fc2c22
```

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v2.6.0)
- [Pigsty v2.6 release article](https://pigsty.io/blog/pigsty/v2.6/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v260)
- [Source comparison: `v2.5.1...v2.6.0`](https://github.com/pgsty/pigsty/compare/v2.5.1...v2.6.0)