CmdID

CmdID / Commands

pg_restore

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

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Restore an archive into an existing database

pg_restore --dbname db_name archive_file.dumpIdentify

Restore an archive into an existing database, using a specific username

pg_restore --username username --dbname db_name archive_file.dumpIdentify

Restore an archive into an existing database, using a specific host and port

pg_restore --host host --port port --dbname db_name archive_file.dumpIdentify

List database objects included in the archive

pg_restore --list archive_file.dumpIdentify

Clean database objects before creating them

pg_restore --clean --dbname db_name archive_file.dumpIdentify

Use multiple jobs to do the restoring

pg_restore --jobs 2 --dbname db_name archive_file.dumpIdentify