Releases

• 1: Pigsty Release
• 2: Latest Release
• 3: Beta Release
• 4: PIG Release
• 5: PG Exporter
• 6: RPM Release
• 7: DEB Release
• 8: INFRA Release

    The latest stable version of pigsty: **v3.7.0**

    There's no active beta release now.

    Pigsty release notes of all history versions.

    `pig` the Package manager release note.

    `pg_exporter` the prometheus metrics exporter release note

    Observability and infra package release note

    PostgreSQL rpm packages change log and release notes.

    PostgreSQL deb packages change log and release notes.

1 - Pigsty Release

Pigsty v3.7.0

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.

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:

• INFRA Changelog
• RPM Changelog
• DEB Changelog

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.6.1

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

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

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

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

GitHub Release Page: 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

v3.4.0

GitHub Release Page: v3.4.0

Introduction Blog: Pigsty v3.4 MySQL Compatibility and Overall Enhancements

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

• Total available extensions increased to 404!
• PostgreSQL February Minor Updates: 17.4, 16.8, 15.12, 14.17, 13.20
• New Feature: app.yml script for auto-installing apps like Odoo, Supabase, Dify.
• New Feature: Further Nginx configuration customization in infra_portal.
• New Feature: Added Certbot support for quick free HTTPS certificate requests.
• New Feature: Pure-text extension list now supported in pg_default_extensions.
• New Feature: Default repositories now include mongo, redis, groonga, haproxy, etc.
• New Parameter: node_aliases to add command aliases for Nodes.
• Fix: Resolved default EPEL repo address issue in Bootstrap script.
• 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.
• New homepage design: Pigsty’s website now features a fresh new look.
• Extension Directory: 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.

• documentdb 0.101-0
• VectorChord-bm25 (vchord_bm25) 0.1.0
• pg_tracing 0.1.2
• pg_curl 2.4
• pgxicor 0.1.0
• pgsparql 1.0
• pgjq 0.1.0
• hashtypes 0.1.5
• db_migrator 1.0.0
• pg_cooldown 0.1
• pgcollection 0.9.1
• pg_bzip 1.0.0

Bump Extension

• 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

v3.2.2

• New Extension(s): Omnigres 33 extensions, postgres as platform
• New Extension: pg_mooncake: duckdb in postgres
• New Extensions: pg_xxhash
• New Extension: timescaledb_toolkit
• New Extension: pg_xenophile
• New Extension: pg_drop_events
• New Extension: pg_incremental
• Bump citus to 13.0.0 with PostgreSQL 17 support.
• Bump pgml to 2.10.0
• Bump pg_extra_time to 2.0.0
• Bump pg_vectorize to 0.20.0

What’s Changed

• Bump IvorySQL to 4.2 (PostgreSQL 17.2)
• Add Arm64 and Debian support for PolarDB kernel
• Add certbot and certbot-nginx to default infra_packages
• Increase pgbouncer max_prepared_statements to 256
• remove pgxxx-citus package alias
• hide pgxxx-olap category in pg_extensions by default

v3.2.1

Highlights

• 351 PostgreSQL Extensions, including the powerful postgresql-anonymizer 2.0
• IvorySQL 4.0 support for EL 8/9
• Now use the Pigsty compiled Citus, TimescaleDB and pgroonga on all distros
• Add self-hosting Odoo template and support

Bump software versions

• pig CLI 0.1.2 self-updating capability
• prometheus 3.1.0

Add New Extension

• add pg_anon 2.0.0
• add omnisketch 1.0.2
• add ddsketch 1.0.1
• add pg_duration 1.0.1
• add ddl_historization 0.0.7
• add data_historization 1.1.0
• add schedoc 0.0.1
• add floatfile 1.3.1
• add pg_upless 0.0.3
• add pg_task 1.0.0
• add pg_readme 0.7.0
• add vasco 0.1.0
• add pg_xxhash 0.0.1

Update Extension

• lower_quantile 1.0.3
• quantile 1.1.8
• sequential_uuids 1.0.3
• pgmq 1.5.0 (subdir)
• floatvec 1.1.1
• pg_parquet 0.2.0
• wrappers 0.4.4
• pg_later 0.3.0
• topn fix for deb.arm64
• add age 17 on debian
• powa + pg17, 5.0.1
• h3 + pg17
• ogr_fdw + pg17
• age + pg17 1.5 on debian
• pgtap + pg17 1.3.3
• repmgr
• topn + pg17
• pg_partman 5.2.4
• credcheck 3.0
• ogr_fdw 1.1.5
• ddlx 0.29
• postgis 3.5.1
• tdigest 1.4.3
• pg_repack 1.5.2

v3.2.0

Highlights

• New CLI: Introducing the pig command-line tool for managing extension plugins.
• ARM64 Support: 390 extensions are now available for ARM64 across five major distributions.
• Supabase Update: Latest Supabase Release Week updates are now supported for self-hosting on all distributions.
• Grafana v11.4: Upgraded Grafana to version 11.4, featuring a new Infinity datasource.

Package Changes

• New Extensions
• Added timescaledb, timescaledb-loader, timescaledb-toolkit, and timescaledb-tool to the PIGSTY repository.
• Added a custom-compiled pg_timescaledb for EL.
• Added pgroonga, custom-compiled for all EL variants.
• Added vchord 0.1.0.
• Added pg_bestmatch.rs 0.0.1.
• Added pglite_fusion 0.0.3.
• Added pgpdf 0.1.0.
• Updated Extensions
• pgvectorscale: 0.4.0 → 0.5.1
• pg_parquet: 0.1.0 → 0.1.1
• pg_polyline: 0.0.1
• pg_cardano: 1.0.2 → 1.0.3
• pg_vectorize: 0.20.0
• pg_duckdb: 0.1.0 → 0.2.0
• pg_search: 0.13.0 → 0.13.1
• aggs_for_vecs: 1.3.1 → 1.3.2
• Infrastructure
• Added promscale 0.17.0
• Added grafana-plugins 11.4
• Added grafana-infinity-plugins
• Added grafana-victoriametrics-ds
• Added grafana-victorialogs-ds
• vip-manager: 2.8.0 → 3.0.0
• vector: 0.42.0 → 0.43.0
• grafana: 11.3 → 11.4
• prometheus: 3.0.0 → 3.0.1 (package name changed from prometheus2 to prometheus)
• nginx_exporter: 1.3.0 → 1.4.0
• mongodb_exporter: 0.41.2 → 0.43.0
• VictoriaMetrics: 1.106.1 → 1.107.0
• VictoriaLogs: 1.0.0 → 1.3.2
• pg_timetable: 5.9.0 → 5.10.0
• tigerbeetle: 0.16.13 → 0.16.17
• pg_export: 0.7.0 → 0.7.1
• New Docker App
• Add mattermost the open-source Slack alternative self-hosting template
• Bug Fixes
• Added python3-cdiff for el8.aarch64 to fix missing Patroni dependency.
• Added timescaledb-tools for el9.aarch64 to fix missing package in official repo.
• Added pg_filedump for el9.aarch64 to fix missing package in official repo.
• Removed Extensions
• pg_mooncake: Removed due to conflicts with pg_duckdb.
• pg_top: Removed because of repeated version issues and quality concerns.
• hunspell_pt_pt: Removed because of conflict with official PG dictionary files.
• pgml: Disabled by default (no longer downloaded or installed).

API Changes

• repo_url_packages now defaults to an empty array; packages are installed via OS package managers.
• grafana_plugin_cache is deprecated; Grafana plugins are now installed via OS package managers.
• grafana_plugin_list is deprecated for the same reason.
• The 36-node “production” template has been renamed to simu.
• Auto-generated code under node_id/vars now includes aarch64 support.
• infra_packages now includes the pig CLI tool.
• The configure command now updates the version numbers of pgsql-xxx aliases in auto-generated config files.
• Update terraform templates with Makefile shortcuts and better provision experience

Bug Fix

• Fix pgbouncer dashboard selector issue #474
• Add --arg value support for pg-pitr by @waitingsong
• Fix redis log message typo by @waitingsong

Checksums

c42da231067f25104b71a065b4a50e68  pigsty-pkg-v3.2.0.d12.aarch64.tgz
ebb818f98f058f932b57d093d310f5c2  pigsty-pkg-v3.2.0.d12.x86_64.tgz
d2b85676235c9b9f2f8a0ad96c5b15fd  pigsty-pkg-v3.2.0.el9.aarch64.tgz
649f79e1d94ec1845931c73f663ae545  pigsty-pkg-v3.2.0.el9.x86_64.tgz
24c0be1d8436f3c64627c12f82665a17  pigsty-pkg-v3.2.0.u22.aarch64.tgz
0b9be0e137661e440cd4f171226d321d  pigsty-pkg-v3.2.0.u22.x86_64.tgz
8fdc6a60820909b0a2464b0e2b90a3a6  pigsty-v3.2.0.tgz

