Releases
pigsty release history
Version | Time | Summary | Link |
---|---|---|---|
v3.5.0 | 2025-05-31 | PG18 beta, 421 ext, monitor refactor (WIP) | v3.5.0 |
v3.4.1 | 2025-04-05 | OpenHalo & OrioleDB, MySQL Compatibility pgAdmin 9.2 | v3.4.1 |
v3.4.0 | 2025-03-30 | Better Backups, Auto Certbot, Locale, Ivory, AGE, APP | v3.4.0 |
v3.3.0 | 2025-02-24 | 404 extension, App Playbook, DocumentDB, Extension Catalog | v3.3.0 |
v3.2.2 | 2025-01-23 | 390 extension, omnigres, mooncake, citus13 with pg17 | v3.2.2 |
v3.2.1 | 2025-01-12 | 351 extension, anon, ivorysql4, Odoo self-hosting | v3.2.1 |
v3.2.0 | 2024-12-25 | Pig CLI, Arm64 Full Extension, Supabase & Grafana Enhance | v3.2.0 |
v3.1.0 | 2024-11-24 | ARM64 & Ubuntu24, PG17 by Default, Better Supabase & MinIO | v3.1.0 |
v3.0.4 | 2024-10-28 | PostgreSQL 17 Extensions, Better self-hosting Supabase | v3.0.4 |
v3.0.3 | 2024-09-27 | PostgreSQL 17, Etcd Enhancement, IvorySQL 3.4,PostGIS 3.5 | v3.0.3 |
v3.0.2 | 2024-09-07 | Mini Install, PolarDB 15, Bloat View Update | v3.0.2 |
v3.0.1 | 2024-08-31 | Oracle Compatibility, Patroni 4.0, Routine Bug Fix | v3.0.1 |
v3.0.0 | 2024-08-30 | Extension Exploding & Plugable Kernels (MSSQL,Oracle) | v3.0.0 |
v2.7.0 | 2024-05-16 | Extension Overwhelming, new docker apps | v2.7.0 |
v2.6.0 | 2024-02-29 | PG 16 as default version, ParadeDB & DuckDB | v2.6.0 |
v2.5.1 | 2023-12-01 | Routine update, pg16 major extensions | v2.5.1 |
v2.5.0 | 2023-10-24 | Ubuntu/Debian Support: bullseye, bookworm, jammy, focal | v2.5.0 |
v2.4.1 | 2023-09-24 | Supabase/PostgresML support, graphql, jwt, pg_net, vault | v2.4.1 |
v2.4.0 | 2023-09-14 | PG16, RDS Monitor, New Extensions | v2.4.0 |
v2.3.1 | 2023-09-01 | PGVector with HNSW, PG16 RC1, Chinese Docs, Bug Fix | v2.3.1 |
v2.3.0 | 2023-08-20 | PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub | v2.3.0 |
v2.2.0 | 2023-08-04 | Dashboard & Provision overhaul, UOS compatibility | v2.2.0 |
v2.1.0 | 2023-06-10 | PostgreSQL 12 ~ 16beta support | v2.1.0 |
v2.0.2 | 2023-03-31 | Add pgvector support and fix MinIO CVE | v2.0.2 |
v2.0.1 | 2023-03-21 | v2 Bug Fix, security enhance and bump grafana version | v2.0.1 |
v2.0.0 | 2023-02-28 | Compatibility Security Maintainability Enhancement | v2.0.0 |
v1.5.1 | 2022-06-18 | Grafana Security Hotfix | v1.5.1 |
v1.5.0 | 2022-05-31 | Docker Applications | v1.5.0 |
v1.4.1 | 2022-04-20 | Bug fix & Full translation of English documents. | v1.4.1 |
v1.4.0 | 2022-03-31 | MatrixDB Support, Separated INFRA, NODES, PGSQL, REDIS | v1.4.0 |
v1.3.0 | 2021-11-30 | PGCAT Overhaul & PGSQL Enhancement & Redis Support Beta | v1.3.0 |
v1.2.0 | 2021-11-03 | Upgrade default Postgres to 14, monitoring existing pg | v1.2.0 |
v1.1.0 | 2021-10-12 | HomePage, JupyterLab, PGWEB, Pev2 & Pgbadger | v1.1.0 |
v1.0.0 | 2021-07-26 | v1 GA, Monitoring System Overhaul | v1.0.0 |
v0.9.0 | 2021-04-04 | Pigsty GUI, CLI, Logging Integration | v0.9.0 |
v0.8.0 | 2021-03-28 | Service Provision | v0.8.0 |
v0.7.0 | 2021-03-01 | Monitor only deployment | v0.7.0 |
v0.6.0 | 2021-02-19 | Architecture Enhancement | v0.6.0 |
v0.5.0 | 2021-01-07 | Database Customize Template | v0.5.0 |
v0.4.0 | 2020-12-14 | PostgreSQL 13 Support, Official Documentation | v0.4.0 |
v0.3.0 | 2020-10-22 | Provisioning Solution GA | v0.3.0 |
v0.2.0 | 2020-07-10 | PGSQL Monitoring v6 GA | v0.2.0 |
v0.1.0 | 2020-06-20 | Validation on Testing Environment | v0.1.0 |
v0.0.5 | 2020-08-19 | Offline Installation Mode | v0.0.5 |
v0.0.4 | 2020-07-27 | Refactor playbooks into ansible roles | v0.0.4 |
v0.0.3 | 2020-06-22 | Interface enhancement | v0.0.3 |
v0.0.2 | 2020-04-30 | First Commit | v0.0.2 |
v0.0.1 | 2019-05-15 | POC | v0.0.1 |
Release v3.5.0
v3.5.0 (Beta)
Highlights
- PostgreSQL 18 (Beta) support — monitoring via
pg_exporter 1.0.0
, installer alias viapig 0.4.2
, plus a ready-to-usepg18
template - 421 bundled extensions, now including OrioleDB and OpenHalo kernels on all platforms
pig do
CLI replaces legacybin/
scripts- Hardening for self-hosted Supabase (replication lag, key distribution, etc.)
- Code & architecture refactor — slimmer tasks, cleaner defaults for Postgres & PgBouncer
- Monitoring stack refresh — Grafana 12,
pg_exporter 1.0
, new panels & plugins
curl https://repo.pigsty.io/get | bash -s v3.5.0
Module Changes
- Add PostgreSQL 18 support
- PG18 metrics support with pg_exporter 1.0.0+
- PG18 install support with pig 0.4.1+
- New config template
pg18.yml
- Refactored
pgsql
module - Split monitoring into a new
pg_monitor
role; removedclean
logic - Pruned duplicate tasks, dropped
dir/utils
block, renamed templates (no.j2
) - All extensions install in
extensions
schema (Supabase best-practice) - Added
SET search_path=''
to every monitoring function - Tuned PgBouncer defaults (larger pool, cleanup query); new
pgbouncer_ignore_param
- New
pg_key
task to generatepgsodium
master keys - Enabled
sync_replication_slots
by default on PG 17 - Retagged subtasks for clearer structure
- Refactored
pg_remove
module - New flags
pg_rm_data
,pg_rm_bkup
,pg_rm_pkg
control what gets wiped - Clearer role layout & tagging
- Added new
pg_monitor
module - pgbouncer_exporter no longer shares configuration files with
pg_exporter
- Added monitoring metrics for TimescaleDB and Citus
- Using
pg_exporter
0.9.0 with updated replication slot metrics for PG16/17 - Using more compact, newly designed collector configuration files
- Supabase Enhancement (thanks @lawso017 for the contribution)
- update supabase containers and schemas to the latest version
- Support
pgsodium
server key loading - fix logflare lag issue with
supa-kick
crontab - add
set search_path
clause for monitor functions - Added new
pig do
command to CLI, allowing command-line tool to replace Shell scripts inbin/
Infra Package Updates
- pig 0.4.2
- duckdb 1.3.0
- etcd 3.6.0
- vector 0.47.0
- minio 20250422221226
- mcli 20250416181326
- pev 1.5.0
- rclone 1.69.3
- mtail 3.0.8 (new)
Observability Package Updates
- grafana 12.0.0
- grafana-victorialogs-ds 0.16.3
- grafana-victoriametrics-ds 0.15.1
- grafana-infinity-ds 3.2.1
- grafana_plugins 12.0.0
- prometheus 3.4.0
- pushgateway 1.11.1
- nginx_exporter 1.4.2
- pg_exporter 1.0.0
- pgbackrest_exporter 0.20.0
- redis_exporter 1.72.1
- keepalived_exporter 1.6.2
- victoriametrics 1.117.1
- victoria_logs 1.22.2
Database Package Updates
- PostgreSQL 17.5, 16.9, 15.13, 14.18, 13.21
- PostgreSQL 18beta1 support
- pgbouncer 1.24.1
- pgbackrest 2.55
- pgbadger 13.1
Extension Package Updates
- spat 0.1.0a4 new extension
- pgsentinel 1.1.0 new extension
- pgdd 0.6.0 (pgrx 0.14.1) new extension add back
- convert 0.0.4 (pgrx 0.14.1) new extension
- pg_tokenizer.rs 0.1.0 (pgrx 0.13.1)
- pg_render 0.1.2 (pgrx 0.12.8)
- pgx_ulid 0.2.0 (pgrx 0.12.7)
- pg_idkit 0.3.0 (pgrx 0.14.1)
- pg_ivm 1.11.0
- orioledb 1.4.0 beta11 rpm & add debian/ubuntu support
- openhalo 14.10 add debian/ubuntu support
- omnigres 20250507 (miss on d12/u22)
- citus 12.0.3
- timescaledb 2.20.0 (DROP PG14 support)
- supautils 2.9.2
- pg_envvar 1.0.1
- pgcollection 1.0.0
- aggs_for_vecs 1.4.0
- pg_tracing 0.1.3
- pgmq 1.5.1
- tzf-pg 0.2.0 (pgrx 0.14.1)
- pg_search 0.15.18 (pgrx 0.14.1)
- anon 2.1.1 (pgrx 0.14.1)
- pg_parquet 0.4.0 (0.14.1)
- pg_cardano 1.0.5 (pgrx 0.12) -> 0.14.1
- pglite_fusion 0.0.5 (pgrx 0.12.8) -> 14.1
- vchord_bm25 0.2.1 (pgrx 0.13.1)
- vchord 0.3.0 (pgrx 0.13.1)
- pg_vectorize 0.22.1 (pgrx 0.13.1)
- wrappers 0.4.6 (pgrx 0.12.9)
- timescaledb-toolkit 1.21.0 (pgrx 0.12.9)
- pgvectorscale 0.7.1 (pgrx 0.12.9)
- pg_session_jwt 0.3.1 (pgrx 0.12.6) -> 0.12.9
- pg_timetable 5.13.0
- ferretdb 2.2.0
- documentdb 0.103.0 (+aarch64 support)
- pgml 2.10.0 (pgrx 0.12.9)
- sqlite_fdw 2.5.0 (fix pg17 deb)
- tzf 0.2.2 0.14.1 (rename src)
- pg_vectorize 0.22.2 (pgrx 0.13.1)
- wrappers 0.5.0 (pgrx 0.12.9)
Checksums
df30f2599a6416eea11acfd0f05ee14b pigsty-v3.5.0.tgz
4c9fabc2d1f0ed733145af2b6aff2f48 pigsty-pkg-v3.5.0.d12.x86_64.tgz
796d47de12673b2eb9882e527c3b6ba0 pigsty-pkg-v3.5.0.el8.x86_64.tgz
a53ef2cede1363f11e9faaaa43718fdc pigsty-pkg-v3.5.0.el9.x86_64.tgz
36da28f97a845fdc0b7bbde2d3812a67 pigsty-pkg-v3.5.0.u22.x86_64.tgz
8551b3e04b38af382163e6857778437d pigsty-pkg-v3.5.0.u24.x86_64.tgz
Release v3.4.1
v3.4.1
GitHub Release Page: v3.4.1
- Added support for MySQL wire-compatible PostgreSQL kernel on EL systems: openHalo
- Added support for OLTP-enhanced PostgreSQL kernel on EL systems: orioledb
- Optimized pgAdmin 9.2 application template with automatic server list updates and pgpass password population
- Increased PG default max connections to 250, 500, 1000
- Removed the
mysql_fdw
extension with dependency errors from EL8
Infra Updates
- pig 0.3.4
- etcd 3.5.21
- restic 0.18.0
- ferretdb 2.1.0
- tigerbeetle 0.16.34
- pg_exporter 0.8.1
- node_exporter 1.9.1
- grafana 11.6.0
- zfs_exporter 3.8.1
- mongodb_exporter 0.44.0
- victoriametrics 1.114.0
- minio 20250403145628
- mcli 20250403170756
Extension Update
- Bump pg_search to 0.15.13
- Bump citus to 13.0.3
- Bump timescaledb to 2.19.1
- Bump pgcollection RPM to 1.0.0
- Bump pg_vectorize RPM to 0.22.1
- Bump pglite_fusion RPM to 0.0.4
- Bump aggs_for_vecs RPM to 1.4.0
- Bump pg_tracing RPM to 0.1.3
- Bump pgmq RPM to 1.5.1
Checksums
471c82e5f050510bd3cc04d61f098560 pigsty-v3.4.1.tgz
4ce17cc1b549cf8bd22686646b1c33d2 pigsty-pkg-v3.4.1.d12.aarch64.tgz
c80391c6f93c9f4cad8079698e910972 pigsty-pkg-v3.4.1.d12.x86_64.tgz
811bf89d1087512a4f8801242ca8bed5 pigsty-pkg-v3.4.1.el9.x86_64.tgzz
9fe2e6482b14a3e60863eeae64a78945 pigsty-pkg-v3.4.1.u22.x86_64.tgz
Release v3.4.0
v3.4.0
GitHub Release Page: v3.4.0
Introduction Blog: Pigsty v3.4 MySQL Compatibility and Overall Enhancements
New Features
- Added new pgBackRest backup monitoring metrics and dashboards
- Enhanced Nginx server configuration options, with support for automated Certbot issuance
- Now prioritizing PostgreSQL’s built-in
C
/C.UTF-8
locale settings - IvorySQL 4.4 is now fully supported across all platforms (RPM/DEB on x86/ARM)
- Added new software packages: Juicefs, Restic, TimescaleDB EventStreamer
- The Apache AGE graph database extension now fully supports PostgreSQL 13–17 on EL
- Improved the
app.yml
playbook: launch standard Docker app without extra config - Bump Supabase, Dify, and Odoo app templates, bump to their latest versions
- Add electric app template, local-first PostgreSQL Sync Engine
Infra Packages
- +restic 0.17.3
- +juicefs 1.2.3
- +timescaledb-event-streamer 0.12.0
- Prometheus 3.2.1
- AlertManager 0.28.1
- blackbox_exporter 0.26.0
- node_exporter 1.9.0
- mysqld_exporter 0.17.2
- kafka_exporter 1.9.0
- redis_exporter 1.69.0
- pgbackrest_exporter 0.19.0-2
- DuckDB 1.2.1
- etcd 3.5.20
- FerretDB 2.0.0
- tigerbeetle 0.16.31
- vector 0.45.0
- VictoriaMetrics 1.113.0
- VictoriaLogs 1.17.0
- rclone 1.69.1
- pev2 1.14.0
- grafana-victorialogs-ds 0.16.0
- grafana-victoriametrics-ds 0.14.0
- grafana-infinity-ds 3.0.0
PostgreSQL Related
- Patroni 4.0.5
- PolarDB 15.12.3.0-e1e6d85b
- IvorySQL 4.4
- pgbackrest 2.54.2
- pev2 1.14
- WiltonDB 13.17
PostgreSQL Extensions
- pgspider_ext 1.3.0 (new extension)
- apache age 13–17 el rpm (1.5.0)
- timescaledb 2.18.2 → 2.19.0
- citus 13.0.1 → 13.0.2
- documentdb 1.101-0 → 1.102-0
- pg_analytics 0.3.4 → 0.3.7
- pg_search 0.15.2 → 0.15.8
- pg_ivm 1.9 → 1.10
- emaj 4.4.0 → 4.6.0
- pgsql_tweaks 0.10.0 → 0.11.0
- pgvectorscale 0.4.0 → 0.6.0 (pgrx 0.12.5)
- pg_session_jwt 0.1.2 → 0.2.0 (pgrx 0.12.6)
- wrappers 0.4.4 → 0.4.5 (pgrx 0.12.9)
- pg_parquet 0.2.0 → 0.3.1 (pgrx 0.13.1)
- vchord 0.2.1 → 0.2.2 (pgrx 0.13.1)
- pg_tle 1.2.0 → 1.5.0
- supautils 2.5.0 → 2.6.0
- sslutils 1.3 → 1.4
- pg_profile 4.7 → 4.8
- pg_snakeoil 1.3 → 1.4
- pg_jsonschema 0.3.2 → 0.3.3
- pg_incremental 1.1.1 → 1.2.0
- pg_stat_monitor 2.1.0 → 2.1.1
- ddl_historization 0.7 → 0.0.7 (bug fix)
- pg_sqlog 3.1.7 → 1.6 (bug fix)
- pg_random removed development suffix (bug fix)
- asn1oid 1.5 → 1.6
- table_log 0.6.1 → 0.6.4
Interface Changes
- Added new Docker parameters:
docker_data
anddocker_storage_driver
(#521 by @waitingsong) - Added new Infra parameter:
alertmanager_port
, which lets you specify the AlertManager port - Added new Infra parameter:
certbot_sign
, apply for cert during nginx init? (false by default) - Added new Infra parameter:
certbot_email
, specifying the email used when requesting certificates via Certbot - Added new Infra parameter:
certbot_options
, specifying additional parameters for Certbot - Updated IvorySQL to place its default binary under
/usr/ivory-4
starting in IvorySQL 4.4 - Changed the default for
pg_lc_ctype
and other locale-related parameters fromen_US.UTF-8
toC
- For PostgreSQL 17, if using
UTF8
encoding withC
orC.UTF-8
locales, PostgreSQL’s built-in localization rules now take priority configure
automatically detects whetherC.utf8
is supported by both the PG version and the environment, and adjusts locale-related options accordingly- Set the default IvorySQL binary path to
/usr/ivory-4
- Updated the default value of
pg_packages
topgsql-main patroni pgbouncer pgbackrest pg_exporter pgbadger vip-manager
- Updated the default value of
repo_packages
to[node-bootstrap, infra-package, infra-addons, node-package1, node-package2, pgsql-utility, extra-modules]
- Removed
LANG
andLC_ALL
environment variable settings from/etc/profile.d/node.sh
- Now using
bento/rockylinux-8
andbento/rockylinux-9
as the Vagrant box images for EL - Added a new alias,
extra_modules
, which includes additional optional modules - Updated PostgreSQL aliases:
postgresql
,pgsql-main
,pgsql-core
,pgsql-full
- GitLab repositories are now included among available modules
- The Docker module has been merged into the Infra module
- The
node.yml
playbook now includes anode_pip
task to configure a pip mirror on each node - The
pgsql.yml
playbook now includes apgbackrest_exporter
task for collecting backup metrics - The
Makefile
now allows the use ofMETA
/PKG
environment variables - Added
/pg/spool
directory as temporary storage for pgBackRest - Disabled pgBackRest’s
link-all
option by default - Enabled block-level incremental backups for MinIO repositories by default
Bug Fixes
- Fixed the exit status code in
pg-backup
(#532 by @waitingsong) - In
pg-tune-hugepage
, restricted PostgreSQL to use only large pages (#527 by @waitingsong) - Fixed logic errors in the
pg-role
task - Corrected type conversion for hugepage configuration parameters
- Fixed default value issues for
node_repo_modules
in theslim
template
Checksums
768bea3bfc5d492f4c033cb019a81d3a pigsty-v3.4.0.tgz
7c3d47ef488a9c7961ca6579dc9543d6 pigsty-pkg-v3.4.0.d12.aarch64.tgz
b5d76aefb1e1caa7890b3a37f6a14ea5 pigsty-pkg-v3.4.0.d12.x86_64.tgz
42dacf2f544ca9a02148aeea91f3153a pigsty-pkg-v3.4.0.el8.aarch64.tgz
d0a694f6cd6a7f2111b0971a60c49ad0 pigsty-pkg-v3.4.0.el8.x86_64.tgz
7caa82254c1b0750e89f78a54bf065f8 pigsty-pkg-v3.4.0.el9.aarch64.tgz
8f817e5fad708b20ee217eb2e12b99cb pigsty-pkg-v3.4.0.el9.x86_64.tgz
8b2fcaa6ef6fd8d2726f6eafbb488aaf pigsty-pkg-v3.4.0.u22.aarch64.tgz
83291db7871557566ab6524beb792636 pigsty-pkg-v3.4.0.u22.x86_64.tgz
c927238f0343cde82a4a9ab230ecd2ac pigsty-pkg-v3.4.0.u24.aarch64.tgz
14cbcb90693ed5de8116648a1f2c3e34 pigsty-pkg-v3.4.0.u24.x86_64.tgz
Release v3.3.0
v3.3.0
- Total available extensions increased to 404!
- PostgreSQL February Minor Updates: 17.4, 16.8, 15.12, 14.17, 13.20
- New Feature:
app.yml
script for auto-installing apps like Odoo, Supabase, Dify. - New Feature: Further Nginx configuration customization in
infra_portal
. - New Feature: Added Certbot support for quick free HTTPS certificate requests.
- New Feature: Pure-text extension list now supported in
pg_default_extensions
. - New Feature: Default repositories now include mongo, redis, groonga, haproxy, etc.
- New Parameter:
node_aliases
to add command aliases for Nodes. - Fix: Resolved default EPEL repo address issue in Bootstrap script.
- Improvement: Added Aliyun mirror for Debian Security repository.
- Improvement: pgBackRest backup support for IvorySQL kernel.
- Improvement: ARM64 and Debian/Ubuntu support for PolarDB.
- pg_exporter 0.8.0 now supports new metrics in pgbouncer 1.24.
- New Feature: Auto-completion for common commands like
git
,docker
,systemctl
#506 #507 by @waitingsong. - Improvement: Refined
ignore_startup_parameters
inpgbouncer
config template #488 by @waitingsong. - New homepage design: Pigsty’s website now features a fresh new look.
- Extension Directory: Detailed information and download links for RPM/DEB binary packages.
- Extension Build:
pig
CLI now auto-sets PostgreSQL extension build environment.
New Extensions
12 new PostgreSQL extensions added, bringing the total to 404 available extensions.
- documentdb 0.101-0
- VectorChord-bm25 (vchord_bm25) 0.1.0
- pg_tracing 0.1.2
- pg_curl 2.4
- pgxicor 0.1.0
- pgsparql 1.0
- pgjq 0.1.0
- hashtypes 0.1.5
- db_migrator 1.0.0
- pg_cooldown 0.1
- pgcollection 0.9.1
- pg_bzip 1.0.0
Bump Extension
- citus 13.0.0 -> 13.0.1
- pg_duckdb 0.2.0 -> 0.3.1
- pg_mooncake 0.1.0 -> 0.1.2
- timescaledb 2.17.2 -> 2.18.2
- supautils 2.5.0 -> 2.6.0
- supabase_vault 0.3.1 (become C)
- VectorChord 0.1.0 -> 0.2.1
- pg_bulkload 3.1.22 (+pg17)
- pg_store_plan 1.8 (+pg17)
- pg_search 0.14 -> 0.15.2
- pg_analytics 0.3.0 -> 0.3.4
- pgroonga 3.2.5 -> 4.0.0
- zhparser 2.2 -> 2.3
- pg_vectorize 0.20.0 -> 0.21.1
- pg_net 0.14.0
- pg_curl 2.4.2
- table_version 1.10.3 -> 1.11.0
- pg_duration 1.0.2
- pg_graphql 1.5.9 -> 1.5.11
- vchord 0.1.1 -> 0.2.1 ((+13))
- vchord_bm25 0.1.0 -> 0.1.1
- pg_mooncake 0.1.1 -> 0.1.2
- pgddl 0.29
- pgsql_tweaks 0.11.0
Infra Updates
- pig 0.1.3 -> 0.3.0
- pushgateway 1.10.0 -> 1.11.0
- alertmanager 0.27.0 -> 0.28.0
- nginx_exporter 1.4.0 -> 1.4.1
- pgbackrest_exporter 0.18.0 -> 0.19.0
- redis_exporter 1.66.0 -> 1.67.0
- mongodb_exporter 0.43.0 -> 0.43.1
- VictoriaMetrics 1.107.0 -> 1.111.0
- VictoriaLogs v1.3.2 -> 1.9.1
- DuckDB 1.1.3 -> 1.2.0
- Etcd 3.5.17 -> 3.5.18
- pg_timetable 5.10.0 -> 5.11.0
- FerretDB 1.24.0 -> 2.0.0-rc
- tigerbeetle 0.16.13 -> 0.16.27
- grafana 11.4.0 -> 11.5.2
- vector 0.43.1 -> 0.44.0
- minio 20241218131544 -> 20250218162555
- mcli 20241121172154 -> 20250215103616
- rclone 1.68.2 -> 1.69.0
- vray 5.23 -> 5.28
Release v3.2.2
v3.2.2
- New Extension(s):
Omnigres
33 extensions, postgres as platform - New Extension:
pg_mooncake
: duckdb in postgres - New Extensions:
pg_xxhash
- New Extension:
timescaledb_toolkit
- New Extension:
pg_xenophile
- New Extension:
pg_drop_events
- New Extension:
pg_incremental
- Bump
citus
to 13.0.0 with PostgreSQL 17 support. - Bump
pgml
to 2.10.0 - Bump
pg_extra_time
to 2.0.0 - Bump
pg_vectorize
to 0.20.0
What’s Changed
- Bump IvorySQL to 4.2 (PostgreSQL 17.2)
- Add Arm64 and Debian support for PolarDB kernel
- Add certbot and certbot-nginx to default
infra_packages
- Increase pgbouncer max_prepared_statements to 256
- remove
pgxxx-citus
package alias - hide
pgxxx-olap
category inpg_extensions
by default
Release v3.2.1
v3.2.1
Highlights
- 351 PostgreSQL Extensions, including the powerful postgresql-anonymizer 2.0
- IvorySQL 4.0 support for EL 8/9
- Now use the Pigsty compiled Citus, TimescaleDB and pgroonga on all distros
- Add self-hosting Odoo template and support
Bump software versions
- pig CLI 0.1.2 self-updating capability
- prometheus 3.1.0
Add New Extension
- add pg_anon 2.0.0
- add omnisketch 1.0.2
- add ddsketch 1.0.1
- add pg_duration 1.0.1
- add ddl_historization 0.0.7
- add data_historization 1.1.0
- add schedoc 0.0.1
- add floatfile 1.3.1
- add pg_upless 0.0.3
- add pg_task 1.0.0
- add pg_readme 0.7.0
- add vasco 0.1.0
- add pg_xxhash 0.0.1
Update Extension
- lower_quantile 1.0.3
- quantile 1.1.8
- sequential_uuids 1.0.3
- pgmq 1.5.0 (subdir)
- floatvec 1.1.1
- pg_parquet 0.2.0
- wrappers 0.4.4
- pg_later 0.3.0
- topn fix for deb.arm64
- add age 17 on debian
- powa + pg17, 5.0.1
- h3 + pg17
- ogr_fdw + pg17
- age + pg17 1.5 on debian
- pgtap + pg17 1.3.3
- repmgr
- topn + pg17
- pg_partman 5.2.4
- credcheck 3.0
- ogr_fdw 1.1.5
- ddlx 0.29
- postgis 3.5.1
- tdigest 1.4.3
- pg_repack 1.5.2
Release v3.2.1
v3.2.0
Highlights
- New CLI: Introducing the
pig
command-line tool for managing extension plugins. - ARM64 Support: 390 extensions are now available for ARM64 across five major distributions.
- Supabase Update: Latest Supabase Release Week updates are now supported for self-hosting on all distributions.
- Grafana v11.4: Upgraded Grafana to version 11.4, featuring a new Infinity datasource.
Package Changes
- New Extensions
- Added
timescaledb
,timescaledb-loader
,timescaledb-toolkit
, andtimescaledb-tool
to the PIGSTY repository. - Added a custom-compiled pg_timescaledb for EL.
- Added pgroonga, custom-compiled for all EL variants.
- Added vchord 0.1.0.
- Added pg_bestmatch.rs 0.0.1.
- Added pglite_fusion 0.0.3.
- Added pgpdf 0.1.0.
- Updated Extensions
- pgvectorscale: 0.4.0 → 0.5.1
- pg_parquet: 0.1.0 → 0.1.1
- pg_polyline: 0.0.1
- pg_cardano: 1.0.2 → 1.0.3
- pg_vectorize: 0.20.0
- pg_duckdb: 0.1.0 → 0.2.0
- pg_search: 0.13.0 → 0.13.1
- aggs_for_vecs: 1.3.1 → 1.3.2
- Infrastructure
- Added promscale 0.17.0
- Added grafana-plugins 11.4
- Added grafana-infinity-plugins
- Added grafana-victoriametrics-ds
- Added grafana-victorialogs-ds
- vip-manager: 2.8.0 → 3.0.0
- vector: 0.42.0 → 0.43.0
- grafana: 11.3 → 11.4
- prometheus: 3.0.0 → 3.0.1 (package name changed from
prometheus2
toprometheus
) - nginx_exporter: 1.3.0 → 1.4.0
- mongodb_exporter: 0.41.2 → 0.43.0
- VictoriaMetrics: 1.106.1 → 1.107.0
- VictoriaLogs: 1.0.0 → 1.3.2
- pg_timetable: 5.9.0 → 5.10.0
- tigerbeetle: 0.16.13 → 0.16.17
- pg_export: 0.7.0 → 0.7.1
- New Docker App
- Add mattermost the open-source Slack alternative self-hosting template
- Bug Fixes
- Added
python3-cdiff
forel8.aarch64
to fix missing Patroni dependency. - Added
timescaledb-tools
forel9.aarch64
to fix missing package in official repo. - Added
pg_filedump
forel9.aarch64
to fix missing package in official repo. - Removed Extensions
- pg_mooncake: Removed due to conflicts with
pg_duckdb
. - pg_top: Removed because of repeated version issues and quality concerns.
- hunspell_pt_pt: Removed because of conflict with official PG dictionary files.
- pgml: Disabled by default (no longer downloaded or installed).
API Changes
repo_url_packages
now defaults to an empty array; packages are installed via OS package managers.grafana_plugin_cache
is deprecated; Grafana plugins are now installed via OS package managers.grafana_plugin_list
is deprecated for the same reason.- The 36-node “production” template has been renamed to
simu
. - Auto-generated code under
node_id/vars
now includesaarch64
support. infra_packages
now includes thepig
CLI tool.- The
configure
command now updates the version numbers ofpgsql-xxx
aliases in auto-generated config files. - Update terraform templates with Makefile shortcuts and better provision experience
Bug Fix
- Fix pgbouncer dashboard selector issue #474
- Add
--arg value
support forpg-pitr
by @waitingsong - Fix redis log message typo by @waitingsong
Checksums
c42da231067f25104b71a065b4a50e68 pigsty-pkg-v3.2.0.d12.aarch64.tgz
ebb818f98f058f932b57d093d310f5c2 pigsty-pkg-v3.2.0.d12.x86_64.tgz
d2b85676235c9b9f2f8a0ad96c5b15fd pigsty-pkg-v3.2.0.el9.aarch64.tgz
649f79e1d94ec1845931c73f663ae545 pigsty-pkg-v3.2.0.el9.x86_64.tgz
24c0be1d8436f3c64627c12f82665a17 pigsty-pkg-v3.2.0.u22.aarch64.tgz
0b9be0e137661e440cd4f171226d321d pigsty-pkg-v3.2.0.u22.x86_64.tgz
8fdc6a60820909b0a2464b0e2b90a3a6 pigsty-v3.2.0.tgz