Contents
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 a 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)
- output no longer directed to
- PostgreSQL 11
- option
--no-comments
added (commit 1368e92e)
- option
- PostgreSQL 10
- option
-N
/--exclude-schema
added (commit 46b55e7f)
- option
- PostgreSQL 9.6
- PostgreSQL 9.5
- redundant
-i
/--ignore-version
option removed (commit 232cd63b)
- redundant
- PostgreSQL 9.4
- PostgreSQL 9.3
option
-t/--table
can be provided multiple times (commit f3af5344)
- PostgreSQL 9.2
- option
--section
added (commit a4cd6abc)
- option
- PostgreSQL 9.0
- superfluous command line arguments will result in a warning (commit e507a3ee)
- PostgreSQL 8.4
- PostgreSQL 8.2
- PostgreSQL 8.1
- option
-n
/--schema
added (commit ebc86498)
- option
- PostgreSQL 8.0
- PostgreSQL 7.1
- added (initial commit 500b62b0)
References
- PostgreSQL documentation: pg_restore