OPEN-SOURCE POSTGRESQL DISTRIBUTION Open-Source · Local-First · Battery-Included

PostgreSQL In Great STYle

Enterprise-Grade Open-Source PG Distribution HA, PITR, IaC, Monitor, and 530+ PG extensions

Get Started Live Demo

$ curl -fsSL https://repo.pigsty.io/get | bash

Pigsty architecture board: PostgreSQL kernel, etcd, Grafana, extensions and backup components

PG Kernel 531 Exts Etcd DCS Grafana UI MinIO Backup Victoria TSDB

FEATURES

Self-host Postgres like a PRO

Everything you need for enterprise-grade PostgreSQL. Open source and Free

01 · HIGH AVAILABILITY

Reliable Architecture

Self-healing. Sleep tight

Auto-failover with Patroni + etcd. Traffic routed via HAProxy + PgBouncer
Point-in-time recovery with pgBackRest. Undo any mistake in minutes
Secure by default: local CA, TLS, ACL, SELinux/Firewall — all auto-configured

No more 3 AM pages. Wake up rested, fix things over coffee

Pigsty HA architecture: Patroni, etcd, HAProxy, pgBackRest

02 · INFRA AS CODE

Stunning Observability

Full visibility. No blind spots

Best-of-breed observability stack: Grafana + Victoria
3000+ metrics, 40+ curated dashboards. Ready out of the box
Works standalone — monitor your existing RDS or Postgres as-is

Instant diagnosis. No more guesswork

04 · EXTENSIONS

Batteries Included

Fully packed. Plug and play

531 PG extensions across 16 Linux distros, ready to install
12 PG kernel forks, one meta-distribution to rule them all
Modules: MinIO, Redis, Docker, JuiceFS, Supabase and more

Install what you want. Full freedom, full control

ECOSYSTEM

Ultimate Extensibility

Unlock the full potential of PostgreSQL

PG Kernels Extensions Modules

Supabase Backend as a Service

Citus Horizontally Distributed

Babelfish SQL Server Compatible

IvorySQL Oracle Compatible

OpenHalo MySQL Compatible

FerretDB MongoDB Compatible

OrioleDB OLTP Optimized

pgEdge Multi-Master Geo-Dist

Percona Transparent Data Encryption

PolarDB PG Cloud-Native RAC

AgensGraph Multi-Model Graph

Cloudberry PG MPP Warehouse

EXTENSION BUS · 531 PIN

timescaledb timescaledb_toolkit pg_timeseries periods temporal_tables emaj table_version pg_cron pg_task pg_later pg_background postgis pgrouting pointcloud pg_h3 q3c ogr_fdw geoip pg_polyline pg_eviltransform pg_geohash mobilitydb pg_tzf earthdistance pgvector vchord pgvectorscale pg_vectorize pg_similarity smlar pg_summarize pg_tiktoken pg4ml pgml pg_search pgroonga pg_bigm zhparser pg_bestmatch vchord_bm25 pg_tokenizer pg_biscuit pg_textsearch pg_pinyin hunspell_cs_cz hunspell_de_de hunspell_en_us hunspell_fr hunspell_ne_np hunspell_nl_nl hunspell_nn_no hunspell_pt_pt hunspell_ru_ru hunspell_ru_ru_aot fuzzystrmatch pg_trgm citus hydra pg_analytics pg_duckdb pg_mooncake pg_clickhouse duckdb_fdw pg_parquet pg_fkpart pg_partman plproxy pg_strom tablefunc age hll rum pg_ai_query pg_ttl_index pg_graphql pg_jsonschema jsquery pg_hint_plan hypopg index_advisor pg_plan_filter imgsmlr pg_ivm pg_incremental pgmb pgmq pgq orioledb pg_cardano rdkit omnigres bloom pg_tle plv8 pljs pllua plprql pldebugger timescaledb timescaledb_toolkit pg_timeseries periods temporal_tables emaj table_version pg_cron pg_task pg_later pg_background postgis pgrouting pointcloud pg_h3 q3c ogr_fdw geoip pg_polyline pg_eviltransform pg_geohash mobilitydb pg_tzf earthdistance pgvector vchord pgvectorscale pg_vectorize pg_similarity smlar pg_summarize pg_tiktoken pg4ml pgml pg_search pgroonga pg_bigm zhparser pg_bestmatch vchord_bm25 pg_tokenizer pg_biscuit pg_textsearch pg_pinyin hunspell_cs_cz hunspell_de_de hunspell_en_us hunspell_fr hunspell_ne_np hunspell_nl_nl hunspell_nn_no hunspell_pt_pt hunspell_ru_ru hunspell_ru_ru_aot fuzzystrmatch pg_trgm citus hydra pg_analytics pg_duckdb pg_mooncake pg_clickhouse duckdb_fdw pg_parquet pg_fkpart pg_partman plproxy pg_strom tablefunc age hll rum pg_ai_query pg_ttl_index pg_graphql pg_jsonschema jsquery pg_hint_plan hypopg index_advisor pg_plan_filter imgsmlr pg_ivm pg_incremental pgmb pgmq pgq orioledb pg_cardano rdkit omnigres bloom pg_tle plv8 pljs pllua plprql pldebugger

