Postgres Dump and Restore

Dump

$ pg_dump dbname > outfile

Restore

$ createdb -T template0 dbname

$ psql dbname < infile

Links

• http://www.postgresql.org/docs/8.1/interactive/backup.html#BACKUP-DUMP

• • Beacon Hill, a New York based technology solutions provider to financial firms with expertise in enterprise system development.