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

• Extensible: PG 17 - 13, 404 PG Extensions & MSSQL, Oracle compatible Kernel replacements available.
• Reliable: Self-healing HA clusters with pre-configured PITR and built-in ACL, CA & SSL secure best practice.
• Observable: SOTA monitoring for PG / Infra / Node based on Prometheus & Grafana stack: Demo & Gallery.
• Available: Auto-routed & pooled customizable database Services Access with haproxy, pgbouncer, and VIP.
• Maintainable: One-Cmd Install, Admin SOP, Auto-Tune, Local Repo, IaC, and Vagrant / Terraform support.
• Composable: Bonus Modules such as Redis, MinIO, Etcd, Docker, DuckDB, FerretDB, Supabase, & more!

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.