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 PostgreSQL database from an archive file previously created by pg_dump
.
pg_restore
was added in PostgreSQL 7.1.
Change history
- PostgreSQL 15
- option
--no-table-access-method
added (commit 21586288)
- option
- 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
- PostgreSQL 9.6
- PostgreSQL 9.5
- PostgreSQL 9.4
- PostgreSQL 9.3
- option
-t/--table
can be provided multiple times (commit f3af5344)
- option
- PostgreSQL 9.2
- option
--section
added (commit a4cd6abc)
- option
- PostgreSQL 9.1
- option
--no-security-labels
added (initial commit c8e0c321)
- 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.3
- option
--disable-triggers
added (commit 9f0ae0c8)
- option
- PostgreSQL 7.1
- added (initial commit 500b62b0)
References
- PostgreSQL documentation: pg_restore