Pigsty v3.7.0

Highlights

• PostgreSQL 18 Deep Support: Now the default major PG version, with full extension readiness!
• Expanded OS Support: Added EL10 and Debian 13, bringing the total supported operating systems to 14.
• Extension Growth: The PostgreSQL extension library now includes 437 entries.
• Ansible 2.19 Compatibility: Full support for Ansible 2.19 following its breaking changes.
• Kernel Updates: Latest versions for Supabase, PolarDB, IvorySQL, and Percona kernels.
• Optimized Tuning: Refined logic for default PG parameters to maximize resource utilization.
• PGEXT.CLOUD: Dedicate extension website open-sourced under apache-2.0 license

Version Updates

• PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, 13.23
• Patroni 4.1.0
• Pgbouncer 1.25.0
• pg_exporter 1.0.3
• pgbackrest 2.57.0
• Supabase 2025-11
• PolarDB 15.15.5.0
• FerretDB 2.7.0
• DuckDB 1.4.2
• Etcd 3.6.6
• pig 0.7.4

For detailed version changes, please refer to:

• INFRA Changelog
• RPM Changelog
• DEB Changelog

API Changes

• Implemented a refined optimization strategy for parallel execution parameters. See Tuning Guide.
• The citus extension is no longer installed by default in rich and full templates (PG 18 support pending).
• Added duckdb extension stubs to PostgreSQL parameter templates.
• Capped min_wal_size, max_wal_size, and max_slot_wal_keep_size at 200 GB, 2000 GB, and 3000 GB, respectively.
• Capped temp_file_limit at 200 GB (2 TB for OLAP workloads).
• Increased the default connection count for the connection pool.
• Added prometheus_port (default: 9058) to avoid conflicts with the EL10 RHEL Web Console port.
• Changed alertmanager_port default to 9059 to avoid potential conflicts with Kafka SSL ports.
• Added a pg_pre subtask to pg_pkg: removes conflicting LLVM packages (bpftool, python3-perf) on EL9+ prior to PG installation.
• Added the llvm module to the default repository definition for Debian/Ubuntu.
• Fixed package removal logic in infra-rm.yml.

Compatibility Fixes

• Ubuntu/Debian CA Trust: Fixed incorrect warning return codes when trusting Certificate Authorities.
• Ansible 2.19 Support: Resolved numerous compatibility issues introduced by Ansible 2.19 to ensure stability across versions:
  • Added explicit int type casting for sequence variables.
  • Migrated with_items syntax to loop.
  • Nested key exchange variables in lists to prevent character iteration on strings in newer versions.
  • Explicitly cast range usage to list.
  • Renamed reserved variables such as name and port.
  • Replaced play_hosts with ansible_play_hosts.
• Added string casting for specific variables to prevent runtime errors.
• EL10 Adaptation:
  • Fixed missing ansible-collection-community-crypto preventing key generation.
  • Fixed missing ansible logic packages.
  • Removed modulemd_tools, flamegraph, and timescaledb-tool.
  • Replaced java-17-openjdk with java-21-openjdk.
  • Resolved aarch64 YUM repository naming issues.
• Debian 13 Adaptation:
  • Replaced dnsutils with bind9-dnsutils.
• Ubuntu 24 Fixes:
  • Temporarily removed tcpdump due to upstream dependency crashes.

Checksums

e00d0c2ac45e9eff1cc77927f9cd09df  pigsty-v3.7.0.tgz
987529769d85a3a01776caefefa93ecb  pigsty-pkg-v3.7.0.d12.aarch64.tgz
2d8272493784ae35abeac84568950623  pigsty-pkg-v3.7.0.d12.x86_64.tgz
090cc2531dcc25db3302f35cb3076dfa  pigsty-pkg-v3.7.0.d13.x86_64.tgz
ddc54a9c4a585da323c60736b8560f55  pigsty-pkg-v3.7.0.el10.aarch64.tgz
d376e75c490e8f326ea0f0fbb4a8fd9b  pigsty-pkg-v3.7.0.el10.x86_64.tgz
8c2deeba1e1d09ef3d46d77a99494e71  pigsty-pkg-v3.7.0.el8.aarch64.tgz
9795e059bd884b9d1b2208011abe43cd  pigsty-pkg-v3.7.0.el8.x86_64.tgz
08b860155d6764ae817ed25f2fcf9e5b  pigsty-pkg-v3.7.0.el9.aarch64.tgz
1ac430768e488a449d350ce245975baa  pigsty-pkg-v3.7.0.el9.x86_64.tgz
e033aaf23690755848db255904ab3bcd  pigsty-pkg-v3.7.0.u22.aarch64.tgz
cc022ea89181d89d271a9aaabca04165  pigsty-pkg-v3.7.0.u22.x86_64.tgz
0e978598796db3ce96caebd76c76e960  pigsty-pkg-v3.7.0.u24.aarch64.tgz
48223898ace8812cc4ea79cf3178476a  pigsty-pkg-v3.7.0.u24.x86_64.tgz

