• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (beta1)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

pg_restore

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)
• 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)
  • option --no-publications added (commit 96e1cb4c)
  • option --no-subscriptions added (commit 26aa1cf3)
• PostgreSQL 9.6
  • option -t/--table now matches all types of relations (commit 5671aaca)
  • option --strict-names added (commit d0242602)
• PostgreSQL 9.5
  • option --enable-row-security added (commit 491c029d)
  • 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.1
  • option --no-security-labels added (initial commit c8e0c321)
• 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.3
  • option --disable-triggers added (commit 9f0ae0c8)
• PostgreSQL 7.1
  • added (initial commit 500b62b0)

References

Categories

See also