Re: tsearch2: restoring problem

Tom Lane wrote:
> Fischer Ulrich <ulrich.fischer@aerodynamics.ch> writes:
>
>>I have a problem with the restoring of a database which uses tsearch2. I
>>made a backup as discribed in 'tsearch-v2-intro' on the tsearch2 page.
>>Now i'm trying to restore it into a testdatabase. The problem is, that
>>the entries of the relations 'pg_ts_cfg', 'pg_ts_cfgmap', 'pg_ts_dict'
>>and 'pg_ts_parser' are not correctly restored. I get errors like:
>
>
>>psql:restoretest.out:28223: ERROR:  copy: line 1, Cannot insert a
>>duplicate key into unique index pg_ts_dict_pkey
>
>
> Guessing, but it kinda sounds like you are trying to restore into a
> database that already contains tsearch2 support.  If you've installed
> tsearch2 into template1 then this is a likely gotcha, since the tsearch2
> objects will propagate into any database cloned from template1.  If
> that's the problem then the answer is to create your database from
> template0 instead of template1 before you run the restore.  See the
> CREATE DATABASE man page and/or the discussion of template databases in
> the administrator's guide.
>
>             regards, tom lane
>
>
Thanks for your help. I can't remember to install tsearch2 into
template1. But anyway, I used now template0 and got the same error. I've
just seen, when I load the schema.sql of my db that there is already
something wrong:

  ERROR:  ALTER TABLE / PRIMARY KEY multiple primary keys for table
'pg_ts_dict' are not allowed
ERROR:  ALTER TABLE / PRIMARY KEY multiple primary keys for table
'pg_ts_parser' are not allowed
ERROR:  ALTER TABLE / PRIMARY KEY multiple primary keys for table
'pg_ts_cfg' are not allowed
ERROR:  ALTER TABLE / PRIMARY KEY multiple primary keys for table
'pg_ts_cfgmap' are not allowed

The input of tsearch2.sql runs error free. Bevor reading schema.sql, I
modified it like described in 'tsearch-v2-intro' (removing all tsearch2
relatet functions, data types and operators). Because of other errors
and because these four relations are already defined by tsearch2.sql, I
also removed their definition in schema.sql.

regards

Ulrich

--
Ulrich G. Fischer                       Dipl. Natw. ETH
Center Aerodynamics                     Ruag Aerospace
P.O. Box 301                            CH-6032 Emmen
Tel. +41 41 268 23 53                   Fax. +41 41 268 38 97
ulrich.fischer@aerodynamics.ch          www.ruag.com