timescaledb_post_restore()

Perform required operations after finishing a database restore

Perform the required operations after you have finished restoring the database using pg_restore. Specifically, this resets the timescaledb.restoring GUC and restarts any background workers.

For more information, see Migrate using pg_dump and pg_restore.

Samples

Prepare the database for normal use after a restore:

SELECT timescaledb_post_restore();

Returns

Column	Type	Description
success	BOOLEAN	TRUE if the operation completed successfully