![]() This allows you to use the new database as the template for creating other databases.įirst, create a new database named dvdrental_tpl. Since PostgreSQL 9.2, you could use the -section option to restore table structure only. If you restore the database, which is the same as the one that you made the backup, you can use the following command: pg_restore -dbname=dvdrental -create -verbose c:\pgbackup\dvdrental.tar You can restore the dvdrentaldatabase in tarfile format generated by the pg_dump tool in the PostgreSQL backup database tutorial using the following command: pg_restore -dbname=newdvdrental -verbose c:\pgbackup\dvdrental.tar CREATE DATABASE newdvdrental Code language: SQL (Structured Query Language) ( sql ) Let’s create a new database named newdvdrentalfor practicing with the pg_restore tool. The pg_restore can take a database-backed up in the older version and restore it in the newer version.The pg_restore also allows you to restore specific database objects in a backup file that contains the full database.Currently, the pg_restore support this option for the only custom file format. Each thread restores a separate table simultaneously, which speeds up the process dramatically. The pg_restore allows you to perform parallel restores using the -j option to specify the number of threads for restoration.With pg_restore program, you have various options for restoration databases, for example: sql Code language: CSS ( css ) How to restore databases using pg_restoreīesides psqltool, you can use pg_restore program to restore databases backed up by the pg_dump or pg_dumpalltools. If you back up objects in a particular database, you can restore them using the following command: psql -U username -d database_name -f objects. If you want to stop restoring a database in case of errors, you add the -set ON_ERROR_STOP=on option: psql -U username - set ON_ERROR_STOP=on -f backupfile Code language: JavaScript ( javascript ) ![]() To restore a full backup and ignore any error occurred during the restoration process, you use the following command: psql -U username -f backupfile. By using the psql tool, you can execute the entire script in the dump file. The psql tool allows you to restore the SQL script file generated by the pg_dump, pg_dumpall or any other tools that generate compatible backed up files. Using pg_restore to restore tar file and directory format created by the pg_dump tool.Using psqlto restore plain SQL script file generated by pg_dump and pg_dumpall tools.In PostgreSQL, you can restore a database in two ways: Summary: in this tutorial, you will learn how to restore a database by using PostgreSQL restore tools including pg_restore and psql.īefore restoring a database, you need to terminate all connections to that database and prepare the backup file.
0 Comments
Leave a Reply. |