文档 扩展 博客 服务 English GitHub

FEATURES · 核心特性

像专家一样自建 PostgreSQL

Pigsty 为您提供自建企业级 PostgreSQL 服务所需的一切,开源免费,自主可控

01 · HIGH AVAILABILITY

高可用标杆架构

故障自愈,高枕无忧

  • 基于 Patroni + Etcd 自动故障切换,HAProxy 流量自动均衡
  • 预置 pgBackRest PITR 时间点恢复,删库跑路也能找回数据
  • 内置 SSL/TLS 加密与访问控制模型,SELinux 防火墙全搞定

告别半夜故障值班 OnCall,硬件故障睡醒起来再修复

Pigsty 高可用架构:Patroni、etcd、HAProxy、pgBackRest

02 · INFRA AS CODE

基础设施即代码

言出法随,一键部署

  • 声明式配置,幂等性执行,Pigsty 式 IaC,无需操心细节
  • 海量可定制项,生产开发测试共享一套架构,仅配置不同
  • Ansible 幂等剧本,无需 K8s & Docker,裸机玩转云原生

一键复刻完整生产环境,单枪匹马管理海量集群

03 · OBSERVABILITY

可观测性技术栈

洞若观火,尽在掌握

  • 基于 Grafana + Victoria 的 SOTA 可观测性技术栈
  • 3000+ 监控指标,40+ 精调仪表盘,免配置开箱即用
  • 可独立部署使用,监控现有 RDS / PostgreSQL 实例

快速定位问题,数据驱动决策,告别空对空无效扯皮

Pigsty 监控仪表盘全家福

04 · EXTENSIONS

数据库扩展生态

海纳百川,开箱即用

  • 576 个 PostgreSQL 扩展,覆盖 16 个 Linux 系统,即装即用
  • 12 种 PG 内核:兼容 Oracle, SQL Server, MySQL, Mongo…
  • 功能模块:MinIO、Redis、Docker、Supabase 自建

灵活组合搭配,自由按需拼接,完全自主可控

PostgreSQL 扩展生态全景图

SIGNAL OUT · 观测输出

40+ 精调仪表盘,实时呈现每一个细节

打开在线演示

FIELD PROVEN · 生产验证

为各行各业所信赖

探探 Bilibili Airwallex Momenta 美图 PolarDB Bitdeer OCI 华峰 Linkfog Motphys 影视飓风 探探 Bilibili Airwallex Momenta 美图 PolarDB Bitdeer OCI 华峰 Linkfog Motphys 影视飓风
100+PG 集群
250峰值 QPS
1.5位 DBA
5%公有云 TCO
「我们用 Pigsty 管理了上百套 PostgreSQL 集群,250 万 PG QPS,
俩 DBA,总 TCO 成本是公有云的 5%。」
—— 探探 · 生产环境实录

COMMUNITY · 社区之声

加入社区

看看大家怎么说

Ruohang Feng
Ruohang Feng
Founder @ Pigsty

"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."

Vedran B.
Vedran B.
Junior DBA & Full-Stack Developer

"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."

Terry Zheng
Terry Zheng
Senior Software Engineer

"Pigsty is a better local open source RDS for PostgreSQL alternative. I wonder if there anything similar for Redis and MySQL."

Darragh ORiordan
Darragh ORiordan
Principal Engineer & Cloud Architect

"If you ever have to set up a postgres instance for production outside of RDS/Managed, Pigsty is a brilliant implementation"

Grzegorz Głąb
Grzegorz Głąb
Spiritus Movens / Serendipitous Planner

"Great toolbox: Pigsty - 'PostgreSQL In Great STYle': Postgres, Infras, Graphics, Service, Toolbox, it's all Yours."

Paul Hewson
Paul Hewson
Data Scientist / Statistician

"This is neat, self hosted PostgreSQL as a service"

François-Guillaume Ribreau
François-Guillaume Ribreau
Hacker, Maker, Tech Advisor

"Looking for a self-hosted PostgreSQL RDS alternative? You won't believe what this project does"

Ruohang Feng
Ruohang Feng
Founder @ Pigsty

"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."

Vedran B.
Vedran B.
Junior DBA & Full-Stack Developer

"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."

Terry Zheng
Terry Zheng
Senior Software Engineer

"Pigsty is a better local open source RDS for PostgreSQL alternative. I wonder if there anything similar for Redis and MySQL."

Darragh ORiordan
Darragh ORiordan
Principal Engineer & Cloud Architect

"If you ever have to set up a postgres instance for production outside of RDS/Managed, Pigsty is a brilliant implementation"

Grzegorz Głąb
Grzegorz Głąb
Spiritus Movens / Serendipitous Planner

