This guide explains how to install the pg_lakehouse extension inside an existing PostgreSQL database. These instructions are for deploying on Linux Debian/Ubuntu. If you are using a different version of Linux, please contact us.

​

Prerequisites

Ensure that you have superuser access to the Postgres database.

​

Install pg_lakehouse

ParadeDB provides prebuilt binaries for the pg_lakehouse extension on Debian 11, Debian 12, Ubuntu 22.04 and Red Hat Enterprise Linux 9 for Postgres 14, 15 and 16 on both amd64 (x86_64) and arm64. They can be found in GitHub Releases. If you are using a different version of Postgres or a different operating system, you will need to build the extension from source.

​

Using Prebuilt Binaries

# Example for Ubuntu 22.04, don't forget replace the OS, arch and Postgres for your system
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.8.6/pg_lakehouse-v0.8.6-ubuntu-22.04-amd64-pg16.deb" -o /tmp/pg_lakehouse.deb
sudo apt-get install -y /tmp/*.deb

Note: You can replace v0.8.6 with the pg_lakehouse version you wish to install, and pg16 with the version of Postgres you are using.

​

Building from Source

Please follow these instructions.

​

Update postgresql.conf

Next, add pg_lakehouse to shared_preload_libraries in postgresql.conf.

shared_preload_libraries = 'pg_lakehouse'

Reload your PostgreSQL server for these changes to take effect.

​

Load the Extension

Once the extension binary is installed on your system, connect to your Postgres database via your client of choice (e.g. psql) and run the following command:

CREATE EXTENSION pg_lakehouse;

That’s it! For next steps, follow the quickstart guide.