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
Then
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!
THANK YOU!
--
*Ref for email users: Virtual Jerry
http://www.theashergroup.com/tag/articles/nsvhr/virtual-hosting-howto