pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Sadove <jsadove@beltion.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: DROPped database doesn't go away Postgres7.4
Date: Wed, 01 Sep 2004 18:54:11 -0400
Message-ID: <11084.1094079251@sss.pgh.pa.us> (raw)
In-Reply-To: <1094068710.413629e6d540d@webmail.no-ip.com>
References: <1094068710.413629e6d540d@webmail.no-ip.com>

Joseph Sadove <jsadove@beltion.net> 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



view thread (2+ messages)

Message-ID: <11084.1094079251@sss.pgh.pa.us>
Permalink:  ../11084.1094079251@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/11084.1094079251@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, jsadove@beltion.net
  Subject: Re: DROPped database doesn't go away Postgres7.4
  In-Reply-To: <11084.1094079251@sss.pgh.pa.us>
  References: <1094068710.413629e6d540d@webmail.no-ip.com> <11084.1094079251@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox