pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / P

• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

pg_dump

pg_dump is a core utility for backing up a single PostgreSQL database as an SQL script, TAR archive or custom archive file.

pg_dump has been part of PostgreSQL since it was first released.

Change history

Work-in-progress

• PostgreSQL 13
  • option --include-foreign-data added to dump data from foreign tables (commit 2f9eb313)
• PostgreSQL 11
  • option --no-comments added (commit 1368e92e)
• PostgreSQL 10
  • support for dumping from pre-8.0 versions removed (commit 64f3524e)
• PostgreSQL 9.5
  • redundant -i/--ignore-version option removed (commit 232cd63b)
• PostgreSQL 9.4
  • option --if-exists added (commit 9067310c)
• PostgreSQL 9.3
  • option -j/--jobs added for parallel dumping (commit 9e257a18)
• PostgreSQL 9.2
  • option --section added (commit a4cd6abc)
• PostgreSQL 8.2
  • option -t/--tables now pattern-matches in the same way as psql's \d command (commit 24e97528)
• PostgreSQL 8.0
  • start/stop times shown when -v/--verbose option used (commit 91366138)
• PostgreSQL 7.3
  • primary keys will be restrospectively added to tables with ALTER TABLE ... ADD PRIMARY KEY to avoid index creation penalty during a later restore (commit 5b5cef9a)
  • various output portability improvements (commit c828ec88)
  • support for objects larger than 2GB (commit 38e444aa)
• PostgreSQL 7.2
  • use pg_get_indexdef() function to generate CREATE INDEX commands and avoid emitting default opclasses (1929a90b)
  • NLS support added (commit b5593821)
• PostgreSQL 7.1
  • support for TAR output (commit c3e18804)
  • support for dumping large objects (commit e8f69be0)
• PostgreSQL 7.0
  • support for emitting COMMENT statements (commit 2eebcdde)
  • support for emitting PRIMARY KEY definitions (commit e639a1a6)
  • support for long command line options added (commit 5ca971a1)
• PostgreSQL 6.5
  • use single serializable transaction, meaning database can stay online while a dump is made (commit df9e539e)
  • dump ACLs by default (commit c615e77e)
  • option -x added to suppress dumping ACLs (commit c615e77e)
  • option -c added to drop objects before creation (commit 289a826d)
  • dump output format improved (commit 84107b41)
• PostgreSQL 6.4
  • support for dumping views added (commit b7ed6f85)
  • -n option added (commit 96019647)
  • -N option added (commit 89072303)
• PostgreSQL 6.3
  • -H option renamed to -h (commit c35d7fb8)

References

Categories

See also