Author: Joe <joseph(at)lotus-partners(dot)net>
Page: 7.4/manage-ag-dropdb.html
----
I cannot re-create a database properly.
I did a dump all of one database that runs on production.
I copied the dmp file to dev environment, DROPped the existing database, CREATEd the database anew and then ran the dump in psql to recreate the database.
The database (and/or db server) seems all scrambled now.
The new database seems unchanged from the one I DROPped.
When I DROP it again and re- CREATE it, without doing anything, all the schemas and objects are there as if I never dropped it.
This is extremely bizarre. Any help is vastly appreciated.