v3.1.0

2024-11-24 : ARM64 & Ubuntu24, PG17 by Default, Better Supabase & MinIO https://github.com/pgsty/pigsty/releases/tag/v3.1.0

v3.0.4

2024-10-28 : PostgreSQL 17 Extensions, Better self-hosting Supabase

https://github.com/pgsty/pigsty/releases/tag/v3.0.4

v3.0.3

2024-09-27 : PostgreSQL 17, Etcd Enhancement, IvorySQL 3.4,PostGIS 3.5

https://github.com/pgsty/pigsty/releases/tag/v3.0.3

v3.0.2

2024-09-07 : Mini Install, PolarDB 15, Bloat View Update

https://github.com/pgsty/pigsty/releases/tag/v3.0.2

v3.0.1

2024-08-31 : Oracle Compatibility, Patroni 4.0, Routine Bug Fix

https://github.com/pgsty/pigsty/releases/tag/v3.0.1

v3.0.0

2024-08-30 : Extension Exploding & Plugable Kernels (MSSQL,Oracle)

https://github.com/pgsty/pigsty/releases/tag/v3.0.0

v2.7.0

2024-05-16 : Extension Overwhelming, new docker apps

https://github.com/pgsty/pigsty/releases/tag/v2.7.0

v2.6.0

2024-02-29 : PG 16 as default version, ParadeDB & DuckDB

https://github.com/pgsty/pigsty/releases/tag/v2.6.0

v2.5.1

2023-12-01 : Routine update, pg16 major extensions

https://github.com/pgsty/pigsty/releases/tag/v2.5.1

v2.5.0

2023-10-24 : Ubuntu/Debian Support: bullseye, bookworm, jammy, focal

https://github.com/pgsty/pigsty/releases/tag/v2.5.0

v2.4.1

2023-09-24 : Supabase/PostgresML support, graphql, jwt, pg_net, vault

https://github.com/pgsty/pigsty/releases/tag/v2.4.1

v2.4.0

2023-09-14 : PG16, RDS Monitor, New Extensions

https://github.com/pgsty/pigsty/releases/tag/v2.4.0

v2.3.1

2023-09-01 : PGVector with HNSW, PG16 RC1, Chinese Docs, Bug Fix

https://github.com/pgsty/pigsty/releases/tag/v2.3.1

v2.3.0

2023-08-20 : PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub

https://github.com/pgsty/pigsty/releases/tag/v2.3.0

v2.2.0

2023-08-04 : Dashboard & Provision overhaul, UOS compatibility

https://github.com/pgsty/pigsty/releases/tag/v2.2.0

v2.1.0

2023-06-10 : PostgreSQL 12 ~ 16beta support

https://github.com/pgsty/pigsty/releases/tag/v2.1.0

v2.0.2

2023-03-31 : Add pgvector support and fix MinIO CVE

https://github.com/pgsty/pigsty/releases/tag/v2.0.2

v2.0.1

2023-03-21 : v2 Bug Fix, security enhance and bump grafana version

https://github.com/pgsty/pigsty/releases/tag/v2.0.1

v2.0.0

2023-02-28 : Compatibility Security Maintainability Enhancement

https://github.com/pgsty/pigsty/releases/tag/v2.0.0

v1.5.1

2022-06-18 : Grafana Security Hotfix

https://github.com/pgsty/pigsty/releases/tag/v1.5.1

v1.5.0

2022-05-31 : Docker Applications

https://github.com/pgsty/pigsty/releases/tag/v1.5.0

v1.4.1

2022-04-20 : Bug fix & Full translation of English documents.

https://github.com/pgsty/pigsty/releases/tag/v1.4.1

v1.4.0

2022-03-31 : MatrixDB Support, Separated INFRA, NODES, PGSQL, REDIS

https://github.com/pgsty/pigsty/releases/tag/v1.4.0

v1.3.0

2021-11-30 : PGCAT Overhaul & PGSQL Enhancement & Redis Support Beta

https://github.com/pgsty/pigsty/releases/tag/v1.3.0

v1.2.0

2021-11-03 : Upgrade default Postgres to 14, monitoring existing pg

https://github.com/pgsty/pigsty/releases/tag/v1.2.0

v1.1.0

2021-10-12 : HomePage, JupyterLab, PGWEB, Pev2 & Pgbadger

https://github.com/pgsty/pigsty/releases/tag/v1.1.0

v1.0.0

2021-07-26 : v1 GA, Monitoring System Overhaul

https://github.com/pgsty/pigsty/releases/tag/v1.0.0

v0.9.0

2021-04-04 : Pigsty GUI, CLI, Logging Integration

https://github.com/pgsty/pigsty/releases/tag/v0.9.0

v0.8.0

2021-03-28 : Service Provision

https://github.com/pgsty/pigsty/releases/tag/v0.8.0

v0.7.0

2021-03-01 : Monitor only deployment

https://github.com/pgsty/pigsty/releases/tag/v0.7.0

v0.6.0

2021-02-19 : Architecture Enhancement

https://github.com/pgsty/pigsty/releases/tag/v0.6.0

v0.5.0

2021-01-07 : Database Customize Template

https://github.com/pgsty/pigsty/releases/tag/v0.5.0

v0.4.0

2020-12-14 : PostgreSQL 13 Support, Official Documentation

https://github.com/pgsty/pigsty/releases/tag/v0.4.0

v0.3.0

2020-10-22 : Provisioning Solution GA

https://github.com/pgsty/pigsty/releases/tag/v0.3.0

v0.2.0

2020-07-10 : PGSQL Monitoring v6 GA

https://github.com/pgsty/pigsty/commit/385e33a62a19817e8ba19997260e6b77d99fe2ba

v0.1.0

2020-06-20 : Validation on Testing Environment

https://github.com/pgsty/pigsty/commit/1cf2ea5ee91db071de00ec805032928ff582453b

v0.0.5

2020-08-19 : Offline Installation Mode

https://github.com/pgsty/pigsty/commit/0fe9e829b298fe5e56307de3f78c95071de28245

v0.0.4

2020-07-27 : Refactor playbooks into ansible roles

https://github.com/pgsty/pigsty/commit/90b44259818d2c71e37df5250fe8ed1078a883d0

v0.0.3

2020-06-22 : Interface enhancement

https://github.com/pgsty/pigsty/commit/4c5c68ccd57bc32a9e9c98aa3f264aa19f45c7ee

v0.0.2

2020-04-30 : First Commit

https://github.com/pgsty/pigsty/commit/dd646775624ddb33aef7884f4f030682bdc371f8

v0.0.1

2019-05-15 : POC

https://github.com/Vonng/pg/commit/fa2ade31f8e81093eeba9d966c20120054f0646b

2 - Latest Release

Pigsty v3.7.0

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:

• INFRA Changelog
• RPM Changelog
• DEB Changelog

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

3 - Beta Release

Note: There is currently no active Beta version available, as the latest stable release, v3.7.0, has just been published.

This historical freeze had no active beta. Use the version-pinned v3.7.0 installer from the latest-release page.

4 - PIG Release

pig is an open-source PostgreSQL (& Extension) Package Manager for Mainstream Linux.

Install PostgreSQL 13 ~ 18 along with 437 extensions on (amd64 / arm64) with native apt/yum/dnf.

The latest stable version is v0.7.4, Check the GitHub Repo and pig documentation for more details.

v0.7.4

• Update extension metadata: pg_search, pgmq, pg_stat_monitor
• Update pgdg repo URL, the extras now move to parent directory
• Bump ivorysql to 5.0 (compatible with PG 18.0)
• Bump Percona Postgres TDE Kernel to 18.1

Checksums

5769b0051f04dcda22dd92b30b8effc8ddfa40097308bded76ce2b38d012ce57  pig-0.7.4-1.aarch64.rpm
d15c829fa2e3ce8dcd1adc063c107607b8e70f2cf747646aaa2fa257cdbf979c  pig-0.7.4-1.x86_64.rpm
bb4c90e253a3d470e50316e633a41e90ed2d4a5c5a1fd3a8dbb68ee87d831d47  pig-v0.7.4.darwin-amd64.tar.gz
faaf7ac7b08390f5048c081bb7a78100714387e35dc890e26d9746fc1caef415  pig-v0.7.4.darwin-arm64.tar.gz
037cacddd0dc1283f13dd2c9bace87ad7f2c74ffc245e629f1420be94bbf93df  pig-v0.7.4.linux-amd64.tar.gz
2ce819b2c3686cfb9f86790fdf61acd30bf7798bd6cd3c4f589df22e273dc867  pig-v0.7.4.linux-arm64.tar.gz
97f62d62f1cca61ce6d335efed88e3855d94ea2cd4ed941f2755fbac73931fcd  pig_0.7.4-1_amd64.deb
d2b80af89ed42601716f6b41eda3f8bee16db34023527df9deef8a43aa25a498  pig_0.7.4-1_arm64.deb

