Skip to content

Releases: pgsty/pigsty

v4.0.0-b3

26 Dec 15:20

Choose a tag to compare

v4.0.0-b3 Pre-release
Pre-release
curl https://pigsty.cc/get | bash

GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v4.0.0-b3

Highlights

  • Complete Infra module overhaul with Victoria Observability stack delivering 10x performance improvement!
  • Logging solution upgraded to VictoriaLogs + Vector with epic performance and usability enhancements!
  • Pigsty UI integration providing a seamless unified experience
  • Global security improvements with firewall, SELinux, and permission hardening
  • Docker container version available for quick evaluation
  • Instant database cloning capability

Software Versions

Infrastructure Packages

MinIO now uses Pigsty-maintained RPM/DEB packages:

  • victoria-metrics: 1.132.0
  • victoria-logs: 1.41.0
  • blackbox_exporter: 0.28.0
  • duckdb: 1.4.3
  • rclone: 1.72.1
  • pev2: 1.19.0
  • pg_exporter: 1.1.0
  • pig: 0.8.0
  • genai-toolbox: 0.23.0
  • minio: 20251203120000
  • uv: 0.9.18 (new package)
  • ccm (claude mgr): 2.0.76

PostgreSQL Extension Packages

  • pg_textsearch: 0.1.0 (new extension)
  • pg_clickhouse: 0.1.0 (new extension)
  • pg_ai_query: 0.1.1 (new extension)
  • timescaledb: 2.23.1 -> 2.24.0
  • pg_search: 0.20.0 -> 0.20.4
  • pg_duckdb: 1.1.0 -> 1.1.1 (official release)
  • pg_biscuit: 1.0 -> 2.0.1 (repository renamed)
  • pg_convert: 0.0.4 -> 0.0.5 (removed PG13 support)
  • pgdd: 0.6.0 -> 0.6.1 (removed PG13 support)
  • pglinter: 1.0.0 -> 1.0.1
  • pg_session_jwt: 0.3.3 -> 0.4.0
  • pg_anon: 2.4.1 -> 2.5.1
  • pg_enigma: 0.4.0 -> 0.5.0
  • wrappers: 0.5.6 -> 0.5.7
  • pg_vectorize: 0.25.0 -> 0.26.0
  • vchord_bm25: 0.2.2 -> 0.3.0
  • pg_timeseries: 0.1.7 -> 0.1.8

Fixed PG18 Deb packages: pg_vectorize, pg_tiktoken, pg_tzf, pglite_fusion, pgsmcrypto, pgx_ulid, plprql, pg_summarize, supautils

Observability

  • Replaced Prometheus with VictoriaMetrics for 10x performance with a fraction of the resources
  • New logging solution: VictoriaLogs + Vector replacing Promtail + Loki
  • Unified log format across all components, PG logs use UTC timestamps (log_timezone)
  • Adjusted PostgreSQL log rotation to weekly truncation mode
  • Log temp files larger than 1MB, enable PG17/18 log params in specific templates
  • Added Vector log parsing for Nginx Access/Error, Syslog, PG CSV, Pgbackrest
  • Datasource registration now runs on all Infra nodes, Victoria datasources auto-register in Grafana
  • New grafana_pgurl parameter to specify PostgreSQL as Grafana metadata backend
  • New grafana_view_pgpass parameter for Grafana Meta datasource password

Parameter Optimization

  • pg_io_method parameter: auto, sync, worker, io_uring options, defaults to worker
  • idle_replication_slot_timeout: default 7d, 3d for crit template
  • log_lock_failures: enabled in oltp, crit templates
  • track_cost_delay_timing: enabled in olap, crit templates
  • log_connections: auth logging for oltp/olap, full logging for crit
  • maintenance_io_concurrency set to 100 for SSD
  • effective_io_concurrency reduced from 1000 to 200
  • file_copy_method set to clone for PG18 enabling instant database cloning
  • For PG17+, explicitly disable checksums in patroni init when pg_checksums is off
  • Fixed duckdb.allow_community_extensions always being active
  • Allow specifying trusted "intranet" segments via node_firewall_intranet
  • pg_hba and pgbouncer_hba now support IPv6 localhost access

