Postgres Pro
Downloads
Home   >   mailing lists

Thread: Templates

Templates

From
Herb Blacker
Date:
How do I set up a new template1?
My coworker has changed it and now needs to get back to the original.
I need to recreate the original template1.
Do I just rm template1 and do a createdb, cp template0 to template1,  or
is there a command I'm missing to do this?

Thanks,_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com

Re: Templates

From
Tom Lane
Date:
Herb Blacker <herbblacker@isgenesis.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