v0.7.3

• add new command: pig repo reload to update repo.yml
• fix EL PGDG sysupdate aarch64 repo issue (now aarch64 repo ready)
• fix EL10.aarch64 PGDG repo issue (rhel-10-aarch64 to rhel-10.0-aarch64)
• update extension version and meta data
• bump Pigsty version to 3.7.0

Checksums

786d72f6b685d6d6abf5f255f0a7de9204988a05630a26a53bfc7631823c0c6f  pig-0.7.3-1.aarch64.rpm
da59e24ef79d1164e348bacc43e3222e8e2778ec0e103e7ffc0c6df064758e8f  pig-0.7.3-1.x86_64.rpm
73062a979749095e89abc07dd583d34d4f57908bb4ee935cf7640f129ca6a2cb  pig-v0.7.3.darwin-amd64.tar.gz
ca5f5576f6d0d9be1d10cad769821be9daa62220b2fb56b94d6e4c0cede6da61  pig-v0.7.3.darwin-arm64.tar.gz
d193b4b87cf9a6e4775b1b07709802d30f0233ccb1b728843a09decb545168d3  pig-v0.7.3.linux-amd64.tar.gz
e7f612df0e8e4d9fac6df3765862b9e491bb50aad651856abf7a6935986e6f99  pig-v0.7.3.linux-arm64.tar.gz
3d5306ce95dcf704dd498b05325d942637564b13115f1e5a5bb9ef6781df1ba6  pig_0.7.3-1_amd64.deb
32e695ba2d49a741d8cd92008f8f2dec29f10754d35b732035f48517b382c30d  pig_0.7.3-1_arm64.deb

v0.7.2

• Extension list update, + 6 new extensions, 437 total
• Add PGDG EL10 Sysupdate repo
• Add LLVM APT repo
• use local extension.csv catalog in pig build sub command
• update: vchord pg_later pgvectorscale pglite_fusion pgx_ulid pg_search citus timescaledb pg_profile pg_stat_monitor documentdb
• new: pglinter pg_typeid pg_enigma pg_retry pg_biscuit pg_weighted_statistics

Checksums

f303c391fc28bc74832712e0aa58319abe0ebcae4f6c07fdf9a9e542b735d2ec  pig-0.7.2-1.aarch64.rpm
c096a61a4e3a49b1238659664bbe2cd7f29954c43fb6bb8e8e9fb271f95a612e  pig-0.7.2-1.x86_64.rpm
5e037c891dff23b46856485108d6f64bede5216dfbd4f38a481f0d0672ee910b  pig-v0.7.2.darwin-amd64.tar.gz
736b4b47999c543c3c886781f4d8dddbf4276f363c35c7bf50094b6f18d14600  pig-v0.7.2.darwin-arm64.tar.gz
20b13f059efed29dd76f6927b3e8d7b597c0c8d734f9e22ba3d0a2af6dbcd3bf  pig-v0.7.2.linux-amd64.tar.gz
9548b530c05f2ffdc8d73b8f890718d47b74a51eb62852a99c08b1b52e47f014  pig-v0.7.2.linux-arm64.tar.gz
b6faad9f92b926546a10f590274f2cb2afff21b9cea878094cfc5caf09e67d2c  pig_0.7.2-1_amd64.deb
452f73f1fa035e5417ab49fc51d797925550179ffcc023e8f03d80144309212a  pig_0.7.2-1_arm64.deb

v0.7.1

• The brand-new website: https://pgext.cloud
• remove unnecessary sudo usage, now can be used inside docker
• allow using pg18, pg17 arg format in pig ext link command
• add environment var PIG_NO_SUDO to force not using sudo
• RPM Changelog: Add PG 18 support to almost all extensions
• DEB Changelog: Add PG 18 support to almost all extensions
• Infra Changelog: Routine update to the latest version

Checksums

a696c9ec784e2fc248e5f3d87cc8aae4116e890f78c5997957d30593f2c85ca6  pig-0.7.1-1.aarch64.rpm
f669538a99cd1dc592d3005b949628fcceb9e78114fc78862d7726b340ee194d  pig-0.7.1-1.x86_64.rpm
e42bdaaf93b720c5b76b32b57362320e4b447109740c76089aefe030b7c8b836  pig-v0.7.1.darwin-amd64.tar.gz
b4c240aadad34e785666ee0a755d9b7455724f790c2d088a1dd7c37ad3b2a457  pig-v0.7.1.darwin-arm64.tar.gz
ffc687add0ca71ac90cba5749c8a7a6075cf7618cba85584072831cf3eb182f7  pig-v0.7.1.linux-amd64.tar.gz
7b0d1f158150d0a40c525692f02b6bce9f5b4ac523a4e59278d702c334e222e1  pig-v0.7.1.linux-arm64.tar.gz
43e91a3bea273d7cacb2d7a58c0a5745501dbd06348b5cb3af971171fae70268  pig_0.7.1-1_amd64.deb
fc2a34aeb46e07cb0ae93611de47d6622c3bd46fe4c415ce4c9091840e0e08a2  pig_0.7.1-1_arm64.deb

v0.7.0

• Bump tons of extension to the latest version, with pg 18 support.
• Most rust extension are bump to the latest pgrx 0.16.1
• pig build overhaul
  • pig build pkg <pkg> will download source, prepare deps, and build rpm/deb
  • pig build pgrx is separated from pig build rust with its own subcommand
  • pig build pgrx [-v pgrx_version] now can scan existing pg and init with them
  • pig build dep will now process EL rpm spec dependencies directly
  • pig build ext will now build EL rpm spec directly without the build script
  • pig build spec now support downloading spec files directly from pigsty repo
  • pig build repo / pig repo add / pig repo set will now using node,pgsql,infra as default repo modules instead of previous node,pgdg,pigsty
• Optimized error logging
• Reworked catalog website based on hugo and hextra

Checksums

ad60f9abcde954769e46eb23de61965e  pig_0.7.0-1_amd64.deb
aa15d7088d561528e38b2778fe8f7cf9  pig_0.7.0-1_arm64.deb
05549fe01008e04f8d5a59d4f2a5f0b8  pig-0.7.0-1.aarch64.rpm
0cc9e46c7c72d43c127a6ad115873b67  pig-0.7.0-1.x86_64.rpm
ddacfb052f3f3e5567a02e92fdb31cdd  pig-v0.7.0.darwin-amd64.tar.gz
17d25b565308d3d35513e4b0d824946b  pig-v0.7.0.darwin-arm64.tar.gz
ee7e055ceff638039956765fb747f80b  pig-v0.7.0.linux-amd64.tar.gz
284e674807b87447d4b33691fd7a420d  pig-v0.7.0.linux-arm64.tar.gz

v0.6.2

• Use official PG 18 repo instead of testing repo
• Add v prefix when specify pigsty version string
• Improved network connectivity check

Checksums

01f5b7dc20644226c762dbb229768347  pig_0.6.2-1_amd64.deb
ce4f00256adc12cbea91467b7f2241cd  pig_0.6.2-1_arm64.deb
cefc36ae8f348aede533b30836fba720  pig-0.6.2-1.aarch64.rpm
d04a287c6eb92b11ecbf99542c2db602  pig-0.6.2-1.x86_64.rpm
e637ca86a7f38866c67686b060223d9a  pig-v0.6.2.darwin-amd64.tar.gz
79749bc69c683586bd8d761bdf6af98e  pig-v0.6.2.darwin-arm64.tar.gz
ad4f02993c7d7d8eec142f0224551bb4  pig-v0.6.2.linux-amd64.tar.gz
9793affa4a0cb60e9753e65b7cba3dca  pig-v0.6.2.linux-arm64.tar.gz

v0.6.1

• Add el10 and debian 13 trixie support stub
• Dedicate website: https://pgext.cloud/pig
• rebuild with go 1.25 and CI/CD pipeline
• Use the PIGSTY mirror in mainland china due to pgdg ftp rsync mirror break
• Remove unused pgdg-el10fix repo
• Use pigsty mirror for WiltonDB
• Add EL 10 dedicate epel repo (with minor suffix)
• pig version output with go build environment

