pg_lake_engine

pg_lake : Query engine for data lake queries

Overview

Packages

Source

pig build pkg pg_lake;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_lake;		# install via package name, for the active PG version
pig install pg_lake_engine;		# install by extension name, for the current active PG version

pig install pg_lake_engine -v 18;   # install for PG 18
pig install pg_lake_engine -v 17;   # install for PG 17
pig install pg_lake_engine -v 16;   # install for PG 16

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_extension_base';

Create this extension with:

CREATE EXTENSION pg_lake_engine CASCADE; -- requires pg_extension_base, pg_map

Usage

Sources:

• Official upstream documentation

pg_lake_engine — Query engine for data lake queries

The reviewed catalog snapshot records version 3.4, kind preload, and implementation language C. Install and validate the declared extension dependencies first: pg_extension_base, pg_map. The curated compatibility set is 16,17,18; confirm the exact build against the target server.

CREATE EXTENSION "pg_lake_engine";
SELECT extversion
FROM pg_extension
WHERE extname = 'pg_lake_engine';

The curated lifecycle is active. Pin the reviewed build and verify maintenance status before adoption.

Before production use, review the linked control/SQL or provider documentation, verify privileges and compatibility, and test the actual API and failure behavior on the target PostgreSQL build.