The [Pigsty](https://pigsty.io/) community is thrilled to announce Pigsty [v3.0](https://github.com/Vonng/pigsty/releases/tag/v3.0.0), which delivers [336](https://pigsty.io/docs/pgext/list/) unique extensions. and several in-place PG kernel replacements.
You can replace vanilla PostgreSQL with [Babelfish](https://pigsty.io/docs/kernel/babelfish/) for MSSQL compatibility, with [`IvorySQL`](https://pigsty.io/docs/kernel/ivorysql) for ORACLE compatibility, and [`PolarDB`](https://pigsty.io/docs/kernel/polardb/) for Aurora flavor. You can also wrap any existing PostgreSQL kernel / RDS with add-ons: serving MongoDB wire protocol with the latest [`FerretDB`](https://pigsty.io/docs/ferret/) or the self-hosting firebase alternative [`Supabase`](https://pigsty.io/docs/kernel/supabase/), which is newly available on Debian/Ubuntu in addition to EL distros. We also have [`DuckDB`](https://pigsty.io/docs/pro/duckdb/) support with the CLI binary and PostgreSQL extensions, such as `pg_lakehouse` / `pg_analytics` / `duckdb_fdw` and `pg_duckdb` (alpha) and many other extensions, to serve the OLAP race in the PG ecosystem. Check the complete [release note](https://pigsty.io/blog/releases/v3.0.0/) for all the details. ## About Pigsty Pigsty is a Battery-included, local-first PostgreSQL Distribution as an open-sourced RDS alternative. Links: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pigsty) | [Demo](https://demo.pigsty.cc/) | [Get Started](https://pigsty.io/docs/setup/install/) | [Features](https://pigsty.io/docs/about/feature/) | [v3.0.0 Release Note](https://pigsty.io/blog/releases/v3.0.0/) ```bash curl -fsSL https://repo.pigsty.io/get | bash ``` #### Features - [Extensible](https://pigsty.io/img/pigsty/extension.png): 336 [PG Extensions](https://pigsty.io/docs/pgext/list) & 6 [PG Kernel](https://pigsty.io/docs/kernel) replacements available (e.g., [MSSQL](https://pigsty.io/docs/kernel/babelfish/), [Oracle](https://pigsty.io/docs/kernel/ivorysql/) compatibility). - [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 138 [RPM](https://pigsty.io/docs/pgext/list/rpm) and 133 [DEB](https://pigsty.io/docs/pgext/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 5 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.
