**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.
