15.10. Restore

After you have selected a valid backup file, EDB-Studio will read the contents of the file when you press the View button. This may take some time, depending on the size of the file. You can watch the progress on the Messages tab. After the examination has completed, EDB-Studio will display the contents on the Contents tab.

Intentionally, the tool will not create the database to be restored. In order to restore a database, first create it using EDB-Studio, and then start the restore tool with that fresh database selected. The data will be restored to that database.

You can restore a single object, when in restore database mode (this is displayed in the title bar, as in this example). After examining the backup file, you can select the desired table from the Contents tab, and check the Single Object box. Only that table will be restored.

You can select a table as restore destination. EDB-Studio will restore its data if it is present in the backup file.

In order to use backup, the pg_restore tool must be accessible by EDB-Studio. This can be accomplished by having it locatable using the path, or by copying it into the same directory where the EDB-Studio executable resides.