Mark <[EMAIL PROTECTED]> writes:
> So far we have tried normal switches on the end of pg_dump, including
> -Fc, -c, C, with corresponding switches on the pg_restore command. When
> the restore actually executes, it does not fully drop the DB prior to
> restoration so any test tables added to the DB after a dump are still
> there after a restore.
I think you want to drop the database explicitly. Something like
pg_dump -Fc mydb >mydb.dump
...
dropdb mydb
pg_restore -C -d template1 mydb.dump
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