v3.7.0-beta1

Get Started with the latest beta version:

curl https://repo.pigsty.io/beta | bash
cd pigsty
./configure
./install.yml

Checksums

964d30b28554ee40d1b0ed4859eb4deb  pigsty-v3.7.0.tgz
83bd3b3551722202b9c99bcaee53345e  pigsty-pkg-v3.7.0.d12.aarch64.tgz
8bbce0ddc5a21825e4bf51ec3114520d  pigsty-pkg-v3.7.0.d12.x86_64.tgz
75e92b31f4819df00d81e03381164a8c  pigsty-pkg-v3.7.0.d13.x86_64.tgz
305f33effa5f97bf8b1b0403be46fd7b  pigsty-pkg-v3.7.0.el10.x86_64.tgz
1a5131777ef3f184007223027f975bbb  pigsty-pkg-v3.7.0.el8.aarch64.tgz
667e9910b4ef1899da9b07d7a30ab92a  pigsty-pkg-v3.7.0.el8.x86_64.tgz
544083de18e1dbfef9bded9df0e45db4  pigsty-pkg-v3.7.0.el9.aarch64.tgz
90b05d9896cf29828f41080800722ce0  pigsty-pkg-v3.7.0.el9.x86_64.tgz
89cd7e0fa31ed634448cd55c8fd7cfca  pigsty-pkg-v3.7.0.u22.aarch64.tgz
294fadf6a10e4ccaef2131c2fc32330e  pigsty-pkg-v3.7.0.u22.x86_64.tgz
f3350df7d8ef103243fd7a87dd705035  pigsty-pkg-v3.7.0.u24.aarch64.tgz
565222fba93c342950dfa82ee896c7e7  pigsty-pkg-v3.7.0.u24.x86_64.tgz

v3.6.1 Minor Release

curl https://repo.pigsty.cc/get | bash -s v3.6.1

Highlights

• PostgreSQL 17.6, 16.10, 15.14, 14.19, 13.22, and 18 Beta 3 Released!
• PGDG APT/YUM mirror for Mainland China Users
• New home website https://pgsty.com
• Add el10, debian 13 stub, add el10 terraform images

Infra Package Updates

• Grafana 12.1.0
• pg_exporter 1.0.2
• pig 0.6.1
• vector 0.49.0
• redis_exporter 1.75.0
• mongo_exporter 0.47.0
• victoriametrics 1.123.0
• victorialogs: 1.28.0
• grafana-victoriametrics-ds 0.18.3
• grafana-victorialogs-ds 0.19.3
• grafana-infinity-ds 3.4.1
• etcd 3.6.4
• ferretdb 2.5.0
• tigerbeetle 0.16.54
• genai-toolbox 0.12.0

Extension Package Updates

• pg_search 0.17.3

API Changes

• remove br_filter from default node_kernel_modules
• do not use OS minor version dir for pgdg yum repos

Checksums

