---
title: timescaledb_post_restore() | Tiger Data Docs
description: Perform required operations after finishing a database restore
---

Since [0.9.0](https://github.com/timescale/timescaledb/releases/tag/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](/docs/deploy/self-hosted/migration/entire-database/index.md).

## 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 |