Skip to content

Pigsty v3.1.0

PG17 default, config simplification, Ubuntu24 & ARM support
PG17 default, config simplification, Ubuntu24 & ARM support

v3.1.0 ·

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
  • 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