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