PostgreSQL in Great STYle
开箱即用的 PostgreSQL 发行版，本地优先的 FLOSS RDS
$
curl -fsSL https://repo.pigsty.cc/get | bash
开箱即用的 PostgreSQL 发行版，本地优先的 FLOSS RDS
curl -fsSL https://repo.pigsty.cc/get | bash
HA/PITR/安全/监控，全整明白要多久？
没有专业 DBA，花样太多，玩不转也学不动
要个 pg_duckdb，云上功能阉割不提供？
自己编译？零散的源码与独立镜像难堪大用
比裸金属贵 5-20 倍，天价买来渣渣云服务
规模越大，出血越痛，还被云厂商牢牢锁死
Pigsty 为你解决所有这些问题，而且 开源免费
四大核心能力，让你像专家一样管理 PostgreSQL
# pigsty.yml - 定义一个3节点HA集群 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 ]}
假设：4核16G，3节点 HA 集群，一年费用对比
* 实际节省取决于规模和配置，但 5-10 倍的差距是真实的。规模越大，省的越多。
我们用 Pigsty 管理了上百套 PostgreSQL 集群，250 万 PG QPS
只用了 1.5 个 DBA，总 TCO 成本是公有云的 5% —— 探探
看看大家怎么说
"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."
curl -fsSL https://repo.pigsty.cc/get | bash