Unclaimed project
Are you a maintainer of pigsty? Claim this project to take control of your public changelog and roadmap.
Changelog
pigsty
Free & OSS PostgreSQL RDS / DBaaS, Self-Host PG like a Pro
graphicsinfrapostgresservicetoolboxyours
Last updated 6 days ago
Back to changelogNew
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 drivesNew pgactive extension for multi‑primary replication and sub‑second failoverRevised default values for pg_fs_main / pg_fs_bkup to simplify directory layout
- 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
- 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
| 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 |
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