v3.3.0 with 404 Ext, App, DocumentDB, Nginx Enhancement

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.

• 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

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