Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by postgresql.org (Postfix) with ESMTP id 57947475CB2 for ; Mon, 25 Mar 2002 15:56:56 -0500 (EST) Received: from mailhost.nrnet.org (unknown [166.84.192.39]) by mail1.panix.com (Postfix) with ESMTP id 49F594870B; Mon, 25 Mar 2002 15:56:56 -0500 (EST) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id g2PKm7821044; Mon, 25 Mar 2002 15:48:07 -0500 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id QAA12603; Mon, 25 Mar 2002 16:00:25 -0500 Date: Mon, 25 Mar 2002 16:00:25 -0500 (EST) From: Thomas Good To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: Cleaning up template 1 -> template0 cloning In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/327 X-Sequence-Number: 7202 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@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 ------------------------------------------------------------------------