I just upgraded my postgresql from version 7.3.9 to version 7.4.x and while my faq site (not on the production machine, because apparently itis being rebuilt soon) seems to work still, I did a 'tail -f' of the postgres errlog file and I am seeing a lot of errors when I access any page as follows:
(main index page)
ERROR: relation "faqsessions_sid_seq" does not exist
ERROR: syntax error at or near "," at character 49
(admin page)
ERROR: relation "sql_features" does not exist
ERROR: relation "sql_implementation_info" does not exist
ERROR: relation "sql_languages" does not exist
ERROR: relation "sql_packages" does not exist
ERROR: relation "sql_sizing" does not exist
ERROR: relation "sql_profiles" does not exist
now, if I hosed it, that is fine, I am ok with doing a re-install and starting over. There is nothing important there yet anyway
More than anything, I am interested in knowing what I may have done wrong when I performed the postgresql upgrade
first I did a "dumpall" (or was it dump_all) then upgraded postgresql, then rebuild php-pgsql and php-mysql (netbsd pkgsrc if you need to know) then imported the dumpfile back into a newly initialized database directory.
I am guessing that I did something incorrect somewhere, even though it is seemingly working still.
Any info appreciated
Greg