v0.6.0

• New extension catalog: https://pgext.cloud
• New subcommand: pig install to simplify pig ext install
• Add new kernel support: percona with pg_tde
• Add new package: Google GenAI MCP toolbox for databases
• Add new repo: percona repo and clickhouse repo
• Change extension summary info links to https://pgext.cloud
• fix orioledb broken on the Debian/Ubuntu system
• fix epel repo on EL distributions
• Bump golang to 1.24.5
• Bump pigsty to v3.6.0

Checksums

1804766d235b9267701a08f95903bc3b  pig_0.6.0-1_amd64.deb
35f4efa35c1eaecdd12aa680d29eadcb  pig_0.6.0-1_arm64.deb
b523b54d9f2d7dcc5999bcc6bd046b1d  pig-0.6.0-1.aarch64.rpm
9434d9dca7fd9725ea574c5fae1a7f52  pig-0.6.0-1.x86_64.rpm
f635c12d9ad46a779aa7174552977d11  pig-v0.6.0.linux-amd64.tar.gz
165af4e63ec0031d303fe8b6c35c5732  pig-v0.6.0.linux-arm64.tar.gz

v0.5.0

• Update the extension list to 422
• New extension: pgactive from AWS
• bump timescaledb to 2.20.3
• bump citus to 13.1.0
• bump vchord to 0.4.3
• bug fix pgvectorscale debian/ubuntu pg17 failure
• bump kubernetes repo to 1.33
• bump default pigsty version to 3.5.0

Checksums

9ec6f3caf3edbe867caab5de0e0ccb33  pig_0.5.0-1_amd64.deb
4fbb0a42cd8a88bce50b3c9d85745d77  pig_0.5.0-1_arm64.deb
9cf8208396b068cab438f72c90d39efe  pig-0.5.0-1.aarch64.rpm
d9a8d78c30f45e098b29c3d16471aa8d  pig-0.5.0-1.x86_64.rpm
761df804ff7b83965c41492700717674  pig-v0.5.0.linux-amd64.tar.gz
5d1830069d98030728f08835f883ea39  pig-v0.5.0.linux-arm64.tar.gz

Release: https://github.com/pgsty/pig/releases/tag/v0.5.0

v0.4.2

• Update the extension list to 421
• Add openhalo/orioledb support for Debian / Ubuntu
• 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)
• pg_ivm 1.11.0 for debian/ubuntu
• orioledb 1.4.0 beta11
• Add el7 repo back

Checksums

bbf83fa3e3ec9a4dca82eeed921ae90a  pig_0.4.2-1_amd64.deb
e45753335faf80a70d4f2ef1d3100d72  pig_0.4.2-1_arm64.deb
966d60bbc2025ba9cc53393011605f9f  pig-0.4.2-1.aarch64.rpm
1f31f54da144f10039fa026b7b6e75ad  pig-0.4.2-1.x86_64.rpm
1eec26c4e69b40921e209bcaa4fe257a  pig-v0.4.2.linux-amd64.tar.gz
768d43441917a3625c462ce9f2b9d4ef  pig-v0.4.2.linux-arm64.tar.gz

Release: https://github.com/pgsty/pig/releases/tag/v0.4.2

v0.4.1

• Update the extension list to 414
• add citus_wal2json and citus_pgoutput to pig ext scan mapping
• Add PG 18 beta repo
• Add PG 18 package alias

Extension Package Updates

• omnigres 20250507
• citus 12.0.3
• timescaledb 2.19.3
• supautils 2.9.1
• 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 (0.12.9)
• pgvectorscale 0.7.1 (pgrx 0.12.9)
• pg_session_jwt 0.3.1 (pgrx 0.12.6) -> 0.12.9

Checksums

e2c1037c20f97c6f5930876ee82b6392  pig_0.4.1-1_amd64.deb
8197b6b5b95d1d1ae95e0a0e50355ecb  pig_0.4.1-1_arm64.deb
9d3a261d31c92fc73fe5bbfcd5b8e8ba  pig-0.4.1-1.aarch64.rpm
ffcec2a2ae965d14b9d3d80278fd340c  pig-0.4.1-1.x86_64.rpm
01d3128e782f35a20f0c81480cbe9025  pig-v0.4.1.linux-amd64.tar.gz
b2655628df326a1d0ed13f3dd8762c65  pig-v0.4.1.linux-arm64.tar.gz

Release: https://github.com/pgsty/pig/releases/tag/v0.4.1

v0.4.0

• Updated extension list, available extensions reached 407
• Added pig do subcommand for executing Pigsty playbook tasks
• Added pig pt subcommand for wrapping Patroni command-line tools
• Added extension aliases: openhalo and orioledb
• Added gitlab-ce / gitlab-ee repository distinction
• Built with the latest Go 1.24.2 and upgraded dependency versions
• Fixed pig ext status panic issue under specific conditions
• Fixed pig ext scan unable to match several extensions

Extension Package Updates

• Updated pg_search to 0.15.13
• Updated citus to 13.0.3
• Updated timescaledb to 2.19.1
• Updated pgcollection RPM to 1.0.0
• Updated pg_vectorize RPM to 0.22.1
• Updated pglite_fusion RPM to 0.0.4
• Updated aggs_for_vecs RPM to 1.4.0
• Updated pg_tracing RPM to 0.1.3
• Updated pgmq RPM to 1.5.1

Checksums

bbc0adf94b342ac450c7999ea1c5ab76  pig_0.4.0-1_amd64.deb
7445b819624e7498b496edb12a36f426  pig_0.4.0-1_arm64.deb
835ce929afac0fb1f249f55571fbed97  pig-0.4.0-1.aarch64.rpm
25ba5a846095e17d2bfa2f15fe4e4b44  pig-0.4.0-1.x86_64.rpm
1568b163ffa23cb921ee439452ca4de9  pig-v0.4.0.linux-amd64.tar.gz
9f2ab3f5d1e29807a9642dfbe1dc9b0e  pig-v0.4.0.linux-arm64.tar.gz

Release: https://github.com/pgsty/pig/releases/tag/v0.4.0

v0.3.4

curl https://repo.pigsty.io/pig | bash -s 0.3.4

• routine extension metadata update
• use aliyun epel mirror instead of broken tsinghua tuna mirror
• bump pigsty version string
• add gitlab repo to the repo list

Checksums

5c0bba04d955bbe6a29d24d31aa17c6b  pig-0.3.4-1.aarch64.rpm
42636b9fc64d7882391d856d36d715e7  pig-0.3.4-1.x86_64.rpm
1a6296421d642000ad75a5a41bc9ab96  pig-v0.3.4.linux-amd64.tar.gz
f7ea5ba8abaa89e866811e5b2508e82f  pig-v0.3.4.linux-arm64.tar.gz
2dd63cdb5965f78a48da462a0453001d  pig_0.3.4-1_amd64.deb
094b9e028e81c46d71ee315d8a223ada  pig_0.3.4-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.3.4

v0.3.3

• add pig build dep command to install extension build dependencies
• update default repo list
• use pigsty.io mirror for mssql module (wiltondb/babelfish)
• merge docker module into infra
• remove pg16/17 from el7 target
• allow installing extensions in el7
• update package alias
• pgsql, pgsql-main, pgsql-core, pgsql-mini, pgsql-full
• ivorysql now maps to ivorysql4
• timescaledb-utils
• pgbackrest_exporter
• remove pgsql-simple
• Pulls #13 Bump github.com/golang-jwt/jwt/v5 from 5.2.1 to 5.2.2
• Bump polardb to 15.12.3.0-e1e6d85b
• pig repo set now will auto update the meta-cache
• clean up embedded pigsty tarball

What’s Changed

• Bump github.com/golang-jwt/jwt/v5 from 5.2.1 to 5.2.2 by @dependabot in https://github.com/pgsty/pig/pull/13

New Contributors

• @dependabot made their first contribution in https://github.com/pgsty/pig/pull/13

Full Changelog: https://github.com/pgsty/pig/compare/v0.3.2...v0.3.3

Release: https://github.com/pgsty/pig/releases/tag/v0.3.3

Checksums

4e10567077e5d8cefd94d1c7aeb9478b  pig-0.3.3-1.aarch64.rpm
cc8a423abeb0f5316b427097993b9c6e  pig-0.3.3-1.x86_64.rpm
835d4f63b4ee0b36e2322a4ffef6527a  pig-v0.3.3.linux-amd64.tar.gz
c43e082c661e75d91f1c726e60911ea3  pig-v0.3.3.linux-arm64.tar.gz
938db83c5ca065419b8185adb285ed5a  pig_0.3.3-1_amd64.deb
75af6731adc4d31aa3458d70fc7f4e42  pig_0.3.3-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.3.3

