PostgreSQL: Dumping Databases

Dump and restore of a database in PostgreSQL is simple:

Dump:

  $ pg_dump dbname > outfile

Restore:

  $ psql dbname < infile

References

1. PostgreSQL 8.1.13 Documentation – Chapter 23. Backup and Restore