Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems Upgrading from 8.2 to 9.0 - Mailing list pgsql-admin

From Adib
Subject Re: Problems Upgrading from 8.2 to 9.0
Date
Msg-id AANLkTi=tOebJxZKZeFKngAzDiZhG3FC1vRiiDVCvE+nz@mail.gmail.com
Whole thread Raw
In response to Re: Problems Upgrading from 8.2 to 9.0  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: Problems Upgrading from 8.2 to 9.0
List pgsql-admin
Tree view
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@gunduz.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

pgsql-admin by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Problems Upgrading from 8.2 to 9.0
Next
From: kubus__puchatek@tlen.pl
Date:
Subject: how made procedure returned different types of value?