# Pigsty v3.0.4

> PG17 extensions, OLAP suite, pg_duckdb

---

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

---

**v3\.0\.4 · 2024-10-28**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v3.0.4)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.4.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v3.0.4.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Features

- Build & Packaging applicable extensions for PostgreSQL 17
- Adding OLAP extensions: `pg_duckdb` & `pg_parquet`
- Better supabase self-hosting experience
- Allow pulling/load images after docker installation

## Extensions

Check the new extension catalog: https://ext.pigsty.io

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

[![landscape](https://pigsty.io/img/pigsty/ecosystem.jpg)](https://ext.pigsty.io/)

## Upgrades

- **New PG Extensions**
  - [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)
- **Bump Extension Version**
  - 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)
- **Fix broken extensions for 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)
- **Update infra packages version**
  - 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

## Checksums

```
5781f2c2f1a96912a9c656993b6299c4  pigsty-v3.0.4.tgz
```

## Sources

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