timescaledb_pre_restore()

Perform the required operations so that you can restore the database using pg_restore. Specifically, this sets the timescaledb.restoring GUC to on and stops any background workers which could have been performing tasks.

The background workers are stopped until the timescaledb_post_restore() function is run, after the restore operation is complete.

For more information, see [Migrate using pg_dump and pg_restore].

After using timescaledb_pre_restore(), you need to run timescaledb_post_restore() before you can use the database normally.

Prepare to restore the database:

===== PAGE: https://docs.tigerdata.com/api/api-tag-overview/ =====

Examples:

Example 1 (bash):

psql [your connect flags] -d your_timescale_db < dump_meta_data.sql > dumpfile.txt

Example 2 (sql):

SELECT get_telemetry_report();

Example 3 (sql):

SELECT timescaledb_post_restore();

Example 4 (sql):

SELECT timescaledb_pre_restore();