Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by postgresql.org (Postfix) with ESMTP id 57333475CCF for ; Mon, 25 Mar 2002 15:56:57 -0500 (EST) Received: from mailhost.nrnet.org (unknown [166.84.192.39]) by mail1.panix.com (Postfix) with ESMTP id 9AFB14872D; Mon, 25 Mar 2002 15:56:57 -0500 (EST) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id g2PKkBV21036; Mon, 25 Mar 2002 15:46:11 -0500 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id PAA12507; Mon, 25 Mar 2002 15:58:31 -0500 Date: Mon, 25 Mar 2002 15:58:31 -0500 (EST) From: Thomas Good To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: Cleaning up template 1 In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/326 X-Sequence-Number: 7202 On Mon, 25 Mar 2002, Josh Berkus wrote: > Folks, > > Due to an accident with a script, I created about 200 objects in the > template1 database instead of the database for which they were > intended. > I am now faced with either deleting each of these object individually, > or dumping my whole postgresql installation and re-installing each > user database, one at a time. > > Can anyone suggest any shortcuts for fixing this problem? Josh, Isn't template0 around for events like this? (maybe if template1 goes missing, etc...) I read somewhere that you can drop template1 and recreate it from template0... Tom ------------------------------------------------------------------------ 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 ------------------------------------------------------------------------