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 amsl...@gmail.com
Is there some way to avoid restoring tsearch2 since full text searching is
...@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
-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
hostname
and import with pg_restore from 9.0 too.
-Original Message-
From: Adib amsl...@gmail.com
To: Iñigo Martinez Lasala imarti...@vectorsf.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problems Upgrading from 8.2 to 9.0
Date: Wed, 22 Dec 2010 01:51:53 -0800
Thanks for all
Hi,
I have a very old postgres 8.2 server which I want to upgrade to 9.0.2
server, the server are on different boxes and the 9.0.2 is fully running. I
think that my 8.2 contains tsreach2 which none of my applications use. The
postgres 8.2 is running on Windows 2003 server and 9.0.2 is running on
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
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 dev...@gunduz.org
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
ERROR: type tsvector is only a