# Pigsty v3.0.4

> PG 17 扩展，OLAP 全家桶，pg_duckdb

---

LLMS 索引： [llms.txt](/zh/llms.txt)

---

**v3\.0\.4 · 2024-10-28**
- [查看发布](https://github.com/pgsty/pigsty/releases/tag/v3.0.4)
- [源码 · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.4.tar.gz)
- [源码 · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.4.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## 特性

- 针对 PostgreSQL 17 编译了所有支持的 Pigsty 扩展插件
- 提供了全新的 OLAP 扩展支持：`pg_duckdb` 与 `pg_parquet`
- 简化并优化了最新版本 Supabase 自建的流程
- 新增参数 `docker_image`，允许在 Docker 安装后自动拉取镜像。

## 扩展

欢迎查阅我们最新的 PostgreSQL 扩展目录： /ext/

|   统计项   | 总计  | PGDG | PIGSTY | MISC | MISS | PG17 | PG16 | PG15 | PG14 | PG13 | PG12 |
|:-------:|:---:|:----:|:------:|:----:|:----:|:----:|:----:|:----:|:----:|:----:|:----:|
| EL 系统扩展  | 338 | 134  |  130   |  4   |  7   | 298  | 334  | 336  | 328  | 319  | 310  |
| Deb 系统扩展 | 326 | 109  |  143   |  74  |  19  | 290  | 322  | 324  | 316  | 307  | 300  |
| RPM 软件包 | 313 | 122  |  129   |  4   |  6   | 275  | 309  | 311  | 303  | 294  | 285  |
| DEB 软件包 | 298 |  93  |  142   |  64  |  19  | 264  | 294  | 296  | 288  | 279  | 272  |

## 版本升级

- **新的 PGSQL 扩展**

    - [pg_parquet](https://github.com/CrunchyData/pg_parquet/)
    - [pg_explain_ui](https://github.com/davidgomes/pg-explain-ui)
    - [pg_polyline](https://github.com/yihong0618/pg_polyline)
    - [pg_cardano](https://github.com/Fell-x27/pg_cardano)
    - [pg_base58](https://github.com/Fell-x27/pg_base58)
    - [pg_summarize](https://github.com/HexaCluster/pg_summarize)
    - [pg_relusage](https://pgxn.org/dist/pg_relusage/0.0.1/)
    - [pgmq](https://github.com/tembo-io/pgmq)
    - [pg_timeseries](https://github.com/tembo-io/pg_timeseries)
    - [pg_plan_filter](https://github.com/pgexperts/pg_plan_filter)

- **升级与跟进 PG 扩展**
    - pg_search 0.11.0
    - pg_analytics 0.2.0
    - plv8 3.2.3
    - supautils 2.5.0
    - icu_ext 1.9.0
    - redis_fdw 17
    - pg_failover_slots 1.1.0
    - pg_later 0.1.3
    - plprql 1.0.0
    - pg_vectorize 0.18.3
    - unit 7.7 -> 7.9
    - log_fdw 1.4
    - pg_duckdb 0.1.0
    - pg_graphql 1.5.9 (+17)
    - pg_jsonschema 0.3.2 (+17)
    - pgvectorscale 0.4.0 (+17)
    - wrappers 0.4.3 +pg17
    - pg_ivm 1.9
    - pg_timeseries 0.1.6
    - pgmq 1.4.4
    - pg_protobuf 16 17
    - pg_uuidv7 1.6
    - pg_readonly
    - pgddl 0.28
    - pg_safeupdate
    - pg_stat_monitor 2.1
    - pg_profile 4.7
    - system_stats 3.2
    - pg_auth_mon 3.0
    - login_hook 1.6
    - logerrors 2.1.3
    - pg-orphaned
    - pgnodemx 1.7
    - sslutils 1.4 (deb+pg16,17)
    - timestamp9 (deb)
- **修复不支持 PG16/17的扩展**
    - pg_mon
    - pg_uri
    - agg_for_vecs
    - quantile
    - lower_quantile
    - pg_protobuf
    - acl
    - pg_emailaddr
    - pg_zstd
    - smlar
    - geohash
    - pgsmcrypto (+17)
    - pg_tiktoken (+17)
    - pg_idkit (+17)
- **基础设施软件包**
    - Grafana 11.3
    - duckdb 1.1.2
    - etcd 3.5.16
    - ferretdb 1.24.0
    - minio 20241013133411
    - mcli 2024101313411
    - pushgateway 1.10
    - tigerbeetle 0.16.8
    - mongodb_exporter 0.41.2
    - redis_exporter 1.64.1
    - vector 0.41.1
    - vip-manager 2.7
    - sealos 5.0.1

## 信息来源

- [GitHub Release](https://github.com/pgsty/pigsty/releases/tag/v3.0.4)
- [Pigsty v3.0 发布文章](https://pigsty.cc/blog/pigsty/v3.0/)
- [历史 About / 发布注记](https://pigsty.cc/docs/about/release/#v304)
- [源码对比：`v3.0.3...v3.0.4`](https://github.com/pgsty/pigsty/compare/v3.0.3...v3.0.4)