I solved my problems by using the uninstall scripts located in the share/contrib in 8.2 to get rid of tsearch2 and fuzzymatch and that eliminated a lot of the errors I was running into.
Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching.
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: > ERROR: type "tsvector" is only a shell > ERROR: operator class "gin_tsvector_ops" does not exist for access > method > "gin
*IIRC*, you need to load contrib/tsearch2.sql to database *before* restoring your backup.