Installation

Install pg_mooncake using one of the following methods:

1. Docker Image

Pull and run the pg_mooncake Docker image:

docker pull mooncakelabs/pg_mooncake
docker run --name mooncake-demo -e POSTGRES_HOST_AUTH_METHOD=trust -d mooncakelabs/pg_mooncake

This starts a PostgreSQL 17 instance with the pg_mooncake extension. Connect to it using psql:

docker run -it --rm --link mooncake-demo:postgres mooncakelabs/pg_mooncake psql -h postgres -U postgres

2. From Source

Compile and install the pg_mooncake extension. Supported PostgreSQL versions: 14, 15, 16, and 17.

git submodule update --init --recursive
make release -j$(nproc)
make install

3. Neon Postgres

  1. First, create a Neon project
  2. Enable beta extensions:Neon Postgres:
SET neon.allow_unstable_extensions='true';

Before creating your first table, navigate to Cloud Storage to bring your object store bucket. It is not recommended to create a columnstore table locally on Neon.

Enable the extension

CREATE EXTENSION pg_mooncake;