timescaledb_post_restore()
Perform required operations after finishing a database restore
Since 0.9.0
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
Section titled “Samples”Prepare the database for normal use after a restore:
SELECT timescaledb_post_restore();Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| success | BOOLEAN | TRUE if the operation completed successfully |