Herb Blacker <herbblacker(at)isgenesis(dot)com> writes:
> How do I set up a new template1?
See "Template Databases" in
http://developer.postgresql.org/docs/postgres/managing-databases.html
With the exception of the advice to do VACUUM FREEZE, everything said
there applies to 7.1 as well as 7.2.
regards, tom lane