From: | Pigsty via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | Pigsty v3.3 Release: with 404 PostgreSQL Extensions |
Date: | 2025-03-07 19:49:59 |
Message-ID: | 174137699945.682.13779250677244588203@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
**Unlocking PostgreSQL’s Full Potential with the** [404](https://pigsty.io/ext/) **available extensions!**
Pigsty [v3.3.0](https://pigsty.io/blog/releases/v3.3.0/) is now live, following the release of PostgreSQL 17.4. This update delivers a complete PostgreSQL ecosystem with over 400 extensions, focusing on making self-hosting simpler than ever. Key new extensions include [pg_documentdb](https://pigsty.io/ext/sim/documentdb) from MS, [pg_collection](https://pigsty.io/ext/type/collection) from AWS, and [pg_tracing](https://pigsty.io/ext/stat/pg_tracing/) from DataDog. With the integration of [FerretDB 2.0](https://pigsty.io/docs/ferret/) supporting MongoDB compatibility over PostgreSQL. Pigsty’s [extension catalog](https://pigsty.io/ext/) is now an unrivaled resource for expanding PostgreSQL’s capabilities. See the full list of extensions [here](https://pigsty.io/ext/list).
Pigsty v3.3 takes the self-hosting experience to new heights, with automated HTTPS certificates via [Certbot](https://pigsty.io/docs/tasks/certbot/) and advanced [Nginx](https://pigsty.io/docs/tasks/nginx/) management. This release makes deploying secure, reliable websites and services a breeze, all with just a few commands. The new `app.yml` playbook simplify deploying apps like [Odoo](https://pigsty.io/docs/app/odoo/), [Supabase](https://pigsty.io/docs/app/supabase/), and [Dify](https://pigsty.io/docs/app/dify/)—all powered by PostgreSQL — turning complex setups into a single, streamlined playbook.
Significant updates to the [pig](https://pigsty.io/ext/pig/) CLI make managing over 400 extensions and **building** them easier than ever. The new [pig build](https://pigsty.io/ext/pig/build/) subcommand streamlines the entire extension build process. With a revamped global website ([pigsty.io](https://pigsty.io/)) and a localized Chinese site ([pigsty.cc](https://pigsty.cc/)), Pigsty v3.3 cements its position as the ultimate solution for PostgreSQL self-hosting, extensions, and app deployment. For all the details about Pigsty v3.3, check out our [blog](https://pigsty.io/blog/releases/v3.3.0/).
## About Pigsty
Pigsty is a battery-included, local-first PostgreSQL distribution and an open-sourced RDS alternative.
Links: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pigsty) | [Demo](https://demo.pigsty.io/) | [Get Started](https://pigsty.io/docs/setup/install/) | [Features](https://pigsty.io/docs/about/feature/) | [Extensions](https://pigsty.io/ext/list) | [v3.3.0 Release Note](https://pigsty.io/blog/releases/v3.3.0/)
```
bash curl -fsSL https://repo.pigsty.io/get | bash
```
#### Features
- [Extensible](https://pigsty.io/img/pigsty/ecosystem.jpg): PG 17 - 13, 404 [PG Extensions](https://pigsty.io/docs/pgext/list) & [MSSQL](https://pigsty.io/docs/kernel/babelfish/), [Oracle](https://pigsty.io/docs/kernel/ivorysql/) compatible [Kernel](https://pigsty.io/docs/kernel) replacements available.
- [Reliable](https://pigsty.io/img/pigsty/arch.jpg): Self-healing [HA](https://pigsty.io/docs/concept/ha/) clusters with pre-configured [PITR](https://pigsty.io/docs/pgsql/arch#point-in-time-recovery) and built-in [ACL](https://pigsty.io/docs/pgsql/acl), [CA & SSL](https://pigsty.io/docs/reference/param/#ca) secure best practice.
- [Observable](https://pigsty.io/img/pigsty/dashboard.jpg): SOTA monitoring for [PG](https://demo.pigsty.cc/d/pgrds-instance/pgrds-instance) / [Infra](https://pigsty.io/docs/infra) / [Node](https://pigsty.io/docs/node) based on Prometheus & Grafana stack: [Demo](https://demo.pigsty.cc/) & [Gallery](https://github.com/Vonng/pigsty/wiki/Gallery).
- [Available](https://pigsty.io/img/pigsty/ha.png): Auto-routed & pooled customizable database [Services](https://pigsty.io/docs/concept/svc#default-service) [Access](https://pigsty.io/docs/concept/svc#access-service) with haproxy, pgbouncer, and VIP.
- [Maintainable](https://pigsty.io/img/pigsty/iac.jpg): [One-Cmd Install](https://pigsty.io/docs/setup/install), [Admin SOP](https://pigsty.io/docs/pgsql/admin), Auto-Tune, Local Repo, [IaC,](https://pigsty.io/docs/pgsql/config) and [Vagrant](https://pigsty.io/docs/setup/provision#vagrant) / [Terraform](https://pigsty.io/docs/setup/provision#terraform) support.
- [Composable](https://pigsty.io/img/pigsty/sandbox.jpg): Bonus [Modules](https://pigsty.io/docs/about/modules) such as [Redis](https://pigsty.io/docs/redis), [MinIO](https://pigsty.io/docs/minio), [Etcd](https://pigsty.io/docs/etcd), [Docker](https://pigsty.io/docs/app), [DuckDB](https://pigsty.io/docs/pro/duckdb), [FerretDB](https://pigsty.io/docs/ferret), [Supabase](https://pigsty.io/docs/kernel/supabase/), [& more](https://pigsty.io/docs/pro/)!
#### Advantages
- Unparalleled Extension: We packed 200+ [RPM](https://pigsty.io/ext/list/rpm) / [DEB](https://pigsty.io/ext/list/deb) extensions in addition to the official PGDG repo.
- Stunning Observability: Ultimate experience with 3000+ metrics visualized in 30+ organized dashboards.
- Reliable Best Practices: Proven & Polished in large-scale production environment (25K vCPU) for 6 years+.
- NO Docker/Kubernetes: We choose the hard way to deliver RDS based on bare OS WITHOUT [Containers](https://pigsty.io/blog/db/db-in-k8s/)!
- Infrastructure as Code: Describe everything with declarative API and provision with idempotent playbooks!
- Free OSS & Local-First: Pigsty is a free software under [AGPLv3](https://pigsty.io/docs/about/license/). Build for PostgreSQL with passion & love.
From | Date | Subject | |
---|---|---|---|
Next Message | Postgres Extension Developers Coalition via PostgreSQL Announce | 2025-03-10 09:33:41 | Postgres Extensions Day 2025: Registration and Call for Speakers |
Previous Message | UCLL via PostgreSQL Announce | 2025-03-07 19:49:21 | PGConf.BE : Call for speakers and Registrations open |