Updating ParadeDB

​

Overview

ParadeDB ships all of its functionality via Postgres extensions. All updates to ParadeDB can be received by updating one or more of the following extensions:

1. pg_lakehouse for accelerated analytical queries
2. pg_search for full text search
3. pgvector for dense and sparse vector search

​

Getting the Current Version

To inspect the current version of an extension, run the following command.

SELECT extversion FROM pg_extension WHERE extname = '<extension_name>';

​

Updating to a New Version

If a new version of pg_search or pg_analytics is available, it will be listed in the changelog. Here, you can view the changes made and decide if you want to upgrade. Note that some updates may alter an extension’s API interface.

The latest pg_search and pg_analytics will always be pegged to the same version. pgvector, on the other hand, is created and maintained outside of ParadeDB, so it maintains its own version. Users should refer to the pgvector README for documentation on its latest changes.

​

From ParadeDB Cloud

Run the following command to upgrade to a specific version of an extension.

ALTER EXTENSION <extension_name> UPDATE TO '<version_number>';

​

From ParadeDB Docker Image

Run the following command to pull a specific version of the Docker Image. You can set the version number to latest to pull the latest Docker image.

docker pull paradedb/paradedb:<version_number>

​

From Self-Managed Postgres

First, download and install the extension you wish to upgrade in the same way that it was initially installed. Then, run

ALTER EXTENSION <extension_name> UPDATE TO '<version_number>';