Pigsty v3.3 Release: with 404 PostgreSQL Extensions

Posted on 2025-03-07 by Pigsty
Related Open Source

Unlocking PostgreSQL’s Full Potential with the 404 available extensions!

Pigsty 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 from MS, pg_collection from AWS, and pg_tracing from DataDog. With the integration of FerretDB 2.0 supporting MongoDB compatibility over PostgreSQL. Pigsty’s extension catalog is now an unrivaled resource for expanding PostgreSQL’s capabilities. See the full list of extensions here.

Pigsty v3.3 takes the self-hosting experience to new heights, with automated HTTPS certificates via Certbot and advanced 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, Supabase, and Dify—all powered by PostgreSQL — turning complex setups into a single, streamlined playbook.

Significant updates to the pig CLI make managing over 400 extensions and building them easier than ever. The new pig build subcommand streamlines the entire extension build process. With a revamped global website (pigsty.io) and a localized Chinese site (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.

About Pigsty

Pigsty is a battery-included, local-first PostgreSQL distribution and an open-sourced RDS alternative.

Links: Website | GitHub | Demo | Get Started | Features | Extensions | v3.3.0 Release Note

bash curl -fsSL https://repo.pigsty.io/get | bash

Features

Advantages

  • Unparalleled Extension: We packed 200+ RPM / 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!
  • Infrastructure as Code: Describe everything with declarative API and provision with idempotent playbooks!
  • Free OSS & Local-First: Pigsty is a free software under AGPLv3. Build for PostgreSQL with passion & love.