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