Andy Colson <andy(at)camavision(dot)com> writes:
> I have an 8.2 database that has full text searching. I tried to
> backup/restore it to 8.3 but got lots of errors:
> ...
> I didn't really expect it to totally work, but I'm not sure how to move
> my db.
Did the data transfer over? The declarations of the former contrib
functions would of course fail, but type tsvector is still there.
I would like to think that ignoring pg_restore's whining would get
you most of the way there.
(As noted in the beta release notes, somebody really really needs to
write a migration guide for existing tsearch2 users.)
regards, tom lane