tsearch2: restoring problem

Поиск
Список
Период
Сортировка
От Fischer Ulrich
Тема tsearch2: restoring problem
Дата
Msg-id 4030CC5B.8070308@aerodynamics.ch
обсуждение исходный текст
Ответы Re: tsearch2: restoring problem
Список 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.fischer@aerodynamics.ch          www.ruag.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Mark Gibson
Дата:
Сообщение: Re: postgresql system column errors
Следующее
От: Terry Lee Tucker
Дата:
Сообщение: Re: Dazed and Confused