| From: | Thomas Good <tomg(at)admin(dot)nrnet(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Cleaning up template 1 -> template0 cloning |
| Date: | 2002-03-25 21:00:25 |
| Message-ID: | Pine.LNX.4.05.10203251559460.12541-100000@admin.nrnet.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Josh - from the pg docs:
Note: template1 and template0 do not have any special status beyond
the fact that the name template1 is the default source database
name for CREATE DATABASE and the default database-to-connect-to for
various scripts such as createdb. For example, one could drop
template1 and recreate it from template0 without any ill effects.
This course of action might be advisable if one has carelessly
added a bunch of junk in template1.
------------------------------------------------------------------------
Thomas Good tomg(at)admin(dot)nrnet(dot)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
------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-25 21:03:49 | Re: About EXECUTE in pl/pgsql |
| Previous Message | Thomas Good | 2002-03-25 20:58:31 | Re: Cleaning up template 1 |