pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feeddestroydb and createdb
3+ messages / 3 participants
[nested] [flat]
* destroydb and createdb
@ 2000-02-09 07:20 Tim Kane <timk@hotgames.com>
0 siblings, 2 replies; 3+ messages in thread
From: Tim Kane @ 2000-02-09 07:20 UTC (permalink / raw)
To: pgsql-interfaces
Uhhh,
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.
I could only assume that destroydb is not successfully removing the
appropriate files from the system....
Where should I look for these files so that I can manually remove them?
(or is this a very bad idea?)
Thanks heaps..
Tim.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] destroydb and createdb
@ 2000-02-09 07:57 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tim Kane <timk@hotgames.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2000-02-09 07:57 UTC (permalink / raw)
To: Tim Kane <timk@hotgames.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] destroydb and createdb
@ 2000-02-09 09:33 Ivo Simicevic <ivo@ultra.hr>
parent: Tim Kane <timk@hotgames.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ivo Simicevic @ 2000-02-09 09:33 UTC (permalink / raw)
To: Tim Kane <timk@hotgames.com>; +Cc: pgsql-interfaces
On Wed, Feb 09, 2000 at 06:20:26PM +1100, Tim Kane wrote:
> Uhhh,
>
> 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.....
>
Drop tables in template database and then recreate your database.
Ivo.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-02-09 09:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-09 07:20 destroydb and createdb Tim Kane <timk@hotgames.com>
2000-02-09 07:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-02-09 09:33 ` Ivo Simicevic <ivo@ultra.hr>
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