Reloading postgres databases with templates

gistfile1.txt

http://www.postgresql.org/docs/8.1/static/manage-ag-templatedbs.html

Step 1. Create a template of the DB you want to reload often.

e.g.
$ createdb -T my_db_name db_template_name


Step 2. Drop db and recreate from template when you need to reload.

e.g.
$ dropdb my_db_name && createdb -T db_template_name my_db_name