Where is tsearch2.sql

On 18/05/2009 23:28, Howard Cole wrote:

Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot
find contrib/tsearch2.sql - I need to import an 8.2 backup with the old
tsearch2 but cannot find the new compatibility layer sql file.

Hi there,

tsearch2 was incorporated into the PostgreSQL core as of version 8.3, so
you won't find it in contrib any more. :-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Raymond O'Donnell wrote:

On 18/05/2009 23:28, Howard Cole wrote:

Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot
find contrib/tsearch2.sql - I need to import an 8.2 backup with the old
tsearch2 but cannot find the new compatibility layer sql file.

Hi there,

tsearch2 was incorporated into the PostgreSQL core as of version 8.3, so
you won't find it in contrib any more. :-)

Ray.

Thanks Ray - but according to the postgres manual (8.3.7) there is a SQL
file (contrib/tsearch2.sql) which allows me to import backups that were
created with the old tsearch2 (v8.2). I know this because I have used it
before - however this file no longer appears in the latest pginstaller.

Howard.

Please help :(

I have tried to install postgres 8.3.7 on three machines using the
pginstaller and none of them appear to install the contrib/tsearch2.sql
file.

If I look at my old installations (8.3.4 and 8.3.6) then the
contrib/tsearch2.sql file is there.

Is there a problem with my installation or is the file missing from the
latest pginstaller? I cannot find anything about this in the release
notes so I am assuming that it should still be there?

Thanks in advance.

Howard.

Howard Cole wrote:

Please help :(

I have tried to install postgres 8.3.7 on three machines using the
pginstaller and none of them appear to install the
contrib/tsearch2.sql file.

If I look at my old installations (8.3.4 and 8.3.6) then the
contrib/tsearch2.sql file is there.

Is there a problem with my installation or is the file missing from
the latest pginstaller? I cannot find anything about this in the
release notes so I am assuming that it should still be there?

Thanks in advance.

Howard.

OK I've worked it out.... The files are missing from pginstaller. They
are in the One Click installer however - so I suggest everyone use that
rather than the pginstaller if you need to import legacy tsearch2 data
in accordance with the manual.

Howard Cole
www.selestial.com