From: | Henrik Zagerholm <henke(at)mac(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem |
Date: | 2006-12-07 09:35:06 |
Message-ID: | F5C37B28-EDCE-4851-9753-C5A6967512E4@mac.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
I've downloaded and compiled the new 8.2 to a new debian box.
I also compile and installed tsearch2 support.
Now I have a db on a 8.1.5 box with tsearch2 support.
How do a dump and restore my database to the new 8.2 box?
I get all kinds of errors when trying to restore the db.
Should I uninstall tsearch2 before dumping or?
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 67; 1255 26918
FUNCTION snb_ru_init(internal) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could
not find function "snb_ru_init" in file "/usr/local/pgsql/lib/
tsearch2.so"
Command was: CREATE FUNCTION snb_ru_init(internal) RETURNS internal
AS '$libdir/tsearch2', 'snb_ru_init'
LANGUAGE c;
pg_restore: [archiver (db)] could not execute query: ERROR: function
public.snb_ru_init(internal) does not exist
Command was: ALTER FUNCTION public.snb_ru_init(internal) OWNER
TO postgres;
WARNING: errors ignored on restore: 2
Regards,
Henrik
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2006-12-07 09:44:30 | Re: Cast boolean to text |
Previous Message | Henrik Zagerholm | 2006-12-07 09:34:32 | Re: SOLVED Uninstall pg_trgm |