plpgsql_check plprofiler plsh pljava plr plxslt pgtap faker dbt2 pltcl plperl plperlu plpgsql plpython3u pg_prefix pg_semver pgunit pgpdf pglite_fusion md5hash asn1oid pg_roaringbitmap pgfaceting pgsphere pg_country pg_xenophile pg_currency pgcollection pgmp numeral pg_rational pguint pg_uint128 hashtypes ip4r pg_duration pg_uri pg_emailaddr pg_acl debversion pg_rrule timestamp9 chkpass isn seg cube ltree hstore citext xml2 pg_gzip pg_bzip pg_zstd pg_http pg_net pg_curl pg_retry pgjq pgjwt pg_smtp_client pg_html5_email_address url_encode pgsql_tweaks pg_extra_time pgpcre icu_ext pgqr pg_protobuf pg_envvar floatfile pg_render pg_readme ddl_historization data_historization pg_schedoc pg_hashlib pg_xxhash shacrypt cryptint pg_ecdsa pgsparql pg_idkit pgx_ulid pg_uuidv7 permuteseq pg_hashids sequential_uuids pg_typeid snowflake topn quantile lower_quantile count_distinct omnisketch ddsketch vasco pgxicor pg_weighted_statistics tdigest first_last_agg extra_window_functions plpgsql_check plprofiler plsh pljava plr plxslt pgtap faker dbt2 pltcl plperl plperlu plpgsql plpython3u pg_prefix pg_semver pgunit pgpdf pglite_fusion md5hash asn1oid pg_roaringbitmap pgfaceting pgsphere pg_country pg_xenophile pg_currency pgcollection pgmp numeral pg_rational pguint pg_uint128 hashtypes ip4r pg_duration pg_uri pg_emailaddr pg_acl debversion pg_rrule timestamp9 chkpass isn seg cube ltree hstore citext xml2 pg_gzip pg_bzip pg_zstd pg_http pg_net pg_curl pg_retry pgjq pgjwt pg_smtp_client pg_html5_email_address url_encode pgsql_tweaks pg_extra_time pgpcre icu_ext pgqr pg_protobuf pg_envvar floatfile pg_render pg_readme ddl_historization data_historization pg_schedoc pg_hashlib pg_xxhash shacrypt cryptint pg_ecdsa pgsparql pg_idkit pgx_ulid pg_uuidv7 permuteseq pg_hashids sequential_uuids pg_typeid snowflake topn quantile lower_quantile count_distinct omnisketch ddsketch vasco pgxicor pg_weighted_statistics tdigest first_last_agg extra_window_functions

