pg_restore
List of commands for pg_restore:
-
pg_restore:tldr:1bd61 pg_restore: List database objects included in the archive.$ pg_restore --list ${archive_file-dump}try on your machineexplain this command
-
pg_restore:tldr:4c478 pg_restore: Same as above, customize host and port.$ pg_restore -h ${host} -p ${port} -d ${db_name} ${archive_file-dump}try on your machineexplain this command
-
pg_restore:tldr:59581 pg_restore: Restore an archive into an existing database.$ pg_restore -d ${db_name} ${archive_file-dump}try on your machineexplain this command
-
pg_restore:tldr:6f1e3 pg_restore: Same as above, customize username.$ pg_restore -U ${username} -d ${db_name} ${archive_file-dump}try on your machineexplain this command
-
pg_restore:tldr:7a534 pg_restore: Clean database objects before creating them.$ pg_restore --clean -d ${db_name} ${archive_file-dump}try on your machineexplain this command
-
pg_restore:tldr:82157 pg_restore: Use multiple jobs to do the restoring.$ pg_restore -j ${2} -d ${db_name} ${archive_file-dump}try on your machineexplain this command