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
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 |