Architecture Improvements

  • Fixed /infra symlink on Infra nodes pointing to /data/infra
  • Infra data now placed in /data/infra by default for easier container usage
  • Local repo now at /data/nginx/pigsty, /www symlinks to /data/nginx for compatibility
  • DNS records placed in /infra/hosts to resolve Ansible SELinux race conditions
  • pg_remove/pg_pitr etcd metadata tasks now run on etcd cluster instead of admin_ip
  • 36-node simu template simplified to 20 nodes
  • Removed PGDG sysupdate repo and all llvmjit packages on EL systems
  • Using full OS version numbers (major.minor) for EPEL 10 / PGDG 9/10 repos
  • Allow specifying meta parameter in repo definitions to override yum repo metadata
  • Allow strategy parameter in pg_databases definitions to specify clone method
  • Add /pg/bin/pg-fork script to fork current instance with xfs reflink on same node
  • make vagrant libvirt templates has a default 128GB disk, xfs on /data.

Security Improvements

  • configure now auto-generates random strong passwords to avoid default password security risks
  • Removed node_disable_firewall, added node_firewall_mode supporting off, none, zone modes
  • Removed node_disable_selinux, added node_selinux_mode supporting disabled, permissive, enforcing
  • Added nginx basic auth support for optional HTTP Basic Auth on Nginx servers
  • Fixed ownca certificate validity to ensure Chrome recognizes self-signed certs
  • Changed MinIO module default password to avoid conflicts with well-known defaults
  • Enabled etcd RBAC, each cluster can only manage its own PostgreSQL cluster
  • etcd root password now stored in /etc/etcd/etcd.pass, readable only by admin
  • Configured proper SELinux contexts for HAProxy, Nginx, DNSMasq, Redis
  • Removed ownership of executable scripts from non-root users
  • Added admin_ip to Patroni API allowed IP whitelist
  • Always create admin system group, patronictl config restricted to admin group users
  • New node_admin_sudo parameter to specify/adjust DBA sudo permission mode (all/nopass)

Checksums

6a26fa44f90a16c7571d2aaf0e997d07  pigsty-v4.0.0.tgz
c4d870e5ef61ed05724c15fbccd1220b  pigsty-pkg-v4.0.0.d12.aarch64.tgz
f7971d9d6aab1f8f307556c2f64b701c  pigsty-pkg-v4.0.0.d12.x86_64.tgz
8d7c9404b97a11066c00eb7fc1330181  pigsty-pkg-v4.0.0.d13.aarch64.tgz
408991c5ff028b5c0a86fac804d64b93  pigsty-pkg-v4.0.0.d13.x86_64.tgz
4b98b463e2ebc104c35ddc94097e5265  pigsty-pkg-v4.0.0.el10.aarch64.tgz
a333e8eb34bf93f475c85a9652605139  pigsty-pkg-v4.0.0.el10.x86_64.tgz
66e283c9f6bfa80654f7ed3ffb9b53e5  pigsty-pkg-v4.0.0.el8.aarch64.tgz
4f62851c9d79a490d403f59deb4823f4  pigsty-pkg-v4.0.0.el8.x86_64.tgz
85687cb56517acc2dce14245452fdc05  pigsty-pkg-v4.0.0.el9.aarch64.tgz
537839201c536a1211f0b794482d733b  pigsty-pkg-v4.0.0.el9.x86_64.tgz
5c81bdaa560dad4751840dec736fe404  pigsty-pkg-v4.0.0.u22.aarch64.tgz
87bb91ef703293b6ec5b77ae3bb33d54  pigsty-pkg-v4.0.0.u22.x86_64.tgz
a4fb30148a2d363bbfd3bec0daa14ab6  pigsty-pkg-v4.0.0.u24.aarch64.tgz
2a25eff283332d9006854f36af6602b2  pigsty-pkg-v4.0.0.u24.x86_64.tgz

v4.0.0 beta2

16 Dec 14:52

Choose a tag to compare

v4.0.0 beta2 Pre-release
Pre-release
curl https://repo.pigsty.io/beta | bash

