pg_restore

A core utility for restoring a PostgreSQL database from an archive file previously created by pg_dump

pg_restore is a core utility for restoring PostgreSQL database from an archive file previously created by pg_dump.

pg_restore was added in PostgreSQL 7.1.

Change history

PostgreSQL 12
- output no longer directed to STDOUT by default; -f - must be specified explicitly (commit 413ccaa7)
PostgreSQL 11
- option --no-comments added (commit 1368e92e)
PostgreSQL 10
- option -N/--exclude-schema added (commit 46b55e7f)
PostgreSQL 9.6
- option -t/--table now matches all types of relations (commit 5671aaca)
- option --strict-names added (commit d0242602)
PostgreSQL 9.5
- redundant -i/--ignore-version option removed (commit 232cd63b)
PostgreSQL 9.4
- option --if-exists added (commit 9067310c)
- multiple -I/--index, -P/--function, -T/--trigger and -n/--schema options now accepted (commit da85fb47)
PostgreSQL 9.3
- option -t/--table can be provided multiple times (commit f3af5344)
PostgreSQL 9.2
- option --section added (commit a4cd6abc)
PostgreSQL 9.0
- superfluous command line arguments will result in a warning (commit e507a3ee)
PostgreSQL 8.4
- parallel database restore added (commit 775f1b37)
- option -w/--no-password added (commit 9de59fd1)
- option --role added (commit b0a6ad70)
- option --no-tablespaces added (commit 68528d37)
PostgreSQL 8.2
- option --no-data-for-failed-tables added (commit c61607bd)
- option -1/--single-transaction added (commit 3957cf6e)
PostgreSQL 8.1
- option -n/--schema added (commit ebc86498)
PostgreSQL 8.0
- option -e/--exit-on-error added (commit daa076c4)
- option --use-set-session-authorization added (commit dc0e76ca)
PostgreSQL 7.1
- added (initial commit 500b62b0)