floatvec aggs_for_vecs aggs_for_arrays pg_csv pg_arraymath pg_math pg_random pg_base36 pg_base62 pg_base58 pg_financial pg_convert refint autoinc insert_username moddatetime tsm_system_time dict_xsyn tsm_system_rows tcn uuid-ossp btree_gist btree_gin intarray intagg dict_int unaccent pg_repack pg_rewrite pg_squeeze pg_dirtyread pgfincore pg_cooldown pg_ddlx pglinter pg_prioritize pg_checksums pg_readonly pgdd pg_permissions pgautofailover pg_catcheck preprepare pg_upless pgcozy pg_orphaned pg_crash pg_cheat_funcs pg_fio pg_qos pg_savior safeupdate pg_strict pg_drop_events table_log pgagent pg_prewarm pgpool lo basic_archive basebackup_to_shell old_snapshot adminpack amcheck pg_surgery pg_profile pg_tracing pg_show_plans pg_stat_kcache pg_stat_monitor pg_qualstats pg_store_plans pg_track_settings pg_track_optimizer pg_wait_sampling pgsentinel system_stats pg_meta pgnodemx pg_sqlog bgw_replstatus pgmeminfo toastinfo pg_explain_ui pg_relusage pagevis powa pg_overexplain pg_logicalinspect pageinspect pgrowlocks sslinfo pg_buffercache pg_walinspect pg_freespacemap pg_visibility pgstattuple auto_explain pg_stat_statements floatvec aggs_for_vecs aggs_for_arrays pg_csv pg_arraymath pg_math pg_random pg_base36 pg_base62 pg_base58 pg_financial pg_convert refint autoinc insert_username moddatetime tsm_system_time dict_xsyn tsm_system_rows tcn uuid-ossp btree_gist btree_gin intarray intagg dict_int unaccent pg_repack pg_rewrite pg_squeeze pg_dirtyread pgfincore pg_cooldown pg_ddlx pglinter pg_prioritize pg_checksums pg_readonly pgdd pg_permissions pgautofailover pg_catcheck preprepare pg_upless pgcozy pg_orphaned pg_crash pg_cheat_funcs pg_fio pg_qos pg_savior safeupdate pg_strict pg_drop_events table_log pgagent pg_prewarm pgpool lo basic_archive basebackup_to_shell old_snapshot adminpack amcheck pg_surgery pg_profile pg_tracing pg_show_plans pg_stat_kcache pg_stat_monitor pg_qualstats pg_store_plans pg_track_settings pg_track_optimizer pg_wait_sampling pgsentinel system_stats pg_meta pgnodemx pg_sqlog bgw_replstatus pgmeminfo toastinfo pg_explain_ui pg_relusage pagevis powa pg_overexplain pg_logicalinspect pageinspect pgrowlocks sslinfo pg_buffercache pg_walinspect pg_freespacemap pg_visibility pgstattuple auto_explain pg_stat_statements

