X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84A895E46C1 for ; Wed, 1 Sep 2004 19:54:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47139-08 for ; Wed, 1 Sep 2004 22:54:10 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 73A885E3632 for ; Wed, 1 Sep 2004 19:54:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i81MsB8d011085; Wed, 1 Sep 2004 18:54:11 -0400 (EDT) To: Joseph Sadove Cc: pgsql-admin@postgresql.org Subject: Re: DROPped database doesn't go away Postgres7.4 In-reply-to: <1094068710.413629e6d540d@webmail.no-ip.com> References: <1094068710.413629e6d540d@webmail.no-ip.com> Comments: In-reply-to Joseph Sadove message dated "Wed, 01 Sep 2004 15:58:30 -0400" Date: Wed, 01 Sep 2004 18:54:11 -0400 Message-ID: <11084.1094079251@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/16 X-Sequence-Number: 14719 Joseph Sadove writes: > When I DROP it again and just re- CREATE it, without doing anything, all the > schemas and objects are there as if I never dropped it. It sounds to me like you have put a bunch of junk into the template1 database. This was a bad move :-(. What you can do as far as restoring your old database goes is to create your new database using template0 instead of template1 as the source. See http://www.postgresql.org/docs/7.4/static/manage-ag-templatedbs.html In the longer term, you might want to go back to a pristine template1. It's possible to drop template1 and recreate it from template0, but there are some gotchas to dodge. Look up the detailed description of how to do it at techdocs.postgresql.org --- I don't have the exact URL at hand. regards, tom lane