postgres=# UPDATE pg_database SET datistemplate="false" WHERE datname="template_postgis";
UPDATE 1
postgres=# DROP DATABASE template_postgis;
DROP DATABASE
postgres=#
postgres=# UPDATE pg_database SET datistemplate="false" WHERE datname="template_postgis";
UPDATE 1
postgres=# DROP DATABASE template_postgis;
DROP DATABASE
postgres=#