> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# timescaledb_post_restore()

> Perform required operations after finishing a database restore

export const TIMESCALE_DB = 'TimescaleDB';

<Icon icon="tag" iconType="duotone" /> Since [0.9.0][tsdb-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][pg-dump-restore].

## Samples

Prepare the database for normal use after a restore:

```sql theme={"dark"}
SELECT timescaledb_post_restore();
```

## Returns

| Column  | Type    | Description                                  |
| ------- | ------- | -------------------------------------------- |
| success | BOOLEAN | TRUE if the operation completed successfully |

[pg-dump-restore]: /migrate/postgres/pg-dump-and-restore

[tsdb-0.9.0]: https://github.com/timescale/timescaledb/releases/tag/0.9.0