From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tim Kane <timk@hotgames.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] destroydb and createdb
Date: Wed, 09 Feb 2000 02:57:53 -0500
Message-ID: <4878.950083073@sss.pgh.pa.us> (raw)
In-Reply-To: <38A1153A.A17051CE@hotgames.com>
References: <38A1153A.A17051CE@hotgames.com>
Tim Kane <timk@hotgames.com> writes:
> I've been doing a heck of a lot of createdb and destroydb 'ing of
> late.....
> All of a sudden... When I destroy my database, and recreate it... It
> still retains some of the tables, indexes and sequences.....
> Even when I drop the tables, destroy the db, and recreate the db...
> Those specific tables, indexes and sequences are recreated with the
> database... Along with the data within those tables.
"createdb" actually consists of cloning whatever is in the template1
database (which is why it's called a template). I'll bet you got
confused at some point and created some user tables in template1
instead of where you intended to. Now they get cloned into new user
databases. This behavior is often construed as a feature, since
it does have its uses if you know what you're doing.
If you need to get back to a pristine state, wipe your whole
installation and initdb (after making a pg_dump backup of course!);
or you can try to clean out the cruft in template1.
regards, tom lane
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, timk@hotgames.com
Subject: Re: [INTERFACES] destroydb and createdb
In-Reply-To: <4878.950083073@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