v0.3.2

Enhancement

• new extensions
• use upx to reduce binary size
• remove embeded pigsty to reudce binary size
• allow specifiy -y to force re-install rust in pig build rust
• allow specifiy -v to specifiy pgrx version to be installed

New Extensions

List of 405 PG extensions:

• apache age 13 - 17 el rpm (1.5.0)
• pgspider_ext 1.3.0 (new extension)
• 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
• fix ddl_historization ver 0.7 -> 0.0.7
• fix pg_sqlog 3.1.7 -> 1.6
• fix pg_random remove dev suffix
• asn1oid 1.5 -> 1.6
• table_log 0.6.1 -> 0.6.4

Checksums

f773aedf4a76d031f411cb38bc623134  pig-0.3.2-1.aarch64.rpm
fa9084877deb57d4882b7d9531ea0369  pig-0.3.2-1.x86_64.rpm
7f9a03c9dd23cba094191a8044fa0263  pig-v0.3.2.linux-amd64.tar.gz
adda8986efc048565834cda1ef206a20  pig-v0.3.2.linux-arm64.tar.gz
5b27cefdc716629db8f1fbc534f58691  pig_0.3.2-1_amd64.deb
936e85bda5818da4c20b758ebd65e618  pig_0.3.2-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.3.2

v0.3.1

Routine bugfix

• fix repo format string
• fix ext info links
• update pg_mooncake metadata

Checksums

9251aa18e663f1ecf239adcba3a798b9  pig-0.3.1-1.aarch64.rpm
3b91e7faa78c5f0283d27ffe632dda46  pig-0.3.1-1.x86_64.rpm
87c75dfd114252230c53ee8c5d60dac4  pig-v0.3.1.linux-amd64.tar.gz
82832ae767e226627087b97a87982daf  pig-v0.3.1.linux-arm64.tar.gz
4d99f9c03915accf413b6374b75f1bdb  pig_0.3.1-1_amd64.deb
e38e8a21ed73a37d4588053f8c900f7c  pig_0.3.1-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.3.1

v0.3.0

The pig project now has a new homepage, alone with the PostgreSQL Extension Catalog.

curl https://repo.pigsty.io/pig | bash    # cloudflare
curl https://repo.pigsty.cc/pig | bash    # china cdn

You can install PostgreSQL Kernels along with & 404 extensions with a simple command. Besides, pig v0.3 is also embedded & shipped with the latest Pigsty v3.3.0.

New Features

pig build subcommand with the ability to set up extension building environment

pig build repo     # init build repo (=repo set -ru)
pig build tool     # init build toolset
pig build rust     # init rustc & pgrx (0.12.9)
pig build spec     # init rpm/deb spec repo
pig build get      # get extension src tarball
pig build ext      # build extension
## download big tarball
pig build get std          # download std small tarball
pig build get all          # download all source tarball
pig build get pg_mooncake
pig build get pg_duckdb
pig build get omnigres
pig build get plv8
pig build get citus

pig build ext citus
pig build ext timescaledb

And other utils such as building proxy:

pig build proxy                  # install v2ray proxy
pig build proxy [user@host:port] # init & setup proxy

And pig 0.3.0 is shipped with Pigsty 3.3.0

New Extensions

The pgext.cloud catalog is moving to https://pgext.cloud with more information!

Checksums

9cc3848ab13c41a0415f1fea6294ad2d  pig-0.3.0-1.aarch64.rpm
ee99a6c1ff17975ed184f009a4b1aac5  pig-0.3.0-1.x86_64.rpm
b06f6b5aeaa83a9d76c9b563b2516e1c  pig-v0.3.0.linux-amd64.tar.gz
d783732413e4f32074adeab2d5d092c3  pig-v0.3.0.linux-arm64.tar.gz
7c942b8dbd78458d5371c1abca2571c6  pig_0.3.0-1_amd64.deb
c0a411cf53cb58706ca81b49b4fc840e  pig_0.3.0-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.3.0

v0.2.2

404 Extensions Available in Pig v0.2.2

curl https://repo.pigsty.io/pig | bash -s v0.2.2

• documentdb 0.101-0
• pgcollection (new) 0.9.1
• pg_bzip (new) 1.0.0
• pg_net 0.14.0 (some distro)
• pg_curl 2.4.2
• vault 0.3.1 (SQL -> C)
• table_version 1.10.3 -> 1.11.0
• pg_duration 1.0.2
• timescaledb 2.18.2
• pg_analytics 0.3.4
• pg_search 0.15.2
• pg_graphql 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
• pg_duckdb 0.2.0 -> 0.3.1
• pgddl 0.29
• pgsql_tweaks 0.11.0

Release: https://github.com/pgsty/pig/releases/tag/v0.2.2

v0.2.0

Install the latest pig version with:

curl -fsSL https://repo.pigsty.io/pig | bash

New Extensions

• pg_documentdb_core, and ferretdb
• VectorChord-bm25 (vchord_bm25) 0.1.0
• pg_tracing 0.1.2
• pg_curl 2.4
• pgxicor 0.1.0
• pgsparql 1.0
• pgjq 0.1.0
• hashtypes 0.1.5
• db_migrator 1.0.0
• pg_cooldown 0.1

Update Extension Version

• citus 13.0.0 -> 13.0.1
• pg_mooncake 0.1.0 -> 0.1.1
• timescaledb 2.17.2 -> 2.18.1
• supautils 2.5.0 -> 2.6.0
• VectorChord 0.1.0 -> 0.2.0
• pg_bulkload 3.1.22 (+pg17)
• pg_store_plan 1.8 (+pg17)
• pg_search 0.14 -> 0.15.1
• pg_analytics 0.3.0 -> 0.3.2
• pgroonga 3.2.5 -> 4.0.0
• zhparser 2.2 -> 2.3
• pg_vectorize 0.20.0 -> 0.21.1

Release: https://github.com/pgsty/pig/releases/tag/v0.2.0

v0.1.4

Install the latest pig version with:

curl -fsSL https://repo.pigsty.io/pig | bash

New Extensions

• pg_documentdb_core, and ferretdb
• VectorChord-bm25 (vchord_bm25) 0.1.0
• pg_tracing 0.1.2
• pg_curl 2.4
• pgxicor 0.1.0
• pgsparql 1.0
• pgjq 0.1.0
• hashtypes 0.1.5
• db_migrator 1.0.0
• pg_cooldown 0.1

Update Extension Version

• citus 13.0.0 -> 13.0.1
• pg_mooncake 0.1.0 -> 0.1.1
• timescaledb 2.17.2 -> 2.18.1
• supautils 2.5.0 -> 2.6.0
• VectorChord 0.1.0 -> 0.2.0
• pg_bulkload 3.1.22 (+pg17)
• pg_store_plan 1.8 (+pg17)
• pg_search 0.14 -> 0.15.1
• pg_analytics 0.3.0 -> 0.3.2
• pgroonga 3.2.5 -> 4.0.0
• zhparser 2.2 -> 2.3
• pg_vectorize 0.20.0 -> 0.21.1

Checksums

6da06705be1c179941327c836d455d35  pig-0.1.4-1.aarch64.rpm
9fa5712e3cfe56e0dcf22a11320b01b1  pig-0.1.4-1.x86_64.rpm
af506dc37f955a7a2e31ff11e227450c  pig-v0.1.4.linux-amd64.tar.gz
1e6eb3dc1ad26f49b07afabdd9142d4e  pig-v0.1.4.linux-arm64.tar.gz
83ae89b58bff003da5c3022eeac1786e  pig_0.1.4_amd64.deb
d6778e628d82bddf3fae1e058e1e05e4  pig_0.1.4_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.1.4

v0.1.3

v0.1.3, routine update, with 390 extensions available now!

• New Extension(s): Omnigres 33 extensions, postgres as platform
• New Extension: pg_mooncake: duckdb in postgres
• New Extensions: pg_xxhash
• New Extension: timescaledb_toolkit
• New Extension: pg_xenophile
• New Extension: pg_drop_events
• New Extension: pg_incremental
• Bump citus to 13.0.0 with PostgreSQL 17 support.
• Bump pgml to 2.10.0
• Bump pg_extra_time to 2.0.0
• Bump pg_vectorize to 0.20.0

curl https://repo.pigsty.io/pig | bash
curl https://repo.pigsty.cc/pig | bash

Checksums