passwordcheck_cracklib supautils pgsodium pg_vault pg_session_jwt pg_anon pgsmcrypto pg_enigma pgaudit pgauditlogtofile pg_auditor logerrors pg_auth_mon pg_jobmon credcheck pgcryptokey pg_pwhash login_hook set_user pg_snakeoil pgextwlist sslutils pg_noset pg_tde sepgsql auth_delay pgcrypto passwordcheck wrappers multicorn odbc_fdw jdbc_fdw pgspider_ext mysql_fdw oracle_fdw tds_fdw db2_fdw sqlite_fdw pgbouncer_fdw etcd_fdw informix_fdw nominatim_fdw mongo_fdw redis_fdw pg_redis_pubsub kafka_fdw hdfs_fdw firebird_fdw aws_s3 log_fdw dblink file_fdw postgres_fdw documentdb orafce pgtt session_variable pg_statement_rollback ivorysql pg_dbms_metadata pg_dbms_lock pg_dbms_job pg_dbms_errlog pg_utl_smtp babelfish spat pgmemcache openhalo pglogical pglogical_ticker pgl_ddl_deploy pg_failover_slots db_migrator pgactive spock lolor wal2json wal2mongo decoderbufs decoder_raw mimeo repmgr pg_fact_loader pg_bulkload test_decoding pgoutput passwordcheck_cracklib supautils pgsodium pg_vault pg_session_jwt pg_anon pgsmcrypto pg_enigma pgaudit pgauditlogtofile pg_auditor logerrors pg_auth_mon pg_jobmon credcheck pgcryptokey pg_pwhash login_hook set_user pg_snakeoil pgextwlist sslutils pg_noset pg_tde sepgsql auth_delay pgcrypto passwordcheck wrappers multicorn odbc_fdw jdbc_fdw pgspider_ext mysql_fdw oracle_fdw tds_fdw db2_fdw sqlite_fdw pgbouncer_fdw etcd_fdw informix_fdw nominatim_fdw mongo_fdw redis_fdw pg_redis_pubsub kafka_fdw hdfs_fdw firebird_fdw aws_s3 log_fdw dblink file_fdw postgres_fdw documentdb orafce pgtt session_variable pg_statement_rollback ivorysql pg_dbms_metadata pg_dbms_lock pg_dbms_job pg_dbms_errlog pg_utl_smtp babelfish spat pgmemcache openhalo pglogical pglogical_ticker pgl_ddl_deploy pg_failover_slots db_migrator pgactive spock lolor wal2json wal2mongo decoderbufs decoder_raw mimeo repmgr pg_fact_loader pg_bulkload test_decoding pgoutput

Browse All 531 Extensions

OBSERVABILITY

40+ curated dashboards. Every detail, in real time

Open Live Demo

USE CASES

Trusted by Companies Across Industries

100+PG Clusters

25KvCPU Cores

2.5MPeak QPS

2DBAs

5%Cloud TCO

"We run 100+ PostgreSQL clusters at 2.5M QPS with just 2 DBAs,
our TCO is 5% of public cloud."

— Tantan · Production Field Report

5210 GitHub Stars

25000 vCPUs Battle-Tested

6+ Years in Development #1 PG Extension Catalog

COMMUNITY

Join the Community

See what people are saying

GitHub Discord Telegram WeChat

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.

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

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

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

Spiritus Movens / Serendipitous Planner

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

Paul Hewson

Data Scientist / Statistician

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

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

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.

Junior DBA & Full-Stack Developer

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

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

Spiritus Movens / Serendipitous Planner

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

Paul Hewson

Data Scientist / Statistician

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

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.

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ź

Director of FerretDB

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

Peter Zaitsev

Entrepreneur | Technologist

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

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

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ɔɐɿɈ

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

Founder @ Omnigres

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

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ź

Director of FerretDB

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

Peter Zaitsev

Entrepreneur | Technologist

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

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

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ɔɐɿɈ

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

Founder @ Omnigres

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

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

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

President at Highgo Software

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

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

Author of duckdb_fdw

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

Vignesh Ravichandran

Postgres Contributor

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

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

Architect, Hacker

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

President at Highgo Software

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

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

Author of duckdb_fdw

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

Vignesh Ravichandran

Postgres Contributor

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

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

Up and Running in Minutes

Three commands to deliver an enterprise-grade PostgreSQL cluster

1 Install

curl https://pigsty.io/get | bash

2 Configure

./configure

3 Deploy

./deploy.yml

Standard InstallQuick start with Internet Offline InstallAir-gapped environments Minimal InstallHA PostgreSQL only

Supported Platforms: Linux x86_64 / Arm64 · EL 8 / 9 / 10 · Ubuntu 22 / 24 / 26 · Debian 12 / 13

Get Started Live Demo Get Support