Backup & Restore a PostgreSQL Database with Postgis enabled Posted September 20th, 2011 by vsumner & filed under Database, Development, GIS. Backup: pg_dump -Fc dbname > dbname.dmp Restore: pg_restore -Fc -d dbname dbname.dmp