💾 Archived View for freeshell.de › tldr › pg_restore.gmi captured on 2023-04-20 at 00:21:14. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

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