I am moving our database from an old server we had to the server
ArsDigita donated to our club a couple months ago.
I vacuumdb'd our database, dumped it, loaded postgres.sql in the new
machine and loaded the database. I don't know why but the whole thing
would be loaded, all the tables show up with d but no rows!
Look at the logs, correct one thing here and there, drop, create,
reload. After a couple dropdb/createdb I noticed that when I load the
dump file the output shows that all tables are already there, even if
I just dropped/created the whole database.
To test, I did dropdb and then createdb. This should give me a fresh
empty database, no matter what. When i got into psql and do a d,
voila, all my tables are still there. Any ideas?
The only "weird" thing I have in this installation of PG is that I
built it with Unicode support. Is that a problem?