Highlights

  • Infra module completely revamped — Victoria observability stack delivers 10x performance boost!
  • Log solution upgraded to VictoriaLogs + Vector — epic performance and usability improvements!
  • Pigsty UI integrated for a cohesive user experience.
  • Global security enhancements — firewall, SELinux, permission hardening
  • Docker container version available for quick evaluation
  • Instat database clone on support fs (xfs) and pg version (18)

Software Versions

Infrastructure Packages

MinIO now uses RPM/DEB packages maintained by pgsty itself.

  • victoria-metrics : 1.132.0
  • victoria-logs : 1.41.0
  • blackbox_exporter : 0.28.0
  • duckdb : 1.4.3
  • rclone : 1.72.1
  • pev2 : 1.19.0
  • pg_exporter : 1.1.0
  • pig : 0.8.0
  • rclone : 1.72.1
  • genai-toolbox : 0.23.0
  • minio : 20251203120000

PG Extension Packages

  • pg_textsearch: 0.1.0 new extension
  • pg_clickhouse: 0.1.0 new extension
  • pg_ai_query: 0.1.1 new extension
  • timescaledb : 2.23.1 -> 2.24.0
  • pg_search : 0.20.0 -> 0.20.4
  • pg_duckdb : 1.1.0 -> 1.1.1, official release version
  • pg_biscuit : 1.0 -> 2.0.1, repository renamed
  • pg_convert : 0.0.4 -> 0.0.5, removed PG 13 support
  • pgdd : 0.6.0 -> 0.6.1, removed PG 13 support
  • pglinter : 1.0.0 -> 1.0.1
  • pg_session_jwt : 0.3.3 -> 0.4.0
  • pg_anon : 2.4.1 -> 2.5.1
  • pg_enigma : 0.4.0 -> 0.5.0
  • wrappers : 0.5.6 -> 0.5.7
  • pg_vectorize : 0.25.0 -> 0.26.0
  • vchord_bm25 : 0.2.2 -> 0.3.0
  • pg_timeseries : 0.1.7 -> 0.1.8

Fixed PG 18 Deb packages: pg_vectorize, pg_tiktoken, pg_tzf, pglite_fusion, pgsmcrypto, pgx_ulid, plprql, pg_summarize, supautils

Observability

  • Using the new VictoriaMetrics to replace Prometheus — achieving several times the performance with a fraction of the resources.
  • Using the new log collection solution: VictoriaLogs + Vector, replacing Promtail + Loki.
  • Unified log format adjustments for all components, PG logs use UTC timestamp (log_timezone)
  • Adjusted PostgreSQL log rotation method, using weekly truncated log rotation mode
  • Recording temporary file allocations over 1MB in PG logs, enabling PG 17/18 log new parameters in specific templates
  • Added Nginx Access & Error / Syslog / PG CSV / Pgbackrest vector log parsing configurations
  • Datasource registration now runs on all Infra nodes, Victoria datasources automatically registered in Grafana
  • Added grafana_pgurl parameter allowing Grafana to use PG as backend metadata storage
  • Added grafana_view_pgpass parameter to specify password used by Grafana Meta datasource

Parameter Optimization

  • pg_io_method parameter, auto, sync, worker, io_uring four options available, default worker
  • idle_replication_slot_timeout, default 7d, crit template 3d
  • log_lock_failures, oltp, crit templates enabled
  • track_cost_delay_timing, olap, crit templates enabled
  • log_connections, oltp/olap enables authentication logs, crit enables all logs.
  • maintenance_io_concurrency set to 100 if using SSD
  • effective_io_concurrency reduced from 1000 to 200
  • file_copy_method not default to clone on pg18
  • For PG17+, if pg_checksums switch is off, explicitly disable checksums during patroni cluster initialization
  • Fixed issue where duckdb.allow_community_extensions always took effect
  • Allow specifying HBA trusted "intranet segments" via node_firewall_intranet
  • pg_hba and pgbouncer_hba now support IPv6 localhost access

