Skip to content
pg_lake_iceberg

pg_lake_iceberg

pg_lake : Iceberg implementation in Postgres

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
2565
pg_lake_iceberg
pg_lake
3.4
OLAP
Apache-2.0
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
Schemaslake_iceberg pg_catalog
Requires
pg_lake_engine
plpgsql
Need By
pg_lake_copy
pg_lake_table
Siblings
pg_lake
pg_extension_base
pg_extension_updater
pg_map
pg_lake_engine
pg_lake_table
pg_lake_copy

The control file declares pg_lake_engine; canonical metadata also retains plpgsql because the install SQL uses PL/pgSQL. plpgsql is installed by default in normal PostgreSQL databases.

Extension SQL/control version is 3.4; source and DEB/RPM package version is 3.4.0.

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
PIGSTY
3.4
18
17
16
15
14
pg_lakepg_lake_engine, plpgsql
RPM
PIGSTY
3.4.0
18
17
16
15
14
pg_lake_$v-
DEB
PIGSTY
3.4.0
18
17
16
15
14
postgresql-$v-pg-lake-
Linux / PGPG18PG17PG16PG15PG14
el8.x86_64
MISS
MISS
MISS
MISS
MISS
el8.aarch64
MISS
MISS
MISS
MISS
MISS
el9.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
el9.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
el10.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
el10.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
d12.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
d12.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
d13.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
d13.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u22.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u22.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u24.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u24.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u26.x86_64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS
u26.aarch64
PIGSTY 3.4.0
PIGSTY 3.4.0
PIGSTY 3.4.0
MISS
MISS

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_iceberg;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION pg_lake_iceberg CASCADE; -- requires pg_lake_engine, plpgsql

Usage

Sources:

pg_lake_iceberg — Iceberg implementation in Postgres

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

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

The upstream project is associated with Snowflake; verify its current support, license, packaging, and deployment boundary from the linked source.

The curated lifecycle is active. Pin the reviewed build and verify maintenance status before adoption. The official material contains an experimental, deprecated, unsupported, or explicit warning boundary; read it in full and test failure cases before non-lab use.

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.

Last updated on