Skip to content

Pigsty v3.0.0

333 extensions, pluggable kernels, MSSQL/Oracle/PolarDB compatibility
333 extensions, pluggable kernels, MSSQL/Oracle/PolarDB compatibility

v3.0.0 ·

Highlights

  • PostgreSQL 16.4, 15.8, 14.13, 13.16, 12.20
  • 340 PostgreSQL extensions available
  • EL/Debian extension ecosystem parity achieved
  • Pluggable kernels: Babelfish, IvorySQL, PolarDB support
  • Supabase now available on Debian systems
  • Pigsty Pro edition with extended OS and module support

Breaking Changes

  • Primary OS support: EL8/EL9, Debian 12, Ubuntu 22.04
  • Legacy systems (EL7, Debian 11, Ubuntu 20.04) require subscription
  • Default online installation; offline packages discontinued
  • Repository consolidation with GPG signing

API Changes

  • New pg_mode options: pgsql, citus, gpsql, mssql, ivory, polar
  • New parameters: pg_parameters, pg_files, repo_extra_packages
  • patroni_citus_db renamed to pg_primary_db
  • Enhanced: proxy_env, repo_url_packages, pg_databases.extensions
  • Auto-derived defaults for repo_upstream, repo_packages, infra_packages, node_default_packages
  • Bootstrap -k|--keep flag; Configure -m|--conf and -x|--proxy flags

Bug Fixes

  • OpenSSH CVE-2024-6387 auto-remediation
  • Loki high-cardinality label memory fix
  • EL8 Ansible dependency bootstrap fix
MD5 (pigsty-v3.0.0.tgz) = acc802fc2a47a838f09a39e7615ee4d9

Sources