Re: PG 8.2.0 - TSearch2 "Wrong affix file format" - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: PG 8.2.0 - TSearch2 "Wrong affix file format"
Date
Msg-id 458AB14A.5090503@sigaev.ru
Whole thread Raw
In response to PG 8.2.0 - TSearch2 "Wrong affix file format"  ("Tarabas (Manuel Rorarius)" <tarabas@tarabas.de>)
Responses Re: PG 8.2.0 - TSearch2 "Wrong affix file format"
List pgsql-general
Send to me dict and aff file, pls

By the way, tsearch2 is changed significantly, so, the better way to update is a
restoring only your data&schema. Tsearch2 should be installed from contrib.

Tarabas (Manuel Rorarius) wrote:
> Hi!
>
>   I have a problem migrating my Database using TSearch2 with the UTF-8
>   Backport from 8.1.3 to a new database with 8.2.0.
>
>   I successfully installed postgres and the TSearch2 distributed with
>   it and copied the german.aff/german.med/german.stop and
>   german.stop.ispell from my old postgres 8.1.3 installation to the
>   same location in the 8.2.0 install.
>
>   Then I dumped the old database with
>
>   "./pg_dump <database> -f backup-file" and restored it on the
>   8.2.0 database successfully without errors.
>
>   I am using UTF-8 database and files for .aff/.med/.stop/.stop.ispell
>
>   When I now try a TSearch2 Command like
>
>   "SELECT set_curdict('de_ispell');"
>
>   I get the error
>
>   "ERROR:  Wrong affix file format" although the file was not changed
>   and worked fine on the 8.1.3 Databse with the UTF-8 backport Patch
>   from 8.2.0.
>
>   Anyone have any idea how to fix the files so they will work with
>   8.2.0 also? The files seem to be ok and are UTF-8 encoded.
>
> Best regards
> Manuel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org/

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Brandon E Hofmann
Date:
Subject: Website Hosting Service and Security
Next
From: "Tarabas (Manuel Rorarius)"
Date:
Subject: Re: PG 8.2.0 - TSearch2 "Wrong affix file format"