Skip to content

Pigsty v2.6.0

PG16 as default, ParadeDB & DuckDB extensions introduced
PG16 as default, ParadeDB & DuckDB extensions introduced

v2.6.0 ·

Highlights

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 v1.1 for reading/writing DuckDB data
  • New extension pgsql-gzip for Gzip compression/decompression v1.0.0
  • New extension pg_sparse for efficient sparse vectors (ParadeDB) v0.5.6
  • New extension pg_bm25 for high-quality BM25 full-text search (ParadeDB) v0.5.6
  • New extension pg_analytics with SIMD + columnar storage for analytics (ParadeDB) v0.5.6
  • Upgraded AIML extension pgml to v2.8.1 with PG 16 support
  • Upgraded columnar extension hydra to v1.1.1 with PG 16 support
  • Upgraded graph extension age to v1.5.0 with PG 16 support
  • Upgraded GraphQL extension pg_graphql to v1.5.0 for Supabase support
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