Maybe you restored to template1 by mistake? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Toltzman > Sent: Monday, May 23, 2005 4:38 AM > To: pgsql-bugs@postgresql.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 > >
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