c79b74f676b03482859f5519b279b657  pig-0.1.3-1.aarch64.rpm
1d00a7cd5855a65e4db964075a5e49f6  pig-0.1.3-1.x86_64.rpm
6cd8507b130fca093247278e36d9478b  pig-v0.1.3.linux-amd64.tar.gz
5eee92908701b0d456ec3c15bc817c0b  pig-v0.1.3.linux-arm64.tar.gz
cb376ef2c3512ad35ff43132942c0052  pig_0.1.3_amd64.deb
2b545abc617670a96c2edd13878e0227  pig_0.1.3_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.1.3

v0.1.2

351 PostgreSQL Extensions, including the powerful postgresql-anonymizer 2.0

Now you can install pig with:

curl -fsSL https://repo.pigsty.io/pig | bash
curl -fsSL https://repo.pigsty.cc/pig | bash

Add New Extension

• add pg_anon 2.0.0
• add omnisketch 1.0.2
• add ddsketch 1.0.1
• add pg_duration 1.0.1
• add ddl_historization 0.0.7
• add data_historization 1.1.0
• add schedoc 0.0.1
• add floatfile 1.3.1
• add pg_upless 0.0.3
• add pg_task 1.0.0
• add pg_readme 0.7.0
• add vasco 0.1.0
• add pg_xxhash 0.0.1

Update Extension

• lower_quantile 1.0.3
• quantile 1.1.8
• sequential_uuids 1.0.3
• pgmq 1.5.0 (subdir)
• floatvec 1.1.1
• pg_parquet 0.2.0
• wrappers 0.4.4
• pg_later 0.3.0
• topn fix for deb.arm64
• add age 17 on debian
• powa + pg17, 5.0.1
• h3 + pg17
• ogr_fdw + pg17
• age + pg17 1.5 on debian
• pgtap + pg17 1.3.3
• repmgr
• topn + pg17
• pg_partman 5.2.4
• credcheck 3.0
• ogr_fdw 1.1.5
• ddlx 0.29
• postgis 3.5.1
• tdigest 1.4.3
• pg_repack 1.5.2

Release: https://github.com/pgsty/pig/releases/tag/v0.1.2

v0.1.0

The pig CLI v0.1 is out, with the following new features:

Install Script

curl -fsSL https://repo.pigsty.io/pig | bash     # cloudflare, default
curl -fsSL https://repo.pigsty.cc/pig | bash     # mainland china mirror

Extension Management

You can download the extension and its dependencies with import subcommand, activate different postgres major versions with link, and prepare building env with build subcommand

pig ext list    [query]      # list & search extension
pig ext info    [ext...]     # get information of a specific extension
pig ext status  [-v]         # show installed extension and pg status
pig ext add     [ext...]     # install extension for current pg version
pig ext rm      [ext...]     # remove extension for current pg version
pig ext update  [ext...]     # update extension to the latest version
pig ext import  [ext...]     # download extension to local repo
pig ext link    [ext...]     # link postgres installation to path
pig ext build   [ext...]     # setup building env for extension

Repo Management

You can now create a local repo and create a tarball (offline package) from it, copy it to somewhere (e.g., without internet access), and create a repo from that offline package:

pig repo list                    # available repo list             (info)
pig repo info   [repo|module...] # show repo info                  (info)
pig repo status                  # show current repo status        (info)
pig repo add    [repo|module...] # add repo and modules            (root)
pig repo rm     [repo|module...] # remove repo & modules           (root)
pig repo update                  # update repo pkg cache           (root)
pig repo create                  # create repo on current system   (root)
pig repo boot                    # boot repo from offline package  (root)
pig repo cache                   # cache repo as offline package   (root)

Pigsty Management

The pig can also be used as a CLI tool for Pigsty — the battery-include free PostgreSQL RDS

pig sty init     # install embed pigsty to ~/pigsty
pig sty boot     # install ansible and other pre-deps
pig sty conf     # auto-generate pigsty.yml config file
pig sty install  # run the install.yml playbook

Self-Updating

To update pig itself to the latest version, you can use the following command:

pig update

Info

Now pig info provides more details about your OS & PG environment:

$ pig info

# [Configuration] ================================
Pig Version      : 0.1.0
Pig Config       : /home/vagrant/.pig/config.yml
Log Level        : info
Log Path         : stderr

# [OS Environment] ===============================
OS Distro Code   : el9
OS Architecture  : amd64
OS Package Type  : rpm
OS Vendor ID     : rocky
OS Version       : 9
OS Version Full  : 9.3
OS Version Code  : el9

# [PG Environment] ===============================
Installed:
* PostgreSQL 17.2  74  Extensions

Active:
PG Version      :  PostgreSQL 17.2
Config Path     :  /usr/pgsql-17/bin/pg_config
Binary Path     :  /usr/pgsql-17/bin
Library Path    :  /usr/pgsql-17/lib
Extension Path  :  /usr/pgsql-17/share/extension

# [Pigsty Environment] ===========================
Inventory Path   : /home/vagrant/pigsty/pigsty.yml
Pigsty Home      : /home/vagrant/pigsty
Embedded Version : 3.2.0

# [Network Conditions] ===========================
pigsty.cc  ping ok: 141 ms
pigsty.io  ping ok: 930 ms
google.com request error
Internet Access   :  true
Pigsty Repo       :  pigsty.io
Inferred Region   :  china
Latest Pigsty Ver :  v3.2.0

Enjoy PostgreSQL!

What’s Changed

• fix typos by @kianmeng in https://github.com/pgsty/pig/pull/4

New Contributors

• @kianmeng made their first contribution in https://github.com/pgsty/pig/pull/4

Full Changelog: https://github.com/pgsty/pig/compare/v0.0.1...v0.1.0

Checksums

46165beec97ab9ff1314f80af953bd59  pig-0.1.0-1.aarch64.rpm
1320a6f9bfbd79948515657d6becbf37  pig-0.1.0-1.x86_64.rpm
bd078a5dc0c41454fcbbe0d8693d5fa0  pig-v0.1.0.linux-amd64.tar.gz
8a15e52f96735b78afa7da42843f1504  pig-v0.1.0.linux-arm64.tar.gz
4d25597cff8425c7e52a2b411344aa4a  pig_0.1.0_amd64.deb
d5f0874601bc1bbd0dd40b5c9982ea9f  pig_0.1.0_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v0.1.0

v0.0.1

Get Started

Installthe pig package first, you can also install via command:

curl -fsSL https://repo.pigsty.io/pig | bash     # cloudflare, default
curl -fsSL https://repo.pigsty.cc/pig | bash     # mainland china mirror

Then it’s ready to use, assume you want to install the pg_duckdb extension:

$ pig repo add pigsty pgdg -u  # add pgdg & pigsty repo, update cache
$ pig ext install pg17         # install PostgreSQL 17 kernels with PGDG native packages
$ pig ext install pg_duckdb    # install the pg_duckdb extension (for current pg17)

That’s it! All sets! you can check with the pig ext status sub command:

$ pig ext status               # show installed extension and pg status
                               # to print built-in contrib extension, use -c|--contrib flag
Installed PG Vers :  17 (active)
Active PostgreSQL :  PostgreSQL 17.2
PostgreSQL        :  PostgreSQL 17.2
Binary Path       :  /usr/pgsql-17/bin
Library Path      :  /usr/pgsql-17/lib
Extension Path    :  /usr/pgsql-17/share/extension
Extension Stat    :  1 Installed (PIGSTY 1, PGDG 0) + 67 CONTRIB = 68 Total

Name       Version  Cate  Flags   License  Repo    Package        Description
----       -------  ----  ------  -------  ------  ------------   ---------------------
pg_duckdb  0.2.0    OLAP  -dsl--  MIT      PIGSTY  pg_duckdb_17*  DuckDB Embedded in Postgres

(1 Rows) (Flags: b = HasBin, d = HasDDL, s = HasSolib, l = NeedLoad, t = Trusted, r = Relocatable, x = Unknown)

Check the advanced usage for details and list 340 available extensions.

Installation

The pig util is a standalone go binary with no dependencies. you can just download the binary or use the following commands to add the repo and install it via package manager (recommended).

For Ubuntu 22.04 / 24.04 & Debian 12 or any compatible platforms:

sudo tee /etc/apt/sources.list.d/pigsty.list > /dev/null <<EOF
deb [trusted=yes] https://repo.pigsty.io/apt/infra generic main
EOF
sudo apt update; sudo apt install -y pig

For EL 8/9 and compatible platforms:

sudo tee /etc/yum.repos.d/pigsty.repo > /dev/null <<-'EOF'
[pigsty-infra]
name=Pigsty Infra for $basearch
baseurl=https://repo.pigsty.io/yum/infra/$basearch
enabled = 1
gpgcheck = 0
module_hotfixes=1
EOF
sudo yum makecache; sudo yum install -y pig

