Download & Install

Pre-built native RPM and DEB packages for pg_mooncake (including the embedded moonlink ingestion engine and duckdb_mooncake DuckDB extension) are published across 16 Linux OS / CPU architecture targets (el8, el9, el10, d12, d13, u22, u24, u26 × x86_64 / aarch64) for PostgreSQL 14, 15, 16, 17, and 18 (80 binary packages across 5 PostgreSQL major versions).

Quick Installation

1 · Install with PIG Package Manager (Recommended)

We recommend installing pg_mooncake and its required companion extension pg_duckdb with pig — the PostgreSQL package manager maintained by PGSTY. pig automatically detects your Linux distribution and CPU architecture, configures the upstream PGDG and Pigsty repositories, and installs both extensions in one command.

# 1. Install the pig CLI package manager
curl -fsSL https://repo.pigsty.io/pig | bash

# 2. Configure PGDG + Pigsty PGSQL repositories and update repo cache
pig repo add pgsql -u

# 3. Install pg_duckdb and pg_mooncake (auto-detects active PG version, or pass -v 18)
pig install pg_duckdb pg_mooncake

# 1. Install the pig CLI via the mainland China mirror
curl -fsSL https://repo.pigsty.cc/pig | bash

# 2. Configure repositories using the China CDN mirror (-r china)
pig repo add pgsql -u -r china

# 3. Install pg_duckdb and pg_mooncake (or specify PG major version with -v 18)
pig install pg_duckdb pg_mooncake

# Once the Pigsty APT repository is configured, install for your PostgreSQL major version (e.g. PG 18):
sudo apt-get update
sudo apt-get install -y \
  postgresql-18-pg-duckdb \
  postgresql-18-pg-mooncake

# Once the Pigsty YUM repository is configured, install for your PostgreSQL major version (e.g. PG 18):
sudo dnf install -y \
  pg_duckdb_18 \
  pg_mooncake_18

2 · Configure postgresql.conf & Enable Extension

pg_mooncake requires wal_level = logical (for Moonlink logical replication) and preloading both pg_duckdb and pg_mooncake in shared_preload_libraries:

-- 1. Configure logical replication, shared_preload_libraries, and DuckDB extension loading
ALTER SYSTEM SET wal_level = 'logical';
ALTER SYSTEM SET shared_preload_libraries = 'pg_duckdb,pg_mooncake';
ALTER SYSTEM SET duckdb.allow_community_extensions = 'true';
ALTER SYSTEM SET duckdb.allow_unsigned_extensions = 'true';

Restart PostgreSQL (sudo systemctl restart postgresql-18 or pig pg restart), then connect to your target database and enable the extension:

-- 2. Enable pg_mooncake (CASCADE automatically enables pg_duckdb 1.2.0)
CREATE EXTENSION IF NOT EXISTS pg_mooncake CASCADE;

3 · Container Images (Obsolete)

# Historical upstream container (PostgreSQL 17 + legacy pg_mooncake)
docker run --name mooncake-demo \
  -e POSTGRES_HOST_AUTH_METHOD=trust \
  -p 5432:5432 -d \
  mooncakelabs/pg_mooncake

4 · Component Repositories & Releases

pg_mooncake — Real-Time Columnstore & Iceberg Lakehouse

pg_mooncake (v0.3.0) adds real-time columnstore mirror tables (USING mooncake) to PostgreSQL, bundling moonlink v0.0.1 and duckdb_mooncake v0.0.2 alongside pg_duckdb v1.2.0.

Availability Matrix (pg_mooncake)

Package Downloads (pg_mooncake)

Verification & Build Repositories

All RPM and DEB packages in the Pigsty PGSQL repository are GPG-signed and verified automatically by dnf / apt once configured via pig repo add pgsql. Every package is built transparently from open-source build specs: