recreate database based on template database on postgresql

gistfile1.txt

As the template database can't be deleted directly, so should change it into non-template database first;

$ psql -U postgres postgres
$ update pg_database set datistemplate='f' where datname='template_database';
$ drop database template_database; 

create a database based on the defined template database;

$ createdb -T template_database newdatabase;