Templates
Started by Herb Blackerover 24 years ago2 messagesgeneral
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
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