Re: [ADMIN] Problems Upgrading from 8.2 to 9.0

2010-12-22 Thread Adib
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

Re: [ADMIN] Problems Upgrading from 8.2 to 9.0

2010-12-22 Thread Adib
to be moved 3) use psql to restore the databases on the new system On Wed, Dec 22, 2010 at 1:32 AM, Iñigo Martinez Lasala imarti...@vectorsf.com wrote: 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

[ADMIN] Problems Upgrading from 8.2 to 9.0

2010-12-21 Thread Adib
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

Re: [ADMIN] Problems Upgrading from 8.2 to 9.0

2010-12-21 Thread Adib
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