Marti,
As far as I can tell, the only way to remove the template1 database is to rename it.
Templates are databases with the datistemplate column set to true. A superuser can: UPDATE pg_database SET datistemplate=false where datname='blah'; DROP DATABASE blah; As far as Pg is concerned, there is no problem with removing the template1 or postgres databases. That is not (or may not be) the case for some utilities and Linux distributions out there that expect them to exist where used as defaults. I haven't yet tried removing template0. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
