Re: Problems Upgrading from 8.2 to 9.0

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.

2010/12/21 Adib <amslist(at)gmail(dot)com>

> 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.
>
>
>
> 2010/12/21 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
>
> 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.
>>
>> Regards,
>> --
>> Devrim GÜNDÜZ
>> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
>> PostgreSQL RPM Repository: http://yum.pgrpms.org
>> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
>> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>>
>
>