Architecture Improvements

  • On Infra nodes, set fixed /infra symlink pointing to Infra data directory /data/infra.
  • Infra data now defaults to /data/infra directory, making container usage more convenient.
  • Local software repo now placed at /data/nginx/pigsty, /www now a symlink to /data/nginx for compatibility.
  • DNS resolution records now placed under /infra/hosts directory, solving Ansible SELinux race condition issues
  • pg_remove/pg_pitr etcd metadata removal tasks now run on etcd cluster instead of depending on admin_ip management node
  • simplify the 36-node simu template into the 20-node version

Security Improvements

  • configure now auto-generates random strong passwords, avoiding security risks from default passwords.
  • Removed node_disable_firewall, added node_firewall_mode supporting off, none, zone three modes.
  • Removed node_disable_selinux, added node_selinux_mode supporting disabled, permissive, enforcing three modes.
  • Added nginx basic auth support, allowing optional HTTP Basic Auth for Nginx Servers.
  • Fixed ownca certificate validity issues, ensuring Chrome can recognize self-signed certificates.
  • Changed MinIO module default password to avoid conflict with well-known default passwords
  • Enabled etcd RBAC, each cluster can now only manage its own PostgreSQL database cluster.
  • etcd root password now placed in /etc/etcd/etcd.pass file, readable only by administrators
  • Configured correct SELinux contexts for HAProxy, Nginx, DNSMasq, Redis and other components
  • Revoked executable script ownership permissions from all non-root users
  • Added admin_ip to Patroni API allowed access IP whitelist
  • Always create admin system user group, patronictl config restricted to admin group users only
  • Added node_admin_sudo parameter allowing specification/adjustment of database administrator sudo permission mode (all/nopass)

Checksums

404274703384071456eda8a432259837  pigsty-v4.0.0.tgz
7ba6d2b4521ce91b9846d44ff6073735  pigsty-pkg-v4.0.0.d12.aarch64.tgz
0317d234fda2a60244388a96c85b6da4  pigsty-pkg-v4.0.0.d12.x86_64.tgz
d16e9efe883754a04a320bad7274ebd7  pigsty-pkg-v4.0.0.d13.aarch64.tgz
dda8f73ab7d6bd776c78577bd9464ee9  pigsty-pkg-v4.0.0.d13.x86_64.tgz
5e827067e4a6ce3ad4fa9dd5726e0235  pigsty-pkg-v4.0.0.el10.aarch64.tgz
f5a8581aadc3bd0ba8b75646ac23435c  pigsty-pkg-v4.0.0.el10.x86_64.tgz
2ddebcbabab3b98b3bf7c2d71810bc50  pigsty-pkg-v4.0.0.el8.aarch64.tgz
4673838efc1451f5bda036675794df5c  pigsty-pkg-v4.0.0.el8.x86_64.tgz
5e8ac0800688c1d7fe8e1c7591234ab3  pigsty-pkg-v4.0.0.el9.aarch64.tgz
959a13b03df8ca06fbdd037aa32c0b2b  pigsty-pkg-v4.0.0.el9.x86_64.tgz
b8f69e662634d980b6d8cc260c9fa3e3  pigsty-pkg-v4.0.0.u22.aarch64.tgz
dc60d79f49889e833907104c7eb4e301  pigsty-pkg-v4.0.0.u22.x86_64.tgz
d65dd8da48c0a13e08ec1940e7089cf4  pigsty-pkg-v4.0.0.u24.aarch64.tgz
4d5c6301ed134fc948da79177472a512  pigsty-pkg-v4.0.0.u24.x86_64.tgz

Pigsty v3.7.0

02 Dec 05:36

Choose a tag to compare

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:

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

24 Nov 23:29

Choose a tag to compare

v3.7.0-beta1 Pre-release
Pre-release

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

15 Aug 07:51

Choose a tag to compare

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

18 Jul 02:25

Choose a tag to compare

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

16 Jun 04:26

Choose a tag to compare

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

04 Apr 01:12

Choose a tag to compare

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

ChatGPT

v3.4.0 Better Bakcup & Auto Certs

30 Mar 03:09

Choose a tag to compare

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

24 Feb 12:56

Choose a tag to compare

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.

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