045977aff647acbfa77f0df32d863739  pigsty-pkg-v3.6.1.d12.aarch64.tgz
636b15c2d87830f2353680732e1af9d2  pigsty-pkg-v3.6.1.d12.x86_64.tgz
700a9f6d0db9c686d371bf1c05b54221  pigsty-pkg-v3.6.1.el8.aarch64.tgz
2aff03f911dd7be363ba38a392b71a16  pigsty-pkg-v3.6.1.el8.x86_64.tgz
ce07261b02b02b36a307dab83e460437  pigsty-pkg-v3.6.1.el9.aarch64.tgz
d598d62a47bbba2e811059a53fe3b2b5  pigsty-pkg-v3.6.1.el9.x86_64.tgz
13fd68752e59f5fd2a9217e5bcad0acd  pigsty-pkg-v3.6.1.u22.aarch64.tgz
c25ccfb98840c01eb7a6e18803de55bb  pigsty-pkg-v3.6.1.u22.x86_64.tgz
0d71e58feebe5299df75610607bf428c  pigsty-pkg-v3.6.1.u24.aarch64.tgz
4fbbab1f8465166f494110c5ec448937  pigsty-pkg-v3.6.1.u24.x86_64.tgz
083d8680fa48e9fec3c3fcf481d25d2f  pigsty-v3.6.1.tgz

v3.6.0 The Omni Distro

curl https://repo.pigsty.cc/get | bash -s v3.6.0

Highlights

• Brand‑new documentation portal: https://doc.pgsty.com
• Added the pgsql-pitr playbook and a full backup/restore guide for a smoother PITR experience
• New kernel support: Percona PG TDE (PG 17)
• Smoother self‑hosted Supabase workflow—updated to the latest version and fixed several issues in the upstream templates
• Streamlined installation: online install is now the default, and the bootstrap step (Ansible installation) is embedded in the install script

Design Improvements

• All configuration templates have been reorganised for easier use
• Faster Docker‑registry mirror for China Mainland users
• Re‑worked MinIO module: HTTP mode supported and three ready‑to‑use buckets with different policies are created out‑of‑the‑box
• Tuned OS‑parameter template refined for modern hardware and NVMe drives
• New pgactive extension for multi‑primary replication and sub‑second failover
• Revised default values for pg_fs_main / pg_fs_bkup to simplify directory layout

Bug Fixes

• Fixed pgbouncer configuration error (thanks @housei‑zzy)
• Resolved OrioleDB issues on Debian platforms
• Metrics now collected via the Telemetry API introduced in TimescaleDB 2.20+
• Fixed tuned shared‑memory parameters
• Offline packages now pull directly from the PGDG repo, avoiding out‑of‑sync mirrors
• Fix ivorysql libxcrypt dependencies issus

Observability Package Updates

New VictoriaMetrics / VictoriaLogs packages:

• genai-toolbox 0.9.0 (new)
• victoriametrics 1.120.0 → 1.121.0 (refactor)
• vmutils 1.121.0 (renamed from victoria‑metrics‑utils)
• grafana‑victoriametrics‑ds 0.15.1 → 0.17.0
• victorialogs 1.24.0 → 1.25.1 (refactor)
• vslogcli 1.24.0 → 1.25.1
• vlagent 1.25.1 (new)
• grafana‑victorialogs‑ds 0.16.3 → 0.18.1
• prometheus 3.4.1 → 3.5.0
• grafana 12.0.0 → 12.0.2
• vector 0.47.0 → 0.48.0
• grafana‑infinity‑ds 3.2.1 → 3.3.0
• keepalived_exporter 1.7.0 (new)
• blackbox_exporter 0.26.0 → 0.27.0
• redis_exporter 1.72.1 → 1.77.0
• rclone 1.69.3 → 1.70.3

Database Package Updates

• PostgreSQL 18 Beta 2
• pg_exporter 1.0.1—rebuilt with latest deps and shipped as a Docker image
• pig 0.6.0—fresh extension & repo list plus pig install sub‑command
• vip‑manager 3.0.0 → 4.0.0
• ferretdb 2.2.0 → 2.3.1
• dblab 0.32.0 → 0.33.0
• duckdb 1.3.1 → 1.3.2
• etcd 3.6.1 → 3.6.2
• juicefs 1.2.3 → 1.3.0
• tigerbeetle 0.16.41 → 0.16.50
• pev2 1.15.0 → 1.16.0

Postgres Extension Updates

