Postgres Pro
Downloads
Home   >   mailing lists

Re: restoring template1 - Mailing list pgsql-admin

From Tom Lane
Subject Re: restoring template1
Date
Msg-id 1030.1013637792@sss.pgh.pa.us
Whole thread Raw
In response to restoring template1  (Roy Cabaniss <rcaban@cabanisspc.uamont.edu>)
Responses Re: restoring template1  (Roy Cabaniss <rcaban@cabanisspc.uamont.edu>)
List pgsql-admin
Tree view 
Roy Cabaniss <rcaban@cabanisspc.uamont.edu> writes:
> So how can I get the original template1 back from template0

DROP DATABASE; CREATE DATABASE.   Note the comments in
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html#MANAGE-AG-TEMPLATEDBS

            regards, tom lane

pgsql-admin by date:

Previous
From: dalgoda@ix.netcom.com (Mike Castle)
Date:
Subject: Re: restore whoes
Next
From: Manuel Trujillo
Date:
Subject: Locale support