Forum OpenACS Q&A: Response to restore dump from 7.0.3 to 7.1.2 Problem

Posted by Bob OConnor on

PROBLEM SOLVED! Yes, I was using Pascal's document.... I didn't tell all.... I am using Virtual Jerry's * Aolserver setup running another site on same box same IP address. We upgraded the single postgresql from 7.0.3 to 7.1.2 and on that site there were minor errors mostly due to missing stuff: survey-simple.sql and table users_special_quotas which I loaded with psql and all was well.

So When adding our other site from the other server, I did a
createdb -T template1 mydbname
psql -d template1 -f pg_dumpoutput

I did this above command and added at the end
... > ta_dumplog
which mainly shows a bunch of creates....last two times, it seemed like the terminal locked up... no verbose text to screen... I just watched "TOP" to see when it was done... It takes a long time to restore our 129 Mbytes!

I found the same errors, particularly the missing survey-simple.sql that prevented any (data) page from appearing. SO now all is well...

Onto a seamless DomainName migration plan where I do this AGAIN with fresh HOT data. (Almost as hot as it is here in Maine --- hi 90's today)

And for lurkers I'll do this first...

dropdb mydbname

Then you can tell me to Go Jump in a Lake, Bob!


*Ref for email users: Virtual Jerry