PostgreSQL in Great STYle
The Batteries-Included PostgreSQL Distribution
Self-hosted. Open Source. Production Ready.
$
curl -fsSL https://repo.pigsty.io/get | bash
The Batteries-Included PostgreSQL Distribution
Self-hosted. Open Source. Production Ready.
curl -fsSL https://repo.pigsty.io/get | bash
HA, PITR, Sec, Observability, how long to master them all?
Without a senior DBA.
Missing some extension on the cloud?
Build from scratch or combine random images?
5-20x the cost of bare metal — for lame EBS?
The bigger you scale, the deeper you're locked in.
Pigsty solves all of this—and it's free and open source.
Four pillars that let you self-hosting PostgreSQL like a Pro
# 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 ]}
Pigsty unlocks the full potential of PostgreSQL Extension Catalog Kernel Forks
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."