• OriolePG beta12
• plv8 3.2.4
• postgresql_anonymizer 2.3.0
• pgvectorscale 0.8.0
• wrappers 0.5.3
• citus 13.0.3 → 13.1.0
• timescaledb 2.20.0 → 2.21.1
• supautils 2.9.2 -> 2.10.0
• vchord 0.3.0 → 0.4.3
• pgactive 2.1.5 (new)
• documentdb 0.105.0
• pgdd 0.6.0 (pgrx 0.14.1)
• convert 0.0.4 (pgrx 0.14.1)
• pg_idkit 0.3.0 (pgrx 0.14.1)
• 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)
• pgmq, pg_later, pg_vectorize ownership transferred

API Changes

Old Name	New Name	Default Value	Notes
pg_fs_bkup	pg_fs_backup	/data/backups
pg_rm_bkup	pg_rm_backup	true
pg_fs_main	—	/data/postgres	default changed
nginx_cert_validity	—	397d	new parameter for self‑signed certs
minio_buckets	—	pgsql, meta, data	now creates three buckets by default
minio_users	—	—	removed dba; added s3user_meta and s3user_data
minio_https	—	false (HTTP allowed)	choose HTTP or HTTPS
minio_provision	—	true	can skip bucket/user provisioning

Checksums

ab91bc05c54b88c455bf66533c1d8d43  pigsty-v3.6.0.tgz
cea861e2b4ec7ff5318e1b3c30b470cb  pigsty-pkg-v3.6.0.d12.aarch64.tgz
2f253af87e19550057c0e7fca876d37c  pigsty-pkg-v3.6.0.d12.x86_64.tgz
0158145b9bbf0e4a120b8bfa8b44f857  pigsty-pkg-v3.6.0.el8.aarch64.tgz
07330d687d04d26e7d569c8755426c5a  pigsty-pkg-v3.6.0.el8.x86_64.tgz
311df5a342b39e3288ebb8d14d81e0d1  pigsty-pkg-v3.6.0.el9.aarch64.tgz
92aad54cc1822b06d3e04a870ae14e29  pigsty-pkg-v3.6.0.el9.x86_64.tgz
c4fadf1645c8bbe3e83d5a01497fa9ca  pigsty-pkg-v3.6.0.u22.aarch64.tgz
5477ed6be96f156a43acd740df8a9b9b  pigsty-pkg-v3.6.0.u22.x86_64.tgz
196169afc1be02f93fcc599d42d005ca  pigsty-pkg-v3.6.0.u24.aarch64.tgz
dbe5c1e8a242a62fe6f6e1f6e6b6c281  pigsty-pkg-v3.6.0.u24.x86_64.tgz

v3.5.0 PG18 & 421 Extension

Highlights

• New website: https://pgsty.com
• PostgreSQL 18 (Beta) support: monitoring via pg_exporter 1.0.0, installer alias via pig 0.4.2, and a pg18 template
• 421 bundled extensions, now including OrioleDB and OpenHalo kernels on all platforms
• pig do CLI replaces legacy bin/ 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
• Run vagrant on Apple Silicon

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; removed clean 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 generate pgsodium 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 in bin/

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

c7e5ce252ddf848e5f034173e0f29345  pigsty-v3.5.0.tgz
ba31f311a16d615c1ee1083dc5a53566  pigsty-pkg-v3.5.0.d12.aarch64.tgz
3aa5c56c8f0de53303c7100f2b3934f4  pigsty-pkg-v3.5.0.d12.x86_64.tgz
a098cb33822633357e6880eee51affd6  pigsty-pkg-v3.5.0.el8.x86_64.tgz
63723b0aeb4d6c02fff0da2c78e4de31  pigsty-pkg-v3.5.0.el9.aarch64.tgz
eb91c8921d7b8a135d8330c77468bfe7  pigsty-pkg-v3.5.0.el9.x86_64.tgz
87ff25e14dfb9001fe02f1dfbe70ae9e  pigsty-pkg-v3.5.0.u22.x86_64.tgz
18be503856f6b39a59efbd1d0a8556b6  pigsty-pkg-v3.5.0.u24.aarch64.tgz
2bbef6a18cfa99af9cd175ef0adf873c  pigsty-pkg-v3.5.0.u24.x86_64.tgz

v3.4.1 OpenHalo & OrioleDB

Introduction Blog: Pigsty v3.4: MySQL Wire-Compatibility and Improvements

curl -fsSL https://repo.pigsty.io/get | bash -s 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

