PostgreSQL In Great STYle

Battery-Included PostgreSQL Distribution as an Open-Source & Local-First RDS Alternative

Value PropositionGet Started
header

Self-Hosting PostgreSQL Like a Pro

Pigsty provides everything you need for a production-ready PostgreSQL deployment.

Reliable Architecture

Create self-healing HA PG clusters without hassle, with pre-configured PITR, built-in ACL, CA, SSL. Pigsty will take care of all the details for you.

architecture

Infrastructure as Code

Declare your entire infra in the inventory, And materialize it in minutes with playbooks. CloudNative experience without docker/k8s.

cd ~/pigsty; vi pigsty.yml
pg-test:
  hosts:
    10.1.1.1:
      pg_seq: 1
      pg_role: primary
    10.1.1.2:
      pg_seq: 2
      pg_role: replica
    10.1.1.3:
      pg_seq: 3
      pg_role: offline
vars:
    pg_cluster: pg-test
bin/pgsql-add pg-test
HA PG Cluster pg-test created!

Stunning Observability

Unparalleled monitoring best practices built upon modern observability (Prometheus & Grafana) stacks. Reuse them and monitoring existing DBMS & cloud RDS.

architecture

Extensions Overwhelming

400+ PGSQL Extensions battery-included! PG Fork RDS: Babelfish, IvorySQL, PolarDB. Self-hosting Supabase, MinIO, Etcd, Redis...

timescaledbpg_cronpgroutingpointcloudpostgispgvectorpgmlvchordpg_searchpgroongapg_bestmatchcitushydrapg_duckdbpg_mooncakepg_parquetdocumentdbomnigresagepg_graphqlpgmqplv8pljavapg_httppg_curlanonvaultpg_repackmulticornpglogicalwal2json
PostgreSQLDuckDB Logo DuckDBSupabase Logo SupabaseCitus Logo Citus WiltonDBIvorySQL Logo IvorySQL PolarDBNeon Logo NeonGreenplum Logo GreenplumCloudberry Logo Cloudberry
Ferretdb Streamline Icon: https://streamlinehq.comFerretDB FERRET DOCKER REDIS MINIO ETCD NODEfile_type_nginx INFRA PGSQL
Extensible Postgres
AnalyticsAI ReadyGeospatialTime SeriesText SearchLanguagesForeign DataFeatured
Reliable Infra
High AvailabilitySelf-HealingPITR ProtectionSelf-SufficientAccess ControlConfidentialityData IntegrityBattle-Tested
Observable Graphics
Infra Built-inData-DrivenUltimate ExperienceUniversal MonitoringAutomatic AlertsPerformance TuningLog AnalysisCustom Dashboards
Scalable Services
Blazing PerformanceR/W SeparationConnection PoolingLoad BalancingHorizontal ScalingStorage ExpansionMass DeploymentCloud Elasticity
Maintainable Toolbox
Infra as CodeSimple & EasyBare LinuxOffline InstallAdmin SOPNo DowntimeRich ParametersProvisioning
Composable Modules
Modular DesignApp TemplatesCore ModulesExtra ModulesKernel ModulesOLAP ModulesPilot ModulesFlavor Modules
Controllable FOSS
Free SoftwareLocal FirstMulti-CloudFree ExtensionData OwnershipDIY DevelopmentCompliance ReadyExpert Support
Affordable Solution
Open-SourceSave MoreDBA EfficiencySimplified ArchEnable Cloud-ExitCommunity SupportExpert ConsultingSubscription

Trusted by the best companies

Pigsty is used by companies of all sizes to manage their PostgreSQL clusters.

TanTan
Linkfog
Bilibili
AirWallex

Loved by people all over the community

Pigsty is used by thousands of users over the world.

Ready to Soar?

$curl https://repo.pigsty.io/pig | bash
Get Started
Check Demo
Pigsty LogoPIGSTY
Copyright © 2020-2025 Ruohang Feng (Vonng)
All rights reserved
PriceContactSupport
OSS LicensePrivacy PolicyRelease Note中文站点
GitHubTwitterLinkedInTelegramDiscord

PIGSTY