PostgreSQL In Great STYle
Enterprise-Grade Open-Source PG Distribution HA, PITR, IaC, Monitor, and 450+ PG extensions
$
curl -fsSL https://repo.pigsty.io/get | bash
Enterprise-Grade Open-Source PG Distribution HA, PITR, IaC, Monitor, and 450+ PG extensions
curl -fsSL https://repo.pigsty.io/get | bash
Everything you need for enterprise-grade PostgreSQL. Open source and Free
Self-healing. Sleep tight
Declare. Deploy. Done
# pigsty.yml - Define a 3-node HA cluster pg-test: hosts: 10.10.10.11: { pg_role: primary } 10.10.10.12: { pg_role: replica } 10.10.10.13: { pg_role: replica } vars: pg_cluster: pg-test pg_version: 18 pg_users: - { name: dbuser_app, password: DBUser.App } pg_databases: - { name: app, extensions: [ vector ]}
Full visibility. No blind spots
Fully packed. Plug and play
Unlocks the full potential of PostgreSQL with 12+ kernel forks and 450+ extensions!
Supabase
Backend as a Service
Citus
Horizontally Distributed
Babelfish
SQL Server Compatible
IvorySQL
Oracle Compatible
OpenHalo
MySQL Compatible
Percona
Transparent Data Encryption
FerretDB
MongoDB Compatible
OrioleDB
OLTP Optimized
PolarDB PG
Cloud-Native RAC
Cloudberry
PG MPP Warehouse
AgensGraph
Multi-Model Graph
pgEdge
Distributed Edge Kernel
We run 100+ PostgreSQL clusters at 2.5M QPS with just 1.5 DBAs.
Our TCO is 5% of public cloud. — Tantan
See what people are saying
"Pigsty is a software written to solve our own problems. And it does it well. So we open-sourced it and hope it can help you too."
"This is cool and long overdue: The official PostgreSQL extension manager (called pig) has been released and it seems supported by the official PostgreSQL org. So, no more tedious digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches just to install some required extension. We are all pigs now."
"Pigsty is a better local open source RDS for PostgreSQL alternative. I wonder if there anything similar for Redis and MySQL."
"If you ever have to set up a postgres instance for production outside of RDS/Managed, Pigsty is a brilliant implementation"
"Great toolbox: Pigsty - 'PostgreSQL In Great STYle': Postgres, Infras, Graphics, Service, Toolbox, it's all Yours."
"This is neat, self hosted PostgreSQL as a service"
"Looking for a self-hosted PostgreSQL RDS alternative? You won't believe what this project does"
"Pigsty is a software written to solve our own problems. And it does it well. So we open-sourced it and hope it can help you too."
"This is cool and long overdue: The official PostgreSQL extension manager (called pig) has been released and it seems supported by the official PostgreSQL org. So, no more tedious digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches just to install some required extension. We are all pigs now."
"Pigsty is a better local open source RDS for PostgreSQL alternative. I wonder if there anything similar for Redis and MySQL."
"If you ever have to set up a postgres instance for production outside of RDS/Managed, Pigsty is a brilliant implementation"
"Great toolbox: Pigsty - 'PostgreSQL In Great STYle': Postgres, Infras, Graphics, Service, Toolbox, it's all Yours."
"This is neat, self hosted PostgreSQL as a service"
"Looking for a self-hosted PostgreSQL RDS alternative? You won't believe what this project does"
"Pigsty aims to harness the collective power of PostgreSQL ecosystem extensions and democratize access to production-grade database services and with GCP a great start ahead!"
"You can easily now use FerretDB with Pigsty: the a battery-included, local-first, open-source RDS PG alternative."
"Pigsty: PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!"
"Proud for @ParadeDB to be included in Pigsty! Pigsty is truly one of the best ways to run Postgres and its whole ecosystem. Probably the more comprehensive list of extensions in Postgres"
"man... this is so fun, the open source community always have the gold, is the postgres the best!! awesome work from the last released! a bunch of extensions to help community"
"I want to take a moment to express my immense gratitude to the dedicated developers, maintainers, and contributors of the Pigsty project - a remarkable repository."
"Pigsty Is Postgres All Batteries Included. Did I say All? No, it's a little bit more than that."
"Pigsty aims to harness the collective power of PostgreSQL ecosystem extensions and democratize access to production-grade database services and with GCP a great start ahead!"
"You can easily now use FerretDB with Pigsty: the a battery-included, local-first, open-source RDS PG alternative."
"Pigsty: PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!"
"Proud for @ParadeDB to be included in Pigsty! Pigsty is truly one of the best ways to run Postgres and its whole ecosystem. Probably the more comprehensive list of extensions in Postgres"
"man... this is so fun, the open source community always have the gold, is the postgres the best!! awesome work from the last released! a bunch of extensions to help community"
"I want to take a moment to express my immense gratitude to the dedicated developers, maintainers, and contributors of the Pigsty project - a remarkable repository."
"Pigsty Is Postgres All Batteries Included. Did I say All? No, it's a little bit more than that."
"Pigsty, which adopts the currently popular 'fair-code' model for IaaS / PaaS / BaaS / Serverless DB. Unlike M3O (an 'AWS alternative' project) that's geared more toward developers, pigsty is squarely aimed at dba / ops teams."
"If you haven't heard about Pigsty extension repository yet, take a look at this. A lot of extremely useful work has been done! Thanks Vonng for this contribution."
"You can use Pigsty to serve IvorySQL - Oracle compatible PostgreSQL fork as a local-first RDS"
"Pigsty is ideal for managing multiple PG or PolarDB databases, especially if you have extensive extension requirements. Highly recommended!"
"Thanks for including the duckdb_fdw in Pigsty. Hope to see more extensions in the future!"
"IMHO, Pigsty is underrated. It deserves more visibility. Production grade @PostgreSQL but with full control !"
"Pigsty boosts our PostgreSQL expertise and ensures critical use cases for FeatBit's PostgreSQL solution are rock-solid."
"Pigsty, which adopts the currently popular 'fair-code' model for IaaS / PaaS / BaaS / Serverless DB. Unlike M3O (an 'AWS alternative' project) that's geared more toward developers, pigsty is squarely aimed at dba / ops teams."
"If you haven't heard about Pigsty extension repository yet, take a look at this. A lot of extremely useful work has been done! Thanks Vonng for this contribution."
"You can use Pigsty to serve IvorySQL - Oracle compatible PostgreSQL fork as a local-first RDS"
"Pigsty is ideal for managing multiple PG or PolarDB databases, especially if you have extensive extension requirements. Highly recommended!"
"Thanks for including the duckdb_fdw in Pigsty. Hope to see more extensions in the future!"
"IMHO, Pigsty is underrated. It deserves more visibility. Production grade @PostgreSQL but with full control !"
"Pigsty boosts our PostgreSQL expertise and ensures critical use cases for FeatBit's PostgreSQL solution are rock-solid."