v3.4.0 Better Bakcup & Auto Certs

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 and docker_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 from en_US.UTF-8 to C
• For PostgreSQL 17, if using UTF8 encoding with C or C.UTF-8 locales, PostgreSQL’s built-in localization rules now take priority
• configure automatically detects whether C.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 to pgsql-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 and LC_ALL environment variable settings from /etc/profile.d/node.sh
• Now using bento/rockylinux-8 and bento/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 a node_pip task to configure a pip mirror on each node
• The pgsql.yml playbook now includes a pgbackrest_exporter task for collecting backup metrics
• The Makefile now allows the use of META/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 the slim 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

v3.3.0 with 404 Ext, App, DocumentDB, Nginx Enhancement

Blog: The complete introduction of v3.3.0 : Extension 404，Odoo, Dify, Supabase, Nginx Enhancement

curl https://repo.pigsty.io/get | bash  # get pigsty
curl https://repo.pigsty.io/pig | bash  # get pig cli

New Features

• Total available postgres extensions: 404!
• New Website Design: Global website: pigsty.io and zh-cn Site: pigsty.cc
• PostgreSQL February Minor Updates: 17.4, 16.8, 15.12, 14.17, 13.20
• New Feature: app.yml for installing apps like Odoo,Dify, Supabase.
• New Feature: Fine-grained Nginx config customization in infra_portal.
• New Feature: Added Certbot support for quick free HTTPS cert requests.
• 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 in pgbouncer config template #488 by @waitingsong.
• Extension Catalog: 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

API Change

• New Parameter: node_aliases to add command aliases for Nodes.
• New Option: using plain extension name in pg_default_extensions
• New Option: using conf, index, log, certbot options in infra_portal entries.
• New Defaults: add mongo, redis, pgroonga repos to repo_upstream default values
• New Defaults: Remove hydra from default olap list, replace ferretdb with ferretdb2

Bug Fix

• Fix: Resolved default EPEL repo address issue in Bootstrap script.
• Fix: Fix Debian Security China Mirror URL

Postgres Update

• PostgreSQL 17.4, 16.8, 15.12, 14.17, 13.20
• Pgbouncer 1.24
• Patroni 4.0.5
• pgBackRest 2.54.2
• pg_exporter 0.8.0
• pig 0.3.0

Extension Update

• 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

Checksums

5b5dbb91c42068e25efc5b420f540909  pigsty-v3.3.0.tgz
048c7d5b3fbf1727e156e7d4885ac2eb  pigsty-pkg-v3.3.0.d12.aarch64.tgz
bbb5c225e2a429f49a653695678676b6  pigsty-pkg-v3.3.0.d12.x86_64.tgz
756ec04632fb42c6f75a7b4dd29ffb09  pigsty-pkg-v3.3.0.el9.aarch64.tgz
602e1596219c1e33fdf1cd49e5b17c21  pigsty-pkg-v3.3.0.el9.x86_64.tgz
ca0fd50a99cfc5b342717594e0ca1353  pigsty-pkg-v3.3.0.u22.aarch64.tgz
4c694893c6c42e401516f0070d373b69  pigsty-pkg-v3.3.0.u22.x86_64.tgz

v3.2.2 omnigres support with 390 extensions

Extensions

• 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
• Bump pg_search to 0.14.1
• Bump pg_analytics to 0.3.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 in pg_extensions by default

• fix(supabase): use S3_REGION env var for storage s3 config by @washanhanzi in #485

New Contributors

• @washanhanzi made their first contribution in #485

Full Changelog: v3.2.0...v3.2.2

v3.2.1 anon, 351 ext, ivory4 and odoo

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

New Install Method

Now you can install pigsty with pig cli tool:

curl -fsSL https://repo.pigsty.io/pig | bash
pig sty init     # install embed pigsty to ~/pigsty 
pig sty boot     # install ansible and other pre-deps 
pig sty conf     # auto-generate pigsty.yml config file
pig sty install  # run the install.yml playbook

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

What's Changed

• fix(supabase): use S3_REGION env var for storage s3 config by @washanhanzi in #485

New Contributors

• @washanhanzi made their first contribution in #485

Full Changelog: v3.2.0...v3.2.1