Enable TimescaleDB

This page is archived. Fly Postgres (unmanaged) is no longer maintained, and Fly.io Support is not able to provide support or guidance for it. We now offer Fly.io Managed Postgres, our fully-managed database service that handles all aspects of running production PostgreSQL databases.

These pages are kept for reference and are not listed in the navigation. The full set is indexed on the Fly Postgres (Unmanaged) page.

TimescaleDB is an open source time-series database built on top of PostgreSQL. It is a powerful tool for analyzing time-series data, and is a great fit for many applications you might run on Fly.io.

The default Fly Postgres app no longer includes the TimescaleDB extension. To enable TimescaleDB, provision a new Postgres app using our TimescaleDB-adapted image.

Provision a new Postgres app with TimescaleDB

Specify the postgres-flex-timescaledb image with the --image-ref flag:

fly pg create --image-ref flyio/postgres-flex-timescaledb:16

Create the extension

Connect to your postgres database:

# Connect to your target database
fly pg connect --app <database-app-name>

From the postgres=# % prompt, create the extension:

CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

(Optional) Attach to an app

 fly pg attach <database-app-name> --app <app-name>