For mainland china user: consider replace the repo.pigsty.io with repo.pigsty.cc

Compatibility

pig runs on: RHEL 8/9, Ubuntu 22.04/24.04, and Debian 12, on both amd64/arm64 arch

Here are some bad cases and limitations for the above distros:

• citus is not available on aarch64 and ubuntu 24.04
• pljava is missing on el8
• jdbc_fdw is missing on el8.aarch64 and el9.aarch64
• pllua is missing on el8.aarch64 for pg 13,14,15
• topn is missing on el8.aarch64 and el9.aarch64 for pg13, and all deb.aarch64
• pg_partman and timeseries is missing on u24 for pg13
• wiltondb is missing on d12

Release: https://github.com/pgsty/pig/releases/tag/v0.0.1

5 - PG Exporter

Advanced PostgreSQL & pgBouncer metrics exporter for Prometheus

PG Exporter brings ultimate monitoring experience to your PostgreSQL with declarative config, dynamic planning, and customizable collectors. It provides 600+ metrics and ~3K time series per instance, covers everything you’ll need for PostgreSQL observability. Check the GitHub Repo for more details.

The latest stable version of pg_exporter is v1.0.3

v1.0.3

• Build with Go 1.25.4 and latest dependencies
• Fix #80 Conflict with libpq env variables
• Change the default value of auto-discovery to true by @kadaffy

Checksums

https://github.com/pgsty/pg_exporter/releases/download/v1.0.3/checksums.txt

v1.0.2

• Build with Go 1.25.0 and latest dependencies
• Dedicate website and homepage: https://exp.pgsty.com
• Release with goreleaser for more os/arch with GitHub CI/CD pipeline:
• add windows amd64 support
• add linux ppc64le support

Checksums

https://github.com/pgsty/pg_exporter/releases/download/v1.0.2/checksums.txt

683bf97f22173f2f2ec319a88e136939c2958a1f5ced4f4aa09a1357fc1c44c5  pg-exporter_1.0.2-1_amd64.deb
f62d479a92be2d03211c162b8419f968cea87ceef5b1f25f2bcd390e0b72ccb5  pg-exporter_1.0.2-1_arm64.deb
e1bbfc5a4c1b93e6f92bc7adcb4364583ab763e76e156aa5c979d6d1040f4c7a  pg-exporter_1.0.2-1_ppc64le.deb
f51d5b45448e6bbec3467d1d1dc049b1e16976f723af713c4262541ac55a039c  pg_exporter-1.0.2-1.aarch64.rpm
18380011543674e4c48b2410266b41165974d780cbc8918fc562152ba623939e  pg_exporter-1.0.2-1.ppc64le.rpm
198372d894b9598c166a0e91ca36d3c9271cb65298415f63dbffcf6da611f2bb  pg_exporter-1.0.2-1.x86_64.rpm
cbe7e07df6d180507c830cdab4cf86d40ccd62774723946307b5331d4270477d  pg_exporter-1.0.2.darwin-amd64.tar.gz
20c4a35fa244287766c1d1a19cd2e393b3fa451a96a81e5635401e69bef04b97  pg_exporter-1.0.2.darwin-arm64.tar.gz
d742111185f6a89fff34bfd304b851c8eb7a8e38444f0220786e11ed1934eff1  pg_exporter-1.0.2.linux-amd64.tar.gz
0b1f4c97c1089c4767d92eb22419b8f29c9f46fb90ddfd1e8514cc42dc41054f  pg_exporter-1.0.2.linux-arm64.tar.gz
895083fd2c7fc5409cc1a2dbaaef1e47ac7aa6a3fd5db2359012922d90bcdcc3  pg_exporter-1.0.2.linux-ppc64le.tar.gz
5f751228e7120604af9a482fb70197489fa633c38a0f2b6a3489393fbc6a10aa  pg_exporter-1.0.2.windows-amd64.tar.gz

v1.0.1

• Add dockerhub images: pgsty/pg_exporter
• Bump go dependencies to the latest version, build with go 1.24.5
• Disable pg_tsdb_hypertable collector by default, since timescaledb catalog is changed.

Checksums

d5e2d6a656eef0ae1b29cd49695f9773  pg_exporter-1.0.1-1.aarch64.rpm
cb01bb78d7b216a235363e9342803cb3  pg_exporter-1.0.1-1.x86_64.rpm
67093a756b04845f69ad333b6d458e81  pg_exporter-v1.0.1.darwin-amd64.tar.gz
2d3fdc10045d1cf494b9c1ee7f94f127  pg_exporter-v1.0.1.darwin-arm64.tar.gz
e242314461becfa99c3978ae72838ab0  pg_exporter-v1.0.1.linux-amd64.tar.gz
63de91da9ef711a53718bc60b89c82a6  pg_exporter-v1.0.1.linux-arm64.tar.gz
718f6afc004089f12c1ca6553f9b9ba5  pg-exporter_1.0.1_amd64.deb
57da7a8005cdf91ba8c1fb348e0d7367  pg-exporter_1.0.1_arm64.deb

https://github.com/pgsty/pg_exporter/releases/tag/v1.0.1

v1.0.0

Add PostgreSQL 18 metrics support

• new collector branch pg_wal_18:
• remove write, sync, write_time, sync_time metrics
• move to pg_stat_io
• new collector branch pg_checkpointer_18:
• new metric num_done
• new metric slru_written
• new collector branch pg_db_18:
• new metric parallel_workers_to_launch
• new metric parallel_workers_launched
• new collector branch pg_table_18:
• table_parallel_workers_to_launch
• table_parallel_workers_launched
• new collector branch pg_io_18:
• new series about WAL statistics
• new metric read_bytes
• new metric write_bytes
• new metric extend_bytes
• remove op_bytes due to fixed value
• new collector branch pg_vacuuming_18
• new metric delay_time

8637bc1a05b93eedfbfd3816cca468dd  pg_exporter-1.0.0-1.aarch64.rpm
a28c4c0dcdd3bf412268a2dbff79f5b9  pg_exporter-1.0.0-1.x86_64.rpm
229129209b8e6bc356c28043c7c22359  pg_exporter-v1.0.0.darwin-amd64.tar.gz
d941c2c28301269e62a8853c93facf12  pg_exporter-v1.0.0.darwin-arm64.tar.gz
5bbb94db46cacca4075d4c341c54db37  pg_exporter-v1.0.0.linux-amd64.tar.gz
da9ad428a50546a507a542d808f1c0fa  pg_exporter-v1.0.0.linux-arm64.tar.gz
0fa2395d9d7a43ab87e5c87e5b06ffcc  pg-exporter_1.0.0_amd64.deb
fed56f8a37e30cc59e85f03c81fce3f5  pg-exporter_1.0.0_arm64.deb

https://github.com/pgsty/pg_exporter/releases/tag/v1.0.0

v0.9.0

Default Collectors

• new metrics collector for timescaledb hypertable
• new metrics collector for citus dist node
• new metrics collector for pg_wait_sampling wait event profile
• pg_slot overhaul: Add 16/17 pg_replication_slot metrics
• allow pg_slot collector run on replica since 16/17
• refactor pg_wait collector to agg from all processes
• restrict pg_clustering, pg_indexing, pg_vacuuming run on primary
• mark all reset_time as GAUGE rather than COUNTER
• fix pg_recovery_prefetch_skip_fpw type from GAUGE to COUNTER
• fix pg_recv.state type from LABEL to GAUGE
• Format collector in compact mode
• new default metric pg_exporter_build_info / pgbouncer_exporter_build_info
• add server_encoding to pg_meta collector
• add 12 new setting metrics to pg_setting collector

• wal_block_size
• segment_size
• wal_segment_size
• wal_level
• wal_log_hints
• work_mem
• hugepage_count
• hugepage_status
• max_wal_size
• min_wal_size
• max_slot_wal_keep_size

Exporter Codebase

• normalize collector branch name with min pg ver suffix
• Add license file to binary packages
• move pgsty/pg_exporter repo to pgsty/pg_exporter
• refactor server.go to reduce Compatible and PostgresPrecheck complexity
• rename metrics collector with extra number prefix for better sorting
• bump dependencies to the latest version
• execute fatal collectors ahead of all non-fatal collectors, and fail fast

https://github.com/pgsty/pg_exporter/releases/tag/v0.9.0

v0.8.1

• Bump dependencies to the latest version
• Bump golang.org/x/net from 0.35.0 to 0.36.0 #67
• Update docker images building tags

https://github.com/pgsty/pg_exporter/releases/tag/v0.8.1

