From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Adib <amslist@gmail.com>
Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problems Upgrading from 8.2 to 9.0
Date: Wed, 22 Dec 2010 10:32:14 +0100
Message-ID: <1293010334.20992.108.camel@deimos> (raw)
In-Reply-To: <AANLkTi=wwgju-3P71nkvjneSx-JKEHf3V8pg70XChFwY@mail.gmail.com>
References: <AANLkTinL+uS+8kCNyJ9aCKzDOw1QHN++6L-=0TRioPUD@mail.gmail.com>
<1293000296.2291.2.camel@hp-laptop02.gunduz.org>
<AANLkTi=tOebJxZKZeFKngAzDiZhG3FC1vRiiDVCvE+nz@mail.gmail.com>
<AANLkTi=wwgju-3P71nkvjneSx-JKEHf3V8pg70XChFwY@mail.gmail.com>
Adib, contrib/tsearch2.sql is a compatibility interface in order to
avoid having to rewrite your application for > 8.3 tsearch2.
In 8.3, tsearch2 was included in core. However, functions and procedures
changed. So, a contrib module was included in order to translate old
tsearch2 calls to new tsearch2.
So, uninstalling tsearch2 in 8.2 will make your search not work.
You will have also to deal with a change in data typing. Before 8.3,
data typing checks where very lazy. After 8.3, these checks are hard.
So, you will have to rewrite SQL sentences like this:
SELECT * from table where integer='1' -> SELECT * from table where
integer=1 or SELECT * from table where integer='1'::integer
so types match.
Migrating from 8.2 to 8.3 and higher versions can be a hard task if you
have to check lot of SQL code.
-----Original Message-----
From: Adib <amslist@gmail.com>
To: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problems Upgrading from 8.2 to 9.0
Date: Wed, 22 Dec 2010 00:01:14 -0800
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@gmail.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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com, amslist@gmail.com, devrim@gunduz.org
Subject: Re: Problems Upgrading from 8.2 to 9.0
In-Reply-To: <1293010334.20992.108.camel@deimos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox