PostgreSQL Configuration by Baji Shaik

Author:Baji Shaik
Language: eng
Format: epub
ISBN: 9781484256633
Publisher: Apress

Restore Your Database

Until now, we have talked about backup types. Let us look at restoring database backups (logical and physical).

Logical Backups

There are two ways to restore a PostgreSQL database:psql for restoring from a plain SQL script file created with pg_dump

pg_restore for restoring from a .tar file, directory, or custom format created with pg_dump

Restoring a Plain Dump File

It is pretty simple to restore a plain dump file generated by pg_dump. You can just use the “psql” utility for that. The following is an example:psql -d db -U user -p port -h host -f dump_file.sql

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.