PostgreSQL
Vanilla PostgreSQL kernel with 440 extensions
Kernel Forks
How to use other PostgreSQL kernel forks in Pigsty? Such as Citus, Babelfish, IvorySQL, PolarDB, etc.
In Pigsty, you can replace the “native PG kernel” with different “flavors” of PostgreSQL forks to achieve special features and effects.
Pigsty supports various PostgreSQL kernels and compatible forks, enabling you to simulate different database systems while leveraging PostgreSQL’s ecosystem. Each kernel provides unique capabilities and compatibility layers.
| Kernel | Key Feature | Description |
|---|---|---|
| PostgreSQL | Original Flavor | Vanilla PostgreSQL with 440 extensions |
| Citus | Horizontal Scaling | Distributed PostgreSQL via native extension |
| WiltonDB | SQL Server Compatible | SQL Server wire-protocol compatibility |
| IvorySQL | Oracle Compatible | Oracle syntax and PL/SQL compatibility |
| OpenHalo | MySQL Compatible | MySQL wire-protocol compatibility |
| Percona | Transparent Encryption | Percona Distribution with pg_tde |
| FerretDB | MongoDB Migration | MongoDB wire-protocol compatibility |
| OrioleDB | OLTP Optimization | Zheap, No bloat, S3 Storage |
| PolarDB | Aurora-style RAC | RAC, China domestic compliance |
| Supabase | Backend as a Service | BaaS based on PostgreSQL, Firebase alternative |
| Cloudberry | MPP DW & Analytics | Massively parallel processing data warehouse |
Supabase
How to self-host Supabase with Pigsty, deploy an open-source Firebase alternative with a complete backend stack in one click.
Percona
Percona Postgres distribution with TDE transparent encryption support
OpenHalo
MySQL compatible Postgres 14 fork
OrioleDB
Next-generation OLTP engine for PostgreSQL
Citus
Deploy native high-availability Citus horizontally sharded clusters with Pigsty, seamlessly scaling PostgreSQL across multiple shards and accelerating OLTP/OLAP queries.
Babelfish
Create Microsoft SQL Server compatible PostgreSQL clusters using WiltonDB and Babelfish! (Wire protocol level compatibility)
IvorySQL
Use HighGo’s open-source IvorySQL kernel to achieve Oracle syntax/PLSQL compatibility based on PostgreSQL clusters.
PolarDB PG
Using Alibaba Cloud’s open-source PolarDB for PostgreSQL kernel to provide domestic innovation qualification support, with Oracle RAC-like user experience.
PolarDB Oracle
Using Alibaba Cloud’s commercial PolarDB for Oracle kernel (closed source, PG14, only available in special enterprise edition customization)
PostgresML
How to deploy PostgresML with Pigsty: ML, training, inference, Embedding, RAG inside DB.
Greenplum
Deploy/Monitor Greenplum clusters with Pigsty, build Massively Parallel Processing (MPP) PostgreSQL data warehouse clusters!
Cloudberry
Deploy/Monitor Cloudberry clusters with Pigsty, an MPP data warehouse cluster forked from Greenplum!
Neon
Use Neon’s open-source Serverless PostgreSQL kernel to build flexible, scale-to-zero, forkable PG services.
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.