Postgres Pro
Downloads
Home   >   mailing lists

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

From Devrim GÜNDÜZ
Subject Re: Problems Upgrading from 8.2 to 9.0
Date
Msg-id 1293000296.2291.2.camel@hp-laptop02.gunduz.org
Whole thread Raw
In response to Problems Upgrading from 8.2 to 9.0  (Adib <amslist@gmail.com>)
Responses Re: Problems Upgrading from 8.2 to 9.0  (Adib <amslist@gmail.com>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Adib
Date:
Subject: Problems Upgrading from 8.2 to 9.0
Next
From: Adib
Date:
Subject: Re: Problems Upgrading from 8.2 to 9.0