Migrating data to TimescaleDB from a different PostgreSQL database

note

To migrate between TimescaleDB databases, for example from self-hosted TimescaleDB to Timescale Cloud, see the .

Before you begin, check that you have:

  • within your PostgreSQL instance
  • Installed the PostgreSQL pg_dump utility
  • Installed a client for connecting to PostgreSQL. These instructions use , but any client works.

Migrate your data into TimescaleDB

Migrate your data into TimescaleDB from a different PostgreSQL database.

  1. Recreate these tables in your destination database by copying out of the file.

  2. Connect to your destination database.

  3. Turn tables that contain time-series data into hypertables by using the function. This function must be run on a table while it’s empty. For example, for a time-series table named conditions that uses as its time partitioning column, run:

  4. Insert the data from the into your destination database’s hypertables. For detailed instructions, see the CSV import guide.

To learn what you can do with your hypertable data, read about common .