tsearch2: restoring problem

From: Fischer Ulrich <ulrich(dot)fischer(at)aerodynamics(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: tsearch2: restoring problem
Date: 2004-02-16 13:57:47
Message-ID: 4030CC5B.8070308@aerodynamics.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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
psql:restoretest.out:28223: lost synchronization with server, resetting
connection

There should be made an additional entry for my german dicts. But it isn't.

Thanks for your help.

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(dot)fischer(at)aerodynamics(dot)ch www.ruag.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2004-02-16 14:45:10 Re: Dazed and Confused
Previous Message Mark Gibson 2004-02-16 13:54:24 Re: postgresql system column errors