# Pigsty v3.3.0

> 404 extensions, extension directory, App playbook, Nginx customization

---

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

---

**v3\.3\.0 · 2025-02-24**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.3.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.3.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.3.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

- Total available extensions increased to [**404**](/docs/pgsql/ext/)!
- 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](https://github.com/pgsty/pigsty/pull/506) [#524](https://github.com/pgsty/pigsty/pull/524) by [@waitingsong](https://github.com/waitingsong).
- Improvement: Refined `ignore_startup_parameters` in `pgbouncer` config template [#488](https://github.com/pgsty/pigsty/pull/488) by [@waitingsong](https://github.com/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](https://pigsty.io/ext/list) available extensions.

- [documentdb](https://github.com/microsoft/documentdb/) 0.101-0
- [VectorChord-bm25](https://github.com/tensorchord/VectorChord-bm25) (vchord_bm25) 0.1.0
- [pg_tracing](https://github.com/DataDog/pg_tracing) 0.1.2
- [pg_curl](https://github.com/RekGRpth/pg_curl) 2.4
- [pgxicor](https://github.com/Florents-Tselai/pgxicor) 0.1.0
- [pgsparql](https://github.com/lacanoid/pgsparql) 1.0
- [pgjq](https://github.com/Florents-Tselai/pgJQ) 0.1.0
- [hashtypes](https://github.com/adjust/hashtypes/) 0.1.5
- [db_migrator](https://github.com/cybertec-postgresql/db_migrator) 1.0.0
- [pg_cooldown](https://github.com/rbergm/pg_cooldown) 0.1
- [pgcollection](https://github.com/aws/pgcollection) 0.9.1
- [pg_bzip](https://github.com/steve-chavez/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

## Sources

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