Re: Problems Upgrading from 8.2 to 9.0

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Adib <amslist(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems Upgrading from 8.2 to 9.0
Date: 2010-12-22 06:44:56
Message-ID: 1293000296.2291.2.camel@hp-laptop02.gunduz.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adib 2010-12-22 06:54:07 Re: Problems Upgrading from 8.2 to 9.0
Previous Message Adib 2010-12-22 06:39:32 Problems Upgrading from 8.2 to 9.0