Beacon Hill, Inc. Technology Solutions

Home > Knowledge Base > Dump and Restore

Postgres Dump and Restore

Dump


$ pg_dump dbname > outfile

Restore


$ createdb -T template0 dbname

$ psql dbname < infile

Links