pg_restore

Restore a PostgreSQL database from an archive file created by pg_dump.

=> More information.

• Restore an archive into an existing database:

pg_restore -d {db_name} {archive_file.dump}

• Same as above, customize username:

pg_restore -U {username} -d {db_name} {archive_file.dump}

• Same as above, customize host and port:

pg_restore -h {host} -p {port} -d {db_name} {archive_file.dump}

• List database objects included in the archive:

pg_restore --list {archive_file.dump}

• Clean database objects before creating them:

pg_restore --clean -d {db_name} {archive_file.dump}

• Use multiple jobs to do the restoring:

pg_restore -j {2} -d {db_name} {archive_file.dump}

Copyright © 2014—present the tldr-pages team and contributors.

This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

=> CC-BY