PG Kernels
In Pigsty, you can replace the native PostgreSQL kernel with a variant that provides specialized features.
Pigsty supports multiple PostgreSQL kernels and compatibility branches within one operational framework. These kernels provide compatibility layers, multi-master replication, graph queries, MPP warehousing, transparent encryption, and other features.
The level of Pigsty integration differs between kernels.
PostgreSQL, Citus, Babelfish, IvorySQL, PolarDB, AgensGraph, and pgEdge have defined templates and configuration procedures.
Cloudberry and Greenplum usually use gpsql mode.
For their MPP initialization and scale-out operations, upstream tools remain the preferred method.
| Kernel | Key Feature | Description |
|---|---|---|
| PostgreSQL | Native kernel, full extension set | Vanilla PostgreSQL with 625 extensions |
| Supabase | Backend as a Service | PostgreSQL-based BaaS, Firebase alternative |
| Citus | Horizontal scaling | Distributed PostgreSQL via native extension |
| Babelfish | SQL Server compatible | SQL Server wire-protocol compatibility (PG17/18) |
| IvorySQL | Oracle compatible | Oracle syntax and PL/SQL compatibility |
| OpenHalo | MySQL compatible | MySQL wire-protocol compatibility |
| Percona | Transparent data encryption | Percona distribution with pg_tde |
| DocumentDB | Native PostgreSQL; use the instance’s SELECT version() | Native PostgreSQL; use the instance’s SELECT version() |
| OrioleDB | OLTP optimization | UNDO-based storage engine with index-organized tables and S3 support |
| PolarDB | Aurora-style RAC | RAC, China-local compliance scenario |
| Cloudberry | Open-source MPP warehouse | Cloudberry integrated through gpsql mode |
| AgensGraph | Property graph + Cypher | Graph query capability inside PostgreSQL |
| pgEdge | Spock multi-master replication | Distributed PostgreSQL for edge scenarios |

Versions
Templates mainly select a PostgreSQL major version and kernel package aliases; repositories on the target platform determine patch versions. The table summarizes current delivered baselines: native PGDG PostgreSQL 18 is 18.7, while forks build on branches such as 18.6, 17.10, or 14.18. Extension tables on kernel pages are configuration references; installed packages determine actual versions and availability.
Check the target instance’s version and available extensions:
| Kernel | Debian / Ubuntu | EL |
|---|---|---|
| PostgreSQL / Citus | Native PostgreSQL, PG18 baseline 18.7; verify with SELECT version() | Native PostgreSQL, PG18 baseline 18.7; verify with SELECT version() |
| IvorySQL | IvorySQL 5.6, based on PostgreSQL 18.6 | IvorySQL 5.6, based on PostgreSQL 18.6 |
| Babelfish | Babelfish 6.2.0, supports PG17 / PostgreSQL 18.6 | Babelfish 6.2.0, supports PG17 / PostgreSQL 18.6 |
| PolarDB | PostgreSQL 17.10 (PolarDB 17.10.1.0 build accf02e2) on x86_64-linux-gnu | PostgreSQL 17.10 (PolarDB 17.10.1.0 build accf02e2) on x86_64-linux-gnu |
| Percona | Percona Server for PostgreSQL 18.6.1, based on PostgreSQL 18.6, with pg_tde 2.2.2 | Percona Server for PostgreSQL 18.6.1, based on PostgreSQL 18.6, with pg_tde 2.2.2 |
| OrioleDB | OrioleDB 1.10.3, based on PostgreSQL 18.6 | OrioleDB 1.10.3, based on PostgreSQL 18.6 |
| OpenHalo | openHalo 14.18 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 15.2.0-16ubuntu1) 15.2.0, 64-bit | openHalo 14.18 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 14.3.1 20251022 (Red Hat 14.3.1-4), 64-bit |
| DocumentDB | Native PostgreSQL, PG18 baseline 18.7; verify with SELECT version() | Native PostgreSQL, PG18 baseline 18.7; verify with SELECT version() |
| AgensGraph | AgensGraph 2.18.6.1, based on PostgreSQL 18.6 | AgensGraph 2.18.6.1, based on PostgreSQL 18.6 |
| pgEdge | pgEdge 18.6-3PGSTY, based on PostgreSQL 18.6, with Spock 5.0.13 | pgEdge 18.6-3PGSTY, based on PostgreSQL 18.6, with Spock 5.0.13 |
| Cloudberry | PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating build 1) on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-11), 64-bit |
Vanilla PostgreSQL with access to Pigsty’s catalog of 625 packaged extensions
How to self-host Supabase with Pigsty, deploy an open-source Firebase alternative with a complete backend stack in one click.
Use Babelfish (PG17/18) in Pigsty to provide SQL Server protocol/T-SQL compatibility.
Percona Postgres distribution with TDE transparent encryption support
MySQL-compatible Postgres 14 branch
Next-generation OLTP engine for PostgreSQL
Use the Cloudberry open-source MPP data warehouse kernel in Pigsty and manage nodes, monitoring, and configuration through gpsql mode.
Use the AgensGraph (PG18) graph database kernel in Pigsty to get property graph and Cypher/SQL hybrid query capabilities within the PostgreSQL ecosystem.
Use the pgEdge (PG15-18) kernel in Pigsty to build distributed PostgreSQL for edge scenarios on top of Spock multi-master logical replication.
DocumentDB and FerretDB provide MongoDB wire-protocol compatibility
Deploy high-availability Citus clusters with Pigsty. Scale PostgreSQL across shards and accelerate OLTP/OLAP queries.
Use HighGo’s open-source IvorySQL kernel to achieve Oracle syntax/PLSQL compatibility based on PostgreSQL clusters.
Using Alibaba Cloud’s open-source PolarDB for PostgreSQL kernel to provide domestic innovation qualification support, with Oracle RAC-like user experience.
Using Alibaba Cloud’s commercial PolarDB for Oracle kernel (closed source, PG14, only available in special enterprise edition customization)
How to deploy PostgresML with Pigsty: ML, training, inference, Embedding, RAG inside DB.
Deploy and monitor Greenplum clusters with Pigsty to build Massively Parallel Processing (MPP) PostgreSQL data warehouses.
Use Neon’s open-source Serverless PostgreSQL kernel to build flexible, scale-to-zero, forkable PG services.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)