# Pigsty v3.6.0

> pgactive, MinIO/ETCD improvements, simplified install, config cleanup

---

LLMS index: [llms.txt](/llms.txt)

---

**v3\.6\.0 · 2025-07-30**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.6.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.6.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.6.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

```bash
curl https://repo.pigsty.io/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 dedicated 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](https://github.com/IvorySQL/IvorySQL/issues/826) dependencies issues
- 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](https://github.com/tensorchord/VectorChord/releases/tag/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

```bash
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
```

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v3.6.0)
- [Pigsty v3.6 release article](https://pigsty.io/blog/pigsty/v3.6/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v360)
- [Source comparison: `v3.5.0...v3.6.0`](https://github.com/pgsty/pigsty/compare/v3.5.0...v3.6.0)
