Latest Release

v3.6.0

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

Highlights

• Brand-new documentation site: https://doc.pgsty.com
• Added pgsql-pitr playbook and backup/restore tutorial, improved PITR experience
• Added kernel support: Percona PG TDE (PG17)
• Optimized self-hosted Supabase experience, updated to the latest version, and fixed issues with the official template
• Simplified installation steps, online install by default, bootstrap now part of install script

Improvements

• Refactored ETCD module with dedicate remove playbook and bin utils
• Refactored MinIO module with plain HTTP mode, better bucket provisioning options.
• Reorganized and streamlined all configuration templates for easier use
• Faster Docker Registry mirror for users in mainland China
• Optimized tuned OS parameter templates for modern hardware and NVMe disks
• Added extension pgactive for multi-master replication and sub-second failover
• Adjusted default values for pg_fs_main / pg_fs_backup, simplified file directory structure design

Bug Fixes

• Fixed pgbouncer configuration file error by @housei-zzy
• Fixed OrioleDB issues on Debian platform
• Fixed tuned shm configuration parameter issue
• Offline packages now use the PGDG source directly, avoiding out-of-sync mirror sites
• Fix ivorysql libxcrypt dependencies issus
• Fix Replace the slow and broken epel mirror
• Fix haproxy_enabled flag not working

Infra Package Updates

Added Victoria Metrics / Victoria Logs related packages

• genai-toolbox 0.9.0 (new)
• victoriametrics 1.120.0 -> 1.121.0 (refactor)
• vmutils 1.121.0 (rename 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
• 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 Beta2 update
• pg_exporter 1.0.1, updated to latest dependencies and provides Docker image
• pig 0.6.0, updated extension and repository list, with pig install subcommand
• 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.3
• ferretdb 2.2.0 -> 2.4.0
• juicefs 1.2.3 -> 1.3.0
• tigerbeetle 0.16.41 -> 0.16.50
• pev2 1.15.0 -> 1.16.0

Extension Package Updates

• OrioleDB 1.5 beta12
• OriolePG 17.11
• plv8 3.2.3 -> 3.2.4
• postgresql_anonymizer 2.1.1 -> 2.3.0
• pgvectorscale 0.7.1 -> 0.8.0
• wrappers 0.5.0 -> 0.5.3
• supautils 2.9.1 -> 2.10.0
• citus 13.0.3 -> 13.1.0
• timescaledb 2.20.0 -> 2.21.1
• vchord 0.3.0 -> 0.4.3
• pgactive 2.1.5 (new)
• documentdb 0.103.0 -> 0.105.0
• pg_search 0.17.0

API Changes

• pg_fs_backup: Renamed to pg_fs_backup, default value /data/backups.
• pg_rm_bkup: Renamed to pg_rm_backup, default value true.
• pg_fs_main: Default value adjusted to /data/postgres.
• nginx_cert_validity: New parameter to control Nginx self-signed certificate validity, default 397d.
• minio_buckets: Default value adjusted to create three buckets named pgsql, meta, data.
• minio_users: Removed dba user, added s3user_meta and s3user_data users for meta and data buckets respectively.
• minio_https: New parameter to allow MinIO to use HTTP mode.
• minio_provision: New parameter to allow skipping MinIO provisioning stage (skip bucket and user creation)
• minio_safeguard: New parameter, abort minio-rm.yml when enabled
• minio_rm_data: New parameter, whether to remove minio data directory during minio-rm.yml
• minio_rm_pkg: New parameter, whether to uninstall minio package during minio-rm.yml
• etcd_learner: New parameter to control whether to init etcd instance as learner
• etcd_rm_data: New parameter, whether to remove etcd data directory during etcd-rm.yml
• etcd_rm_pkg: New parameter, whether to uninstall etcd package during etcd-rm.yml

Checksums

df64ac0c2b5aab39dd29698a640daf2e  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