"Great toolbox: Pigsty - 'PostgreSQL In Great STYle': Postgres, Infras, Graphics, Service, Toolbox, it's all Yours."

Paul Hewson
Paul Hewson
Data Scientist / Statistician

"This is neat, self hosted PostgreSQL as a service"

François-Guillaume Ribreau
François-Guillaume Ribreau
Hacker, Maker, Tech Advisor

"Looking for a self-hosted PostgreSQL RDS alternative? You won't believe what this project does"

Anirudha S.
Anirudha S.
Enterprise Architect

"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!"

Marcin Gwóźdź
Marcin Gwóźdź
Director of FerretDB

"You can easily now use FerretDB with Pigsty: the a battery-included, local-first, open-source RDS PG alternative."

Peter Zaitsev
Peter Zaitsev
Entrepreneur | Technologist

"Pigsty: PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!"

Philippe Noël
Philippe Noël
Founder @ ParadeDB

"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"

Broken Mind
Broken Mind
Cognitive Sys Optimization Engineer

"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"

ɘɿuɔɐɿɈ
ɘɿuɔɐɿɈ
Architect

"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."

Yurii Rashkovskii
Yurii Rashkovskii
Founder @ Omnigres

"Pigsty Is Postgres All Batteries Included. Did I say All? No, it's a little bit more than that."

Anirudha S.
Anirudha S.
Enterprise Architect

"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!"

Marcin Gwóźdź
Marcin Gwóźdź
Director of FerretDB

"You can easily now use FerretDB with Pigsty: the a battery-included, local-first, open-source RDS PG alternative."

Peter Zaitsev
Peter Zaitsev
Entrepreneur | Technologist

"Pigsty: PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!"

Philippe Noël
Philippe Noël
Founder @ ParadeDB

"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"

Broken Mind
Broken Mind
Cognitive Sys Optimization Engineer

"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"

ɘɿuɔɐɿɈ
ɘɿuɔɐɿɈ
Architect

"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."

Yurii Rashkovskii
Yurii Rashkovskii
Founder @ Omnigres

"Pigsty Is Postgres All Batteries Included. Did I say All? No, it's a little bit more than that."

Dexter Yang
Dexter Yang
Architect, Hacker

"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."

Vitaliy Kukharik
Vitaliy Kukharik
Founder & CTO @ Autobase

"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."

Grant Zhou
Grant Zhou
President at Highgo Software

"You can use Pigsty to serve IvorySQL - Oracle compatible PostgreSQL fork as a local-first RDS"

Digoal Zhou
Digoal Zhou
PostgreSQL Expert

"Pigsty is ideal for managing multiple PG or PolarDB databases, especially if you have extensive extension requirements. Highly recommended!"

Steven Lee
Steven Lee
Author of duckdb_fdw

"Thanks for including the duckdb_fdw in Pigsty. Hope to see more extensions in the future!"

Vignesh Ravichandran
Vignesh Ravichandran
Postgres Contributor

"IMHO, Pigsty is underrated. It deserves more visibility. Production grade @PostgreSQL but with full control !"

Bo Hu
Bo Hu
Co-founder of FeatBit

"Pigsty boosts our PostgreSQL expertise and ensures critical use cases for FeatBit's PostgreSQL solution are rock-solid."

Dexter Yang
Dexter Yang
Architect, Hacker

"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."

Vitaliy Kukharik
Vitaliy Kukharik
Founder & CTO @ Autobase

"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."

Grant Zhou
Grant Zhou
President at Highgo Software

"You can use Pigsty to serve IvorySQL - Oracle compatible PostgreSQL fork as a local-first RDS"

Digoal Zhou
Digoal Zhou
PostgreSQL Expert

"Pigsty is ideal for managing multiple PG or PolarDB databases, especially if you have extensive extension requirements. Highly recommended!"

Steven Lee
Steven Lee
Author of duckdb_fdw

"Thanks for including the duckdb_fdw in Pigsty. Hope to see more extensions in the future!"

Vignesh Ravichandran
Vignesh Ravichandran
Postgres Contributor

"IMHO, Pigsty is underrated. It deserves more visibility. Production grade @PostgreSQL but with full control !"

Bo Hu
Bo Hu
Co-founder of FeatBit

"Pigsty boosts our PostgreSQL expertise and ensures critical use cases for FeatBit's PostgreSQL solution are rock-solid."

GET STARTED · 快速开始

轻松交付,立等可取

三条命令,十分钟交付一套企业级 PostgreSQL

curl https://pigsty.cc/get | bash
./configure
./deploy.yml

支持系统:Linux x86_64 / Arm64 · EL 8 / 9 / 10 · Ubuntu 22 / 24 / 26 · Debian 12 / 13