# Pigsty v2.4.1

> Supabase/PostgresML support with graphql, jwt, pg_net, vault

---

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

---

**v2\.4\.1 · 2023-09-24**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.4.1)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.4.1.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.4.1.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

[Supabase](https://github.com/pgsty/pigsty/tree/master/app/supabase) & [PostgresML](https://github.com/pgsty/pigsty/tree/master/app/pgml) support, and other new extensions!

![Pigsty-Distro-En](https://github.com/pgsty/pigsty/assets/8587410/e51392a3-a04b-4b50-b0f3-c65cc99770f2)

## Highlights

- [Supabase](https://github.com/pgsty/pigsty/tree/master/app/supabase) support: run open-source Firebase alternative with external postgres managed by Pigsty: [example config](https://github.com/pgsty/pigsty/tree/master/app/supabase)
- [PostgresML](https://github.com/pgsty/pigsty/tree/master/app/pgml) support: Run LLMs, vector operations, classical Machine Learning in Postgres.
- GraphQL support: [`pg_graphql`](https://github.com/supabase/pg_graphql) reflects a GraphQL schema from the existing SQL schema.
- Async HTTP Client support [`pg_net`](https://github.com/supabase/pg_net) enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL
- JWT support: [`pgjwt`](https://github.com/michelp/pgjwt) is the PostgreSQL implementation of JWT (JSON Web Tokens)
- Vault support: [`vault`](https://github.com/supabase/vault) can store encrypted secrets in the Vault
- New component [`pg_filedump`](https://github.com/df7cb/pg_filedump) for pg 14 & 15, low-level data recovery tool for PostgreSQL
- New extension `hydra` the columnar available for PG 13 - 15. (not packaged due to conflict with citus columnar)
- Reduce offline packages size for el9 400MB by removing `proj-data*`
- Bump [FerretDB](https://github.com/FerretDB/FerretDB) version to v1.10
- Fix patroni v3.1.1 broken issue

```
7e3989a98b7b0cd213e7efa09a8e8ebc  pigsty-v2.4.1.tgz
efabe7632d8994f3fb58f9838b8f9d7d  pigsty-pkg-v2.4.1.el7.x86_64.tgz
ea78957e8c8434b120d1c8c43d769b56  pigsty-pkg-v2.4.1.el8.x86_64.tgz
4ef280a7d28872814e34521978b851bb  pigsty-pkg-v2.4.1.el9.x86_64.tgz
```

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v2.4.1)
- [Pigsty v2.4 release article](https://pigsty.io/blog/pigsty/v2.4/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v241)
- [Source comparison: `v2.4.0...v2.4.1`](https://github.com/pgsty/pigsty/compare/v2.4.0...v2.4.1)