Restoring Exported Database
Veeam Explorer for PostgreSQL exports databases to the target destination as DUMP files. These files are portable across platforms and can be used to restore the original state of the databases with the pg_restore utility. For more information about this utility, see the PostgreSQL Documentation.
To restore an exported database, save the DUMP file to the necessary PostgreSQL server and run the following command:
$ pg_restore -p <port> -U <user> [-C] -d <database> <dump_file>
- <port> is the instance port.
- <user> is the user or owner of the database.
- -C creates a new database. Use this argument only if you want the pg_restore utility to create a new database.
Note that if you create a new database and the database in the DUMP file has tablespaces, you must manually create tablespaces with the same names as the ones in the DUMP file. The --no-tablespace argument of the pg_restore utility, which places databases in the default tablespace, is not supported for DUMP files exported with Veeam Explorer for PostgreSQL.
- <database> may stand for different databases depending on whether or not you use the -C argument.
- If you use the -C argument, <database> is the name of the database that pg_restore uses to run the necessary commands for restoring the database in the DUMP file, such as CREATE DATABASE.
- If you do not use the -C argument, <database> is the name of the target database. You can use the -c argument to overwrite the target database with the one in the DUMP file.
- <dump_file> is the path to the DUMP file.
$ pg_restore -p 5433 -U root -C -d sales /var/tmp/Import/export.dump