v0.8.0

• Add PgBouncer 1.24 new metrics support (stat, pool, database)
• Fix: 310-pg_size.yml fails if log dir not set properly #64 by @Süleyman Vurucu
• Build with the latest Go 1.24 and bump all dependencies
• Refactor logging with the standard log/slog instead of go-kit
• Full Changelog: https://github.com/pgsty/pg_exporter/compare/v0.7.1...v0.8.0

https://github.com/pgsty/pg_exporter/releases/tag/v0.8.0

v0.7.1

Routine update with dependabot

• Feat: support specifying configuration as Reader by @ringerc in #62
• Bump golang.org/x/crypto from 0.21.0 to 0.31.0 by @dependabot in #63
• Fix some typos
• Full Changelog: https://github.com/pgsty/pg_exporter/compare/v0.7.0...v0.7.1

https://github.com/pgsty/pg_exporter/releases/tag/v0.7.1

v0.7.0

Refactor codebase for the latest go version.

• PostgreSQL 17 Metrics Support by @Vonng
• pg_exporter: predicate queries feature by @ringerc
• Do a clean build in the dockerfile by @ringerc by @ringerc
• pg_exporter: don’t panic after “bind: address already in use” by @ringerc
• pg_exporter: fix /stat endpoint formatting by @ringerc
• pg_exporter: omit default query properties on yaml export by @ringerc
• Exclude template DBs from discovery and schema-qualify discovery query by @ringerc
• Fix some typos and some metric description mistakes by @ringerc
• Switch from unmaintained lib/pq driver to pgx with stdlib wrapper by @ringerc

https://github.com/pgsty/pg_exporter/releases/tag/v0.7.0

v0.6.0

• Security Enhancement: Fix security dependent-bot issue

• Add pg16 collectors

• Add arm64 & aarch64 packages

• Remove the monitor schema requirement for pg_query collectors (you have to ensure it with search_path or just install pg_stat_statements in the default public schema)

• Fix pgbouncer version parsing message level from info to debug

• Fix pg_table_10_12 collector missing relid issue.

• Recognize the files with yml suffix in config directory by @Japin Li

• Support PostgreSQL 15 and higher by @Japin Li

• Fix connect-timeout propagation by @mouchar

https://github.com/pgsty/pg_exporter/releases/tag/v0.6.0

v0.5.0

Exporter Enhancement

• Build rpm & deb with nfpm
• Add column.default, replace when metric value is NULL
• Add column.scale, multiply scale factor when metric value is float/int (e.g µs to second)
• Fix /stat endpoint output
• Add docker container pgsty/pg_exporter

Metrics Collector

• scale bgwriter & pg_wal time unit to second
• remove pg_class collector and move it to pg_table & pg_inex
• add pg_class metrics to pg_table
• add pg_class metrics to pg_index
• enable pg_table_size by default
• scale pg_query pg_db pg_bgwriter pg_ssl pgbouncer_stat time metrics to second

https://github.com/pgsty/pg_exporter/releases/tag/v0.5.0

v0.4.1

• update default collectors
  • omit citus & timescaledb schemas on object monitoring
  • avoid duplicate pg_statio tuples
  • support pgbouncer v1.16
  • bug fix: pg_repl collector overlap on pg 12
• new parameter: -T connect-timeout PG_EXPORTER_CONNECT_TIMEOUT this can be useful when monitoring remote Postgres instances.
• now pg_exporter.yaml are renamed as pg_exporter.yml in rpm package.

https://github.com/pgsty/pg_exporter/releases/tag/v0.4.1

v0.4.0

• Add PG 14 support
• Default metrics configuration overhaul. (BUT you can still use the old configuration)
• add auto-discovery , include-database and exclude-database option
• Add multiple database monitoring implementations (with auto-discovery = on)

https://github.com/pgsty/pg_exporter/releases/tag/v0.4.0

v0.3.2

• fix shadow DSN corner case
• fix typo & docs

https://github.com/pgsty/pg_exporter/releases/tag/v0.3.2

v0.3.1

fix default configuration problems (especially for versions lower than 13)

• setting primary_conninfo not exists until PG13
• add funcid label to pg_func collector to avoid func name duplicate label
• fix version string to pg_exporter

https://github.com/pgsty/pg_exporter/releases/tag/v0.3.1

v0.3.0

https://github.com/pgsty/pg_exporter/releases/tag/v0.3.0

• Change default configuration, Support PostgreSQL 13 new metrics (pg_slru, pg_shmem, pg_query13,pg_backup, etc…)
• Add a series of new REST APIs for health / recovery status check
• Add a dummy server with fake pg_up 0 metric, which serves before PgExporter is initialized.
• Add sslmode=disable to URL if sslmode is not given
• fix typos and bugs

v0.2.0

• add yum package and linux service definition
• add a ‘skip’ flag into query config
• fix pgbouncer_up metrics
• add conf reload support

https://github.com/pgsty/pg_exporter/releases/tag/v0.2.0

v0.1.2

• fix pgbouncer_up metrics
• add dynamic configuration reload
• remove ‘shard’ related logic
• add a ‘bulky’ mode to default settings

https://github.com/pgsty/pg_exporter/releases/tag/v0.1.2

v0.1.1

Fix the bug that pg_exporter will hang during start-up if any query is failed.

https://github.com/pgsty/pg_exporter/releases/tag/v0.1.1

v0.1.0

It works, looks good to me.

https://github.com/pgsty/pg_exporter/releases/tag/v0.1.0

v0.0.4

Tested in real world production environment with 200+ nodes for about 2 weeks. Looks good !

https://github.com/pgsty/pg_exporter/releases/tag/v0.0.4

v0.0.3

v0.0.3 Release, Tested in Production Environment

This version is already tested in a production environment.

This project is still under rapid evolution, I would say if you want use it in production , try with caution.

https://github.com/pgsty/pg_exporter/releases/tag/v0.0.3

v0.0.2

It’s ok to try now

https://github.com/pgsty/pg_exporter/releases/tag/v0.0.2

v0.0.1

Add pgbouncer mode

https://github.com/pgsty/pg_exporter/releases/tag/v0.0.1

6 - RPM Release

Check pgsty/rpm repo for build specs and pigsty-pgsql for usage

curl https://repo.pigsty.io/pig | bash      # download and install the pig CLI tool
pig repo add all pigsty -u                  # add pigsty-pgsql repo and update cache

# Add Pigsty's GPG public key to your system keychain to verify package signatures
curl -fsSL https://repo.pigsty.io/key | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null

# Add Pigsty Repo definition files to /etc/yum.repos.d/ directory, including two repositories
sudo tee /etc/yum.repos.d/pigsty-pgsql.repo > /dev/null <<-'EOF'
[pigsty-pgsql]
name=Pigsty PGSQL For el$releasever.$basearch
baseurl=https://repo.pigsty.io/yum/pgsql/el$releasever.$basearch
skip_if_unavailable = 1
enabled = 1
priority = 1
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty
module_hotfixes=1
EOF

# Refresh YUM/DNF repository cache
sudo yum makecache;

2025-11-20

2025-11-10

Add PostgreSQL 18 support for almost all extensions

2025-09-04

2025-07-24

2025-06-24

2025-05-26

2025-05-22

2025-05-07

2025-03-20

2024-10-16

7 - DEB Release

Check pgsty/deb repo for build specs and pigsty-pgsql for usage

curl https://repo.pigsty.io/pig | bash      # download and install the pig CLI tool
pig repo add all pigsty -u                  # add pigsty-pgsql repo and update cache

# Add Pigsty's GPG public key to your system keychain to verify package signatures
curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg

# Get Debian distribution codename (distro_codename=jammy, focal, bullseye, bookworm), and write the corresponding upstream repository address to the APT List file
distro_codename=$(lsb_release -cs)
sudo tee /etc/apt/sources.list.d/pigsty-io.list > /dev/null <<EOF
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/pgsql/${distro_codename} ${distro_codename} main
EOF

# Refresh APT repository cache
sudo apt update

2025-11-20

2025-11-10

Add PostgreSQL 18 support for almost all extensions

2025-09-06

2025-07-24

2025-07-04

2025-06-24

2025-05-26

2025-05-22

2025-05-07

2025-03-20

2024-10-16

8 - INFRA Release

Check pgsty/infra-pkg repo for build specs and pigsty-infra for usage

curl https://repo.pigsty.io/pig | bash      # download and install the pig CLI tool
pig repo add infra -u                       # add pigsty-pgsql repo and update cache

2025-11-20

2025-11-11

2025-10-18

2025-08-15

2025-07-24

2025-07-16