Re: Cleaning up template 1 -> template0 cloning - Mailing list pgsql-sql

From Thomas Good
Subject Re: Cleaning up template 1 -> template0 cloning
Date
Msg-id Pine.LNX.4.05.10203251559460.12541-100000@admin.nrnet.org
Whole thread Raw
In response to Re: Cleaning up template 1  (Thomas Good <tomg@admin.nrnet.org>)
Responses Re: Cleaning up template 1 -> template0 cloning  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Josh - from the pg docs:      Note: template1 and template0 do not have any special status beyond    the fact that the
nametemplate1 is the default source database    name for CREATE DATABASE and the default database-to-connect-to for
variousscripts such as createdb. For example, one could drop    template1 and recreate it from template0 without any
illeffects.    This course of action might be advisable if one has carelessly    added a bunch of junk in template1.


------------------------------------------------------------------------
Thomas Good                                         tomg@admin.nrnet.org
Programmer/Analyst                                  phone:  718-818-5528
Residential Services, Behavioral Health Services    fax:    718-818-5056
Saint Vincent Catholic Medical Centers              mobile: 917-282-7359
--                                                                    --
SQL Clinic - An Open Source Clinical Record            www.sqlclinic.net
------------------------------------------------------------------------



pgsql-sql by date:

Previous
From: Thomas Swan
Date:
Subject: Re: Cleaning up template 1
Next
From: Bruce Momjian
Date:
Subject: Re: About EXECUTE in pl/pgsql