| 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: | Whole Thread | Raw Message | 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
| 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 |