Re: [INTERFACES] destroydb and createdb

Tim Kane <timk(at)hotgames(dot)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