Re: drop + create database restores previous tables and data

Maybe you restored to template1 by mistake?

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Douglas Toltzman
> Sent: Monday, May 23, 2005 4:38 AM
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] drop + create database restores previous
> tables and data
>
> I just installed Postgres v 8.0.3. I loaded by databases,
> then decided to reload a database. I dropped the database
> with dropdb (I also tried DROP DATABASE in pgsql), then I
> recreated the database with createdb.
> When I tried to reload the data from the database dump, I got
> errors because the relations and data were already in the
> newly created database. I've since tried dropping and
> recreating several times.
> After dropping and creating, I can connect to the database
> and see all of the data that was there before dropping the
> database; without reloading anything.
>
> At this early stage, I can remove everything and recreate the
> entire installation from scratch, but this will create a real
> problem in the future.
>
> Douglas Toltzman, Oak Street Software, Inc.
> voice: 910-526-5938
> http://www.